RE: [PHP] mysql php - while loops
After the loop has finished executing add another line
if ($i % $cols != $cols-1) { print /tr; }
Otherwise once the loop has finished if not EXACLTY $i % $cols == $cols-1
then there would be no /tr after the last row which could cause display
problems in the user agent (other than the fact that its putting out
incorrect html)
=S.
On Wed, 27 Feb 2002, Martin Towell wrote:
with a bit of cheating... use a table...
(nb: this code not tested, but logic has)
table
?
$results = mysql_query(SELECT ID, date, appleprice, orangeprice, pearprice
FROM fruits);
$i = 0; $cols = 4
while ($data = mysql_fetch_array($results))
{
if ($i % $cols == 0) echo tr
?
td?=$data[date]? - ?=$data[appleprice]?br
?=$data[orangeprice]? - ?=$data[pearprice]?/td
?
if ($i % $cols == $cols-1) echo /tr;
$i++;
}
?
/table
-Original Message-
From: Craig Westerman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 27, 2002 11:43 AM
To: php-general-list
Subject: [PHP] mysql php - while loops
The following lists 12 items from a fruits table.
$results = mysql_query(SELECT ID, date, appleprice, orangeprice, pearprice
FROM fruits);
while ($data = mysql_fetch_array($results))
{
?
p?=$data[date]? - ?=$data[appleprice]? -
?=$data[orangeprice]? - ?=$data[pearprice]?/p
?
}
How would I modify the loop to display 4 items then a row of fruit images
then 4 more items then another row of different fruit images and then
finally finish the loop displaying the final 4 items?
Thanks
Craig
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] mysql php - while loops
Thanks for the reply. This is what I came up with and it appears to work.
Thoughts?
Craig
[EMAIL PROTECTED]
$count = 1;
while ($data = mysql_fetch_array($results))
{
?
p?=$data[date]? - ?=$data[orangeprice]? -
?=$data[appleprice]? - ?=$data[pearprice]?/p
?
$count++;
if ( $count == 5 ) {
?IMG SRC=grape.gifbr?php
} elseif ( $count == 9 ) {
?IMG SRC=cherry.gifbr?php
}
}
**
-Original Message-
From: Martin Towell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 26, 2002 6:51 PM
To: 'Craig Westerman'; php-general-list
Subject: RE: [PHP] mysql php - while loops
with a bit of cheating... use a table...
(nb: this code not tested, but logic has)
table
?
$results = mysql_query(SELECT ID, date, appleprice, orangeprice, pearprice
FROM fruits);
$i = 0; $cols = 4
while ($data = mysql_fetch_array($results))
{
if ($i % $cols == 0) echo tr
?
td?=$data[date]? - ?=$data[appleprice]?br
?=$data[orangeprice]? - ?=$data[pearprice]?/td
?
if ($i % $cols == $cols-1) echo /tr;
$i++;
}
?
/table
-Original Message-
From: Craig Westerman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 27, 2002 11:43 AM
To: php-general-list
Subject: [PHP] mysql php - while loops
The following lists 12 items from a fruits table.
$results = mysql_query(SELECT ID, date, appleprice, orangeprice, pearprice
FROM fruits);
while ($data = mysql_fetch_array($results))
{
?
p?=$data[date]? - ?=$data[appleprice]? -
?=$data[orangeprice]? - ?=$data[pearprice]?/p
?
}
How would I modify the loop to display 4 items then a row of fruit images
then 4 more items then another row of different fruit images and then
finally finish the loop displaying the final 4 items?
Thanks
Craig
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] mysql php - while loops
with a bit of cheating... use a table...
(nb: this code not tested, but logic has)
table
?
$results = mysql_query(SELECT ID, date, appleprice, orangeprice, pearprice
FROM fruits);
$i = 0; $cols = 4
while ($data = mysql_fetch_array($results))
{
if ($i % $cols == 0) echo tr
?
td?=$data[date]? - ?=$data[appleprice]?br
?=$data[orangeprice]? - ?=$data[pearprice]?/td
?
if ($i % $cols == $cols-1) echo /tr;
$i++;
}
?
/table
-Original Message-
From: Craig Westerman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 27, 2002 11:43 AM
To: php-general-list
Subject: [PHP] mysql php - while loops
The following lists 12 items from a fruits table.
$results = mysql_query(SELECT ID, date, appleprice, orangeprice, pearprice
FROM fruits);
while ($data = mysql_fetch_array($results))
{
?
p?=$data[date]? - ?=$data[appleprice]? -
?=$data[orangeprice]? - ?=$data[pearprice]?/p
?
}
How would I modify the loop to display 4 items then a row of fruit images
then 4 more items then another row of different fruit images and then
finally finish the loop displaying the final 4 items?
Thanks
Craig
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
