Posted by Akhenaten on 05/19/07 03:10

Any suggestion as to why my fetch_array is bad?

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
result resource in /home/jkokko/public_html/ask/test.php on line 11
*******************
<?php
$dbHost = "localhost";
$dbUser = "user";
$dbPass = "pass";
$dbDatabase = "dbname";
//connet to the database
$db = mysql_connect("$dbHost", "$dbUser", "$dbPass") or die ("Error
connecting to database.");
mysql_select_db("$dbDatabase", $db) or die ("Couldn't select the
database.");

$result = "SELECT a_uid FROM `answers` WHERE `qid` = '13' LIMIT 0, 30,
$db";
while ($r = mysql_fetch_array($result)) {
echo $r;
}
?>
****************

[Back to original message]