mysql_num_rows, resource id #
in [Databases]
|
Prev: Fwd: Re: [PHP-DB] numeric string to single digit array
Next: Fwd: Re: [PHP-DB] mysql_num_rows, resource id #
From: Richard Dunne on 27 Mar 2008 09:43 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; ?>
From: Evert Lammerts on 27 Mar 2008 10:06
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. |