Loop entire array

[slevytam]

Hello,

Could someone share how to loop an array(mysql_fetch_array)

and then display the field name and data of each element.

Thanks!

--SL

[cgraz]

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

   print "Field1: " . $row["field1"] . "<br>";
   print "Field2: " . $row["field2"] . "<br>";
   print "Field3: " . $row["field3"] . "<br>";

}

Cgraz

[slevytam]

Thanks for your reply.

The only problem is that I am unsure of the amount of fields in the array or their names...

Is there anyway to create a loop for each row?

--SL

[stolzyboy]

while($row = mysql_fetch_array($query)) {
echo $row['first_name_field] . " " . $row['last_name_field'] . "<br>";
}

this will do this for every record in your table

[cgraz]

If you don't know the names of the fields or even how many there are, use this:

$query = mysql_query("SELECT * FROM your_table") or die(mysql_error());

while($row = mysql_fetch_assoc($query)) {

   foreach($row as $key => $value) {
      echo ucfirst(str_replace("_", " ", $key)) . ": " . $value . "<br>\n";
   }

echo "<br><br>";

}

EDIT: the str_replace is incase you used underscores for spaces. That's what I do and in general what I've seen most people do.

Cgraz

[slevytam]

Thanks,

I give it a go and see what happens...

--SL