Re: Problem with WHILE using MYSQL database

[Curt Zirzow <php-general@xxxxxxxxxxxxxxxxx>]

* 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>&nbsp;</td></tr>', 10 - $i);

or something to that effect.

Curt
-- 
Quoth the Raven, "Nevermore."

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php