Dont know what im doing wrong...

[Muk108]

Im not sure what im doing wrong, it keeps returning Select Failed! every time. Can you help me fix the problem thanks!

<? 
       mysql_connect("localhost","username","password") 
            or die("Unable to connect to SQL server"); 
        mysql_select_db("jokes") 
            or die("Unable to select database");
$query = "SELECT * FROM jokes";

$joke = mysql_query($query) or die("Select Failed!");
?>
<?php echo $joke['JokeText'];?>

[phpman]

try this

<? 
       mysql_connect("localhost","username","password") 
            or die("Unable to connect to SQL server"); 
        mysql_select_db("jokes") 
            or die("Unable to select database");
$query = "SELECT * FROM jokes";

$joke = mysql_query($query);
if (!$joke){echo mysql_error();}
?>
// and this won't work. it will echo Resource ID instead
// need to add mysql_fecth_array() to get this
<?php echo $joke['JokeText'];?>

[Muk108]

Its not returning any errors now, but i can't get it to print out the text from the database. Could you help me do this please. My database is layed out like this...

CREATE TABLE jokes (
  joke_id int(4) NOT NULL auto_increment,
  joke_name varchar(50) default NULL,
  joke_date datetime NOT NULL default '0000-00-00 00:00:00',
  joke_message text,
  PRIMARY KEY  (joke_id)
) TYPE=MyISAM;

Do you think you could help me display what is in the message part? I am have problems with this. Thank You.

[phpman]

Originally posted by phpman
try this

<? 
       mysql_connect("localhost","username","password") 
            or die("Unable to connect to SQL server"); 
        mysql_select_db("jokes") 
            or die("Unable to select database");
$query = "SELECT * FROM jokes";

$joke = mysql_query($query);
if (!$joke){echo mysql_error();}
    while ($row = mysql_fetch_array($joke)){
        echo $row['joke_id'];
        echo $row['joke_name'];
        echo $row['joke_message'];
        echo $row['joke_date'];
        echo"<br />"\n";

?>

[Muk108]

I tryed it exactly how you put it exept i change the username and password and it got this error. "Parse error: parse error, unexpected T_STRING, expecting ',' or ';' in C:\HTTP\www\test2.php on line 15"

[phpman]

oh sorry, change this line

echo"<br />"n";

to this

echo"<br />\n";

[Muk108]

After i fix that i get this error "Parse error: parse error, unexpected $ in C:\HTTP\www\test2.php on line 17"

[phpman]

hehe man I am not with it today. ad a } right after the last line you just fixed. so it all should look like this

<? 
       mysql_connect("localhost","username","password") 
            or die("Unable to connect to SQL server"); 
        mysql_select_db("jokes") 
            or die("Unable to select database");
$query = "SELECT * FROM jokes";

$joke = mysql_query($query);
if (!$joke){echo mysql_error();}
    while ($row = mysql_fetch_array($joke)){
        echo $row['joke_id'];
        echo $row['joke_name'];
        echo $row['joke_message'];
        echo $row['joke_date'];
        echo"<br />\n";
    }
?>

[Muk108]

Thank you very much for your help phpman. That works this time.

[phpman]