$list = mysql_query("select id,title from table1"); while ($row = mysql_fetch_array($list)) { echo("$row[title]<br>\n"); }
-----Original Message----- From: Eric J Schwinder [mailto:[EMAIL PROTECTED]] Sent: den 1 oktober 2001 20:18 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] problem with WHILE loop Thanks to everyone who replied either here or via e-mail... I got a lot of great suggestions. I ended up solving the WHILE problem by changing this: > $list = mysql_query("select id,title from table1"); > $list_row = mysql_fetch_array($list); > $title = $list_row["title"]; > while($list_row) { > echo("$title <br>\n"); > } to this: $list = mysql_query("select id,title from table1"); $title = $list_row["title"]; while($list_row = mysql_fetch_array($list)) { echo("$title <br>\n"); } Eric Schwinder eric.AT.bergencomputing.DOT.com AT = @ DOT = (well... you know) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]