Problem with WHILE using MYSQL database
| From: | Labunski | Date: | Sun, 09 Jan 2005 03:41:42 +0000 |
| Subject: | Problem with WHILE using MYSQL database | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-205892@lists.php.net to get a copy of this message | ||
Hi,
this script output's data from the database..
$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.
Can someone help me, please?
Lab