TalkPHP - View Single Post - MySQL

Salathe · 10-24-2007, 03:39 PM

Use the mysql_fetch_array function to fetch all of the relevant rows into a structured array, which you can then output to your pleasure.

For Example

PHP Code:


			
$data = array();
while ($row = mysql_fetch_array(...)) {
    $data[$row['type'][] = $row;
}

Then you can loop through the array outputting different HTML tables as you go.

10-24-2007, 03:39 PM	#4 (permalink)
Salathe Moderateur Join Date: Apr 2007 Posts: 1,393 Thanks: 5	Use the `mysql_fetch_array` function to fetch all of the relevant rows into a structured array, which you can then output to your pleasure. For Example PHP Code: `$data = array(); while ($row = mysql_fetch_array(...)) { $data[$row['type'][] = $row; }` Then you can loop through the array outputting different HTML tables as you go.