Your very first mysql_fetch_array consumes the first result.
On Dec 19, 2010 8:19 AM, "Gary" <gp...@paulgdesigns.com> 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=joh...@pixelated.net
