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' '; > } > > for example, there are 3 records in the "first_table", so script will output > only 3 record

[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' '; } for example, there are 3 records in the "first_table", so script will output only