Posted by Ababo on 03/07/06 20:41

Hi everyone. I've only really just started using php and I've been
trying to use it in conjunction with mysql. I keep getting an error
though when trying to access the result set returned by performing a
query on the database. I've performed queries on the database outwith
php, and it correctly returned the correct details. Here's the code for
it:

<?php
$dbh=mysql_connect ("localhost", "myusername", "mypassword") or die ('I
cannot connect to the database because: ' . mysql_error());
mysql_select_db ("ababoc_filmlistings");

$sql = 'SELECT DISTINCT title FROM Listing';
$rs = mysql_query($sql);

$row = mysql_fetch_row($rs); // line 24
echo $row[0];

?>

but I end up with the error:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL
result resource in /home/ababoc/public_html/test/index.php on line 24

I'm really not sure what I could be doing wrong here. Any help would be
much appreciated.

[Back to original message]