How to loop through multiple rows returned by a database?

[TheServant]

I know that there was a post on this a little while back but I can't find it.
[PHP] $raw_data = mysql_query(" SELECT *
FROM mytable
") or die(mysql_error());
$data = mysql_fetch_array($raw_data);
$size_data = count( $data );

if ( $data != NULL ) {
for ( $i=0; $i<=($size_data - 1); $i=$i+3 ) {
echo( "No.: ".$data['id']."<br />"
."Title: ".$data['name']."<br />"
."Date Posted: ".$data['date']."<br />" );
}
}
[/PHP]

This works for one row of data (in MySQL), however when there is two rows of data it just prints the first row data table twice and the actual second row of data is not shown. Can someone tell me if it is my syntax that I have wrong? Also, I haven't used a foreach loop much in php and I can't figure out how to do it when there is multiple values (one key though). I think that should be the way to do this but I have still not managed it.

Thanks in advance.

[r035198x]

1.) mysql_fetch_array returns only one row of data. You need to call mysql_fetch_array in a loop to get all the rows
2.)Where is the table that you want to populate? You need to be creating a new table row for every iteration in the loop.

Your loop should generally look something like

while($row = mysql_fetch_array($raw_data,)) {
//create the rows here
}
 

[TheServant]

That's exactly what I was looking for, cheers mate, problem solved!