How to go through all the columns from a database row

[JustmeVSI]

Hy guys how can I go through each column of a result returned form the database.

In other words do this:

$command = "SELECT * FROM Persons";
$result = mysql_query($command);
while($row = mysql_fettch_array($result))
{
[INDENT]foreach($column in $row)
{
[INDENT]if($column!=null)
{
...
}[/INDENT]
}[/INDENT]
}

How to do the red part?

[pritaeas]

foreach ($row as $name => $value) { }

But if you do I recommend using mysql_fetch_assoc instead.

[JustmeVSI]

foreach ($row as $name => $value) { }

But if you do I recommend using mysql_fetch_assoc instead.

Perfect! Thank you.