Another Error, but it's really stupid

[JonM]

18:

PHP Code:

<?php
19: 
20: $db = mysql_connect("http://www.cwhq.net","admin123","");
21: mysql_select_db (General,$db);
22: $result = mysql_query ("select * FROM News", $db);
23: echo "<tr><td>Title and Author</td><td>Story</tr>\n";
24: 
25: 
26: 
27: while ($myrow = mysql_fetch_row($result)) {
28: 
29: 
30: 
31:         printf("<tr><td>%s %s</td><td>%s</td></tr>\n",
32:         $myrow[1], $myrow[2], $myrow[3]);
33: }
34: 
35: ?>

Error:

PHP Code:

?> 


[katana*GFR*]

http://www.phphq.net/

Try there its a PHP site. From our berjubeled Admin Panther

[JonM]

i already know there, and post there. I'm trying to get a quicker response on this question though.

[Lakie]

whats the error?

[Scott]

<?php

mysql_connect("http://www.cwhq.net","admin123","");
mysql_select_db("General");



echo "<table border=\"0\"><tr><td>Title and Author</td><td>Story</td></tr>\n";

$query=mysql_query("SELECT * FROM News") or die("Theres an error in the mysql query: ".mysql_error());

while($result=mysql_fetch_array($query)) {
echo "<tr><td>".$result[title]." ".$result[author]."</td></tr>\n";
echo "<tr><td>".$result[story]."</td></tr>\n",
}
mysql_free_result($query);

echo "</table>\n";
?>

[JonM]

thanks panther man!