Re: Problem with WHILE using MYSQL database
| From: | Curt Zirzow | Date: | Sun, 09 Jan 2005 15:24:20 +0000 |
| Subject: | Re: Problem with WHILE using MYSQL database | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-205905@lists.php.net to get a copy of this message | ||
* Thus wrote Labunski:
>
> $data = mysql_query("SELECT * FROM firt_table WHERE cat='sweaters' ORDER BY
>
id ASC ") or die("can't find DB!");
> while($line = mysql_fetch_array($data)){
> echo' <tr><td width="225"
> height="19"'.$line['product'].'</td></tr>';
> }
>
> for example, there are 3 records in the "first_table", so script will output
> only 3 records:
> <tr><td width="225"
> height="19"'.$line['product'].'</td></tr>
> <tr><td width="225"
> height="19"'.$line['product'].'</td></tr>
> <tr><td width="225"
> height="19"'.$line['product'].'</td></tr>
>
> It's ok. But I need to output 10 records always, even if there are less than
> 10 records in the database.
Just keep a counter for your while loop then output however meany
are left:
$i = 0;
while ($line = ...) {
$i++;
}
echo str_repeat('<tr><td> </td></tr>', 10 - $i);
or something to that effect.
Curt
--
Quoth the Raven, "Nevermore."