Acting on SQL results

Hi, I would like to know the best way of using results from an SQL query, I would do the following:

$sql = "SELECT * FROM blah blah";
$result = mysql_query($sql);
while ($myrow = mysql_fetch_array($result)) {
..blah blah..
}

But this is throwing up warnings, is there a better way to do this?
TIA

Shuriken1.

I'm not sure why that's not working, it looks ok to me.

I do mine like this, there may be a better way though.

$sql = "select * from bla";
$result = mysql_query($sql);
$num = mysql_num_rows($result);

for ($i=0; $i<$num; $i++) {
$myrow = mysql_fetch_array($result);
echo "bla";
}

Thanks for the tip csousley, that seems to have solved it 🙂.

Shuriken1.