Re: [PHP-DB] mysql_num_rows, resource id #

Richard Dunne wrote:
> In my code below, I am trying to verify that the query is selecting data from both rows of my answers table.  I have run the query on my MySQL CLI and getting answers from both rows, but running this script I get $rows = 0.  I can't figure out why its not returning 2 for the number of rows.  It is not giving me any error msgs such as cannot connect.  
>
> Also can tell me where I can find documentation on resource id #, such as resource(5)?
> <?PHP
> DEFINE ("host","localhost");
> DEFINE ("user","root");
> DEFINE ("password","pasword");
> DEFINE ("database","questions");
>
> $connection=mysql_connect(host,user,password) or die ('Could not connect' . mysql_error() );
>
> $dbConnect=mysql_select_db('questions',$connection);
> if (!$dbConnect) {die ('Could not connect to database' . mysql_error() );}
>
> $result = mysql_query("Select answer from answers where studentID='A123456789'") or die(mysql_error());
> $rows = mysql_num_rows($result);
> echo $rows;
>
>
> ?>
Still no luck then. Try selecting the DB without the connection parameter:

$dbConnect=mysql_select_db('questions');

And don't forget to set error_reporting(E_ALL) above your code.