How to read each row (one at a time) from table

my_filthy_mind

OK gurus, I could use a little basic help. I want to set up a loop to read each row one at a time from a table.

I figure if I use a FOR loop that I need to first determine how many rows are in the table using COUNT - what exactly would the code look like? Generally I don't like WHILE loops but would it be easier?

Secondly, how do I code the query statement for reading a row of values at a time (using the FOR variable "i" as above)?

Thanks in advance for helping this embarrassed newbie.

statrat

this help? it will select every row, every column from your table, then "fetch" each row from the result set, one row at a time, until there are none left.

$result=mysql_query("select * from table");

while($row=mysql_fetch_array($result)){

do something with $row['field1'];
do something with $row['field2'];

}

Drakla

Plus there's no need for the Count(*) thing that you suggest as after running a SELECT query mysql_num_rows($dbh) contains the number of returned rows. If you were doing insert, update or deletes the mysql_affected_rows($dbh) does the same thing.

While I'm here I've noticed that quite a few of the PHP functions have been either deprecated, or are actually just an alias to another call, eg.

mysql_create_db("DMDB")  == mysql_query("CREATE DATABASE DMDB) - deprecated
mysql_select_db("DND", $dbh)  ==  mysql_query("USE DND");
mysql_list_dbs() ==  mysql_query("SHOW DATABASES")
mysql_list_tables($dbName) == mysql_query("SHOW TABLES")
//leading to 
mysql_tablename($result, $i) and mysql_db_name($result, $i) are just aliases to mysql_result

It's all in the book, I'm just slapping it together.