Display PHP Query Array in the table

Question

Hi all I would like to display my Query from Mysql on the table. However, my data is like this:

Array([0]=>data1, [1]=>data2, [2]=>data3,[3]=>data4,[4]=>pic1,[5]=>pic2,[6]=>pic3,[7]=>pic4);

I want to display my table as

|data1 | data2 |data3 |data4
|pic1  | pic2  |pic3  |pic4

I know how to display the data in the single ling like td or tr but not sure how to do tr and td on the same loop. Any helps? Thanks in advance!

while($query=mysql_fetch_array($dataQuery)){
//not sure what to do here.
}

Answer 1

<?php
$rows = mysql_fetch_array($dataQuery);
echo "<table><tr>";
foreach($rows as $num => $row){
    echo "<td>".$row[$num]."</td>"; // here we echo every object in array
    if($num%2 == 0){
        echo "</tr><tr>"; // if we get to a number witch can be divided by 2 we add a new table row
    }
}
echo "</tr></table>";
?>

i think this should work for you.

Answer 2

If you have lineal data but you know the number of columns you should try with a counter.

$columns = 2;
$ct = 0;
while($query=mysql_fetch_array($dataQuery)) {

    if ($ct % $columns == 0) echo "<tr>";

    echo '<td>' . query_data_to_extract . '</td>';
    $ct++;

    if ($ct % $columns == 0) echo "</tr>";

}

Answer 3

It's probably easier to assemble the two rows as strings first and then output them betwen table rows. You know how many items you have (number of rows), so divide that by two. Then subtract one from that number (you might want to check that it's even so you know you haven't made a mistake) to account for the fact arrays are zero-based. Loop over the whole array. Until you hit your halfway point, you're assembling your title row. After that you're assembling your picture row. Then echo the results between table row tags. Here's a rough (untested) shot at the code:

$rows = mysql_fetch_array($dataQuery);
$total_rows = mysql_num_rows($rows);
// check total_rows is even here?
$midpoint = $total_rows / 2 - 1;
$title_row = '';
$photo_row = '';
foreach($rows as $num => $row)
{
    $new_row = sprintf("\n\t<td>%s</td>", $row[0]);
    if ($num < $midpoint)
    {
        $title_row .= $new_row;
    }
    else
    {
        $photo_row .= $new_row;
    }
}

echo sprintf("\n<tr>%s</tr>", $title_row);
echo sprintf("\n<tr>%s</tr>", $photo_row);