$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]

Reply via email to