List:General Discussion« Previous MessageNext Message »
From:Gary Date:December 19 2010 4:07pm
Subject:Re: Records not being displayed
View as plain text  
Johnny

Thank you for your response, and you are correct.  I have used that same 
code for a number of other files and dont recall having that problem 
(unfortunately, my recollection abilities seem to be withering).

So I removed the following lines and all works fine....I just wish I could 
recall why I had it in the first place.

if (mysql_num_rows($result) == !'0') {
$row = mysql_fetch_array($result);

Again, thank you for your help.

Gary


"Johnny Withers" <johnny@stripped> wrote in message 
news:AANLkTik3nHJqkc00iw-NV1qqPDeaJ1_5xTWbf7skdko7@ style="color:#666">stripped...
> Your very first mysql_fetch_array consumes the first result.
>
> On Dec 19, 2010 8:19 AM, "Gary" <gpaul@stripped> wrote:
>
> 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 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
>
>
>
> __________ Information from ESET Smart Security, version of virus 
> signature
> database 5715 (20101219) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>
>
> __________ Information from ESET Smart Security, version of virus 
> signature database 5715 (20101219) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
> 



__________ Information from ESET Smart Security, version of virus signature database 5715
(20101219) __________

The message was checked by ESET Smart Security.

http://www.eset.com




Thread
Records not being displayedGary19 Dec
  • Re: Records not being displayedJohnny Withers19 Dec
  • Re: Records not being displayedGary19 Dec