|
Posted by David Haynes on 03/07/06 21:24
Ababo wrote:
> 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.
>
Your query most likely threw an error invalidating the result set.
Try this:
$rs = mysql_query($sql);
if( mysql_num_rows($rs) == 0 ) {
echo mysql_error($dbh);
}
and see what you get.
-david-
Navigation:
[Reply to this message]
|