Re: [PHP] All records not displaying...
I would say enabled error_reporting(E_ALL); error_reporting(-1);
Then use die(mysql_error()); with your mysql function to get some debugging
data.
Also use var_dump($query_name) to find out what is spits out.
Debugging is your best friend here. If you don't use die() or
error_reporting() then you will see a blank screen.
Ravi.
On Sun, Dec 19, 2010 at 9:01 PM, Gary gp...@paulgdesigns.com wrote:
Tamara Temple tamouse.li...@gmail.com wrote in message
news:c6993909-dd90-4f52-bf6b-ab888c281...@gmail.com...
On Dec 19, 2010, at 9:46 AM, Gary 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 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 '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
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.
This code will totally eliminate the first row of data.
if (mysql_num_rows($result) == !'0') {
$row = mysql_fetch_array($result);
Fetches the first row, but is not output. Because:
while ($row = mysql_fetch_array($result)) {
Fetches the second row before you do any output of the data.
Eliminate the first fetch_array and you're code should work fine.
BTW, if you put the td attributes 'width=n' in the preceding th
tags, you won't have to output them for each row. You should also put
the
units those numbers are associated with.
Tamara
Thank you for your help and thank you for the explaination. I removed the
line and it works fine. I dont remember where or why I had that line in
there, it is code that I have recycled for a while now.
Gary
__ Information from ESET Smart Security, version of virus signature
database 5716 (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
[PHP] All records not displaying...
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 '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
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
Re: [PHP] All records not displaying...
On Dec 19, 2010, at 9:46 AM, Gary 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 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 '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
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.
This code will totally eliminate the first row of data.
if (mysql_num_rows($result) == !'0') {
$row = mysql_fetch_array($result);
Fetches the first row, but is not output. Because:
while ($row = mysql_fetch_array($result)) {
Fetches the second row before you do any output of the data.
Eliminate the first fetch_array and you're code should work fine.
BTW, if you put the td attributes 'width=n' in the preceding th
tags, you won't have to output them for each row. You should also put
the units those numbers are associated with.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] All records not displaying...
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 gp...@paulgdesigns.com
Date: Sun, Dec 19, 2010 15:46
Subject: [PHP] All records not displaying...
To: php-general@lists.php.net
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 '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
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
Re: [PHP] All records not displaying...
Tamara Temple tamouse.li...@gmail.com wrote in message
news:c6993909-dd90-4f52-bf6b-ab888c281...@gmail.com...
On Dec 19, 2010, at 9:46 AM, Gary 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 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 '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
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.
This code will totally eliminate the first row of data.
if (mysql_num_rows($result) == !'0') {
$row = mysql_fetch_array($result);
Fetches the first row, but is not output. Because:
while ($row = mysql_fetch_array($result)) {
Fetches the second row before you do any output of the data.
Eliminate the first fetch_array and you're code should work fine.
BTW, if you put the td attributes 'width=n' in the preceding th
tags, you won't have to output them for each row. You should also put the
units those numbers are associated with.
Tamara
Thank you for your help and thank you for the explaination. I removed the
line and it works fine. I dont remember where or why I had that line in
there, it is code that I have recycled for a while now.
Gary
__ Information from ESET Smart Security, version of virus signature
database 5716 (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
