Records not being displayed

2010-12-19 Thread Gary 
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 'h3Imported Beers/h3';
  echo 'table width=100% border=0 cellspacing=1 cellpadding=1 
id=tableone summary=

  thBeer/th
  thMaker/th
  thType/th
  thSingles/th
  th6-Packs/th
  thCans/th
  thBottles/th
  thDraft/th
  thSize/th
  thDescription/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 '/tablebr /';

}

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=arch...@jab.org

Re: Records not being displayed

2010-12-19 Thread Johnny Withers 
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 'h3Imported Beers/h3';
 echo 'table width=100% border=0 cellspacing=1 cellpadding=1
id=tableone summary=

 thBeer/th
 thMaker/th
 thType/th
 thSingles/th
 th6-Packs/th
 thCans/th
 thBottles/th
 thDraft/th
 thSize/th
 thDescription/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 '/tablebr /';

}

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

Re: Records not being displayed

2010-12-19 Thread Gary 
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 fineI 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 joh...@pixelated.net wrote in message 
news:aanlktik3nhjqkc00iw-nv1qqpdeaj1_5xtwbf7skd...@mail.gmail.com...
 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 'h3Imported Beers/h3';
 echo 'table width=100% border=0 cellspacing=1 cellpadding=1
 id=tableone summary=

 thBeer/th
 thMaker/th
 thType/th
 thSingles/th
 th6-Packs/th
 thCans/th
 thBottles/th
 thDraft/th
 thSize/th
 thDescription/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 '/tablebr /';

 }

 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



 __ 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





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org