Re: [PHP] Problem with WHILE using MYSQL database

2005-01-09 Thread Curt Zirzow
* 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' trtd width=225 height=19'.$line['product'].'/td/tr'; } for example, there are 3 records in the first_table,

[PHP] Problem with WHILE using MYSQL database

2005-01-08 Thread Labunski
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' trtd width=225 height=19'.$line['product'].'/td/tr'; } for example, there are 3 records