I'm not sure what this line us all about: if (mysql_num_rows($result) == !'0') You're basically saying; if the number of rows is equal to the not of the string 0, what I think you may want in this case is just != 0. The next line is causing your problem though. You're grabbing the first row with that $row= line, and not doing anything with it. Take that out and it should be ok. Thanks, Ash http://www.ashleysheridan.co.uk ----- Reply message ----- From: "Gary" <gpaul@xxxxxxxxxxxxxxxx> Date: Sun, Dec 19, 2010 15:46 Subject: [PHP] All records not displaying... To: <php-general@xxxxxxxxxxxxx> I have an issue that the first record in a query is not being displayed. It seems that the first row in alphabetical order is not being brought to the screen. I have run the query in the DB and it displays the correct result, so it has to be in the php. I have a MySQL DB that lists beers. I have a column for 'type' of beer (imported, domestic, craft, light). The queries: $result = MySQL_query("SELECT * FROM beer WHERE type = 'imported' AND stock = 'YES' ORDER by beername "); When I run the query if (mysql_num_rows($result) == !'0') { $row = mysql_fetch_array($result); echo '<h3>Imported Beers</h3>'; echo '<table width="100%" border="0" cellspacing="1" cellpadding="1" id="tableone" summary=""> <th>Beer</th> <th>Maker</th> <th>Type</th> <th>Singles</th> <th>6-Packs</th> <th>Cans</th> <th>Bottles</th> <th>Draft</th> <th>Size</th> <th>Description</th>'; while ($row = mysql_fetch_array($result)) { echo '<tr ><td>' . $row['beername'].'</td>'; echo '<td>' . $row['manu'] . '</td>'; echo '<td>' . $row['type'] . '</td>'; echo '<td width="40">' . $row['singles'] . '</td>'; echo '<td width="20">' . $row['six'] . '</td>'; echo '<td width="40">' . $row['can'] . '</td>'; echo '<td width="20">' . $row['bottles'] . '</td>'; echo '<td width="40">' . $row['tap'] . '</td>'; echo '<td>' . $row['size'] . '</td>'; echo '<td>' . $row['descrip'] . '</td>'; '</tr>'; } echo '</table><br />'; } All but the first row in alphabetical order are displayed properly. Can anyone tell me where I am going wrong? -- Gary BTW, I do have a bonus question that is about javascript in this same file, so if anyone want to take a stab at that, I'll be happy to post it. __________ Information from ESET Smart Security, version of virus signature database 5715 (20101219) __________ The message was checked by ESET Smart Security. http://www.eset.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
