Very Frustrating Problem

pfunk880

I am simply trying to display one value from my database as a text script, but I am getting the following error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /mnt/web_a/d42/s07/a000ro2g/www/directories/listing.php on line 30

Here is my code:

$connection=mysql_connect($DBhost,$DBuser,$DBpass);
if (!$connection) { 
echo "Couldn't make a connection!"; 
exit; 
} 
$db=mysql_select_db("$DBName"); 
if (!$db) { 
echo "Couldn't select database!"; 
exit; 
} 
$result=mysql_query("SELECT * FROM table WHERE id='$id'");
$row=mysql_fetch_array($result);
print "Name: $row["fullname"]";

Please let me know if you need any clarification. Thanks in advance for help.

ahundiak

table is a reserved word so rename your table.

Also, mysql_error will usually give you a hint on why a query failed.

$result = mysql_query("SELECT this FROM that");
if (mysql_errno()) die(mysql_error());

pfunk880

***EDIT: Never mind, I figured it all out.

I changed the table name, and I no longer get the error. Thanks for the tip.

I have another question though. The following statement:

$result=mysql_query("SELECT * FROM $table WHERE id=$id");

should select all the fields in the database where the specified id is found (this is determined by a query in the URL, i.e. listing.php?id=1), right? So, if I used id=1 as my example, and Name, Email, and Address are my fields, I should get the records in those fields that correspond with id=1? (id is my primary key field) Currently, it seems to not be returning everything I want, but I'm not quite sure, so I'm interested to know what this query should be returning. I hope that made sense.

superwormy

That should return an array with the keys as the fieldnames, values as the values of the record in the database.