while loop..

Anon

Ok, i created a guest book..
Then i place my php vauiables likke $name into and html table.. and it print it from the db just fine.. But it only prints that first line of info.. IT wont go to the next row after going through the html table once..
So how would i make it go until their was no more info in the db?
i was thinking a while loop, but still i not sure i understand how to write one o of those..
Thanks
Anthony

andreash

Yes, you'll need a loop.
A while loop or a for loop. I use a for loop for this, ex.

$bla = mysql_query("SELECT * FROM guestbook ORDER BY ID");
$rows = mysql_num_rows($bla);

for ($i == 0; $i < $rows; $i++) {
$info = mysql_fetch_array($bla);
echo "$info[name] has email $info[email]";
}

I guess that you don't understand the for statement, it's real easy...
First ($i == 0) it defines $i (array) to be 0 (zero).
Second ($i < $rows) if $i is smaller than the rows returned form mysql.
Third ($i++) pluses 1 to $i after writing the data you want.

The $info[name] is just ex. array.
Did this help?

Anon

Thanks!

polson

Check out :

http://www.php.net/manual/en/control-structures.while.php

Also, a couple mysql examples in manual use while loops, see :

http://www.php.net/manual/en/function.mysql-fetch-array.php

http://www.php.net/manual/en/function.mysql-fetch-object.php

And as Andreas suggests, a for loop will work too.