How to loop through all rows in mySQL

[zeeshan]

Hi all,

I need to loop through all the rows in my SQL table and process each row individually. How can we do that?

I tried "Select * from tablename" and then set up a for loop, but that simply gets the table. How can I go through each row of the table individually?

Thanks.

[theFinn]

Umm something like this should work:

$sql = "SELECT * FROM mytable";

if(!$result = mysql_query($sql))
{
   die("Couldn't run query"):
}

while($row = mysql_fetch_array($result))
{
  // Do what you want to $row, its now an array of the current row.
  echo $row['my_column'];
} 

That'll go though the results returned by the SELECT * and do something to each row... easy as 1 2 3.