Databases
StackOverflow2013
Postsdbo
POmysql_numrows() error in MySQL Query Web Page Display
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POmysql_numrows() error in MySQL Query Web Page Display
    text
    copied!<p>I am writing a web page that selects certain fields from a database that meet a criteria. A connection to the database is made, but nothing displays in the table but the header. In the Apache2 logs I see</p> <pre><code>[Mon May 07 01:30:21 2012] [error] [client MyIP] PHP Notice: Use of undefined constant localhost - assumed 'localhost' in /var/www/medical.php on line 3 [Mon May 07 01:30:21 2012] [error] [client MyIP] PHP Warning: mysql_numrows() expects parameter 1 to be resource, boolean given in /var/www/medical.php on line 7 </code></pre> <p>Here is the code I'm using:</p> <pre><code>&lt;?php include ("/var/www/medicalalerts-config.inc.php"); mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die("Unable to select database"); $query = "SELECT * FROM `1213-rep` WHERE medicalAlert &lt;&gt; \'\' and medicalAlert IS NOT NULL ORDER BY lastName, grade"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); ?&gt; &lt;!--Results Table--&gt; &lt;table border="1" align="center" cellspacing="2" cellpadding="2"&gt; &lt;tr&gt; &lt;th&gt;&lt;font face="Arial, Helvetica, sans-serif" &gt;Name&lt;/font&gt;&lt;/th&gt; &lt;th&gt;&lt;font face="Arial, Helvetica, sans-serif" &gt;Grade&lt;/font&gt;&lt;/th&gt; &lt;th&gt;&lt;font face="Arial, Helvetica, sans-serif" &gt;Medical Alert&lt;/font&gt;&lt;/th&gt; &lt;th&gt;&lt;font face="Arial, Helvetica, sans-serif" &gt;Parent 1 Name&lt;/font&gt;&lt;/th&gt; &lt;th&gt;&lt;font face="Arial, Helvetica, sans-serif" &gt;Parent 1 Phone&lt;/font&gt;&lt;/th&gt; &lt;th&gt;&lt;font face="Arial, Helvetica, sans-serif" &gt;Parent 2 Name&lt;/font&gt;&lt;/th&gt; &lt;th&gt;&lt;font face="Arial, Helvetica, sans-serif" &gt;Parent 2 Phone&lt;/font&gt;&lt;/th&gt; &lt;/tr&gt; &lt;?php $i=0; while ($i &lt; $num) { $f1=mysql_result($result,$i,"firstName"); $f2=mysql_result($result,$i,"lastName"); $f3=mysql_result($result,$i,"grade"); $f4=mysql_result($result,$i,"medicalAlert"); $f6=mysql_result($result,$i,"parent1Name"); $f7=mysql_result($result,$i,"parent1Phone"); $f8=mysql_result($result,$i,"parent2Name"); $f9=mysql_result($result,$i,"parent2Phone"); ?&gt; &lt;tr&gt; &lt;td&gt;&lt;font face="Arial, Helvetica, sans-serif" &gt;&lt;?php echo $f1; echo $f2;?&gt; &lt;/font&gt;&lt;/td&gt; &lt;td&gt;&lt;font face="Arial, Helvetica, sans-serif" &gt;&lt;?php echo $f3; ?&gt;&lt;/font&gt;&lt;/td&gt; &lt;td&gt;&lt;font face="Arial, Helvetica, sans-serif" &gt;&lt;?php echo $f4; ?&gt;&lt;/font&gt;&lt;/td&gt; &lt;td&gt;&lt;font face="Arial, Helvetica, sans-serif" &gt;&lt;?php echo $f5; ?&gt;&lt;/font&gt;&lt;/td&gt; &lt;td&gt;&lt;font face="Arial, Helvetica, sans-serif" &gt;&lt;?php echo $f6; ?&gt;&lt;/font&gt;&lt;/td&gt; &lt;td&gt;&lt;font face="Arial, Helvetica, sans-serif" &gt;&lt;?php echo $f7; ?&gt;&lt;/font&gt;&lt;/td&gt; &lt;td&gt;&lt;font face="Arial, Helvetica, sans-serif" &gt;&lt;?php echo $f8; ?&gt;&lt;/font&gt;&lt;/td&gt; &lt;/tr&gt; &lt;?php $i++; } ?&gt; &lt;/table&gt; </code></pre> <p>What do I need to do to fix it?</p> <p>--Update 1:51 AM - I added <code>$error_msg = mysql_error();</code> and <code>&lt;?php echo $error_msg ?&gt;</code> to my code and now I get <code>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'\' and medicalAlert IS NOT NULL ORDER BY lastName, grade' at line 1</code> What do I need to change in my query?</p> <p>--Update 1:54 AM - I fixed it. PHPMyAdmin added extra backslashed that I didn't need. Thanks!</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload