Re: Why dosen't this work!!!(No parse errors etc)
| From: | Remy Dufour | Date: | Wed, 19 Jun 2002 13:08:02 +0000 |
| Subject: | Re: Why dosen't this work!!!(No parse errors etc) | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-102921@lists.php.net to get a copy of this message | ||
Try this loop:
$query = "SELECT * FROM qoutes WHERE year <= $year AND week <= $week";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
echo '<p>';
echo $row['qoute'];
echo '</p><p align="right"><i>-- ';
echo $row['author'];
echo '</i></p><hr noshade>';
}
----- Original Message -----
From: webmaster@tececo.com
To: php-general@lists.php.net
Sent: Tuesday, June 18, 2002 8:48 AM
Subject: [PHP] Why dosen't this work!!!(No parse errors etc)
I have the following code:
$week = date("W");
$year = date("Y");
echo "$week<br>$year";
$query = "SELECT * FROM qoutes WHERE year <= $year AND week <= $week";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$num_results = mysql_num_rows($result);
for ($i=0; $i <5; $i++)
{
$row = mysql_fetch_array($result);
echo '<p>';
echo $row['qoute'];
echo '</p><p align="right"><i>-- ';
echo $row['author'];
echo '</i></p><hr noshade>';
It returns nothing... Why?