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.
}
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);
<?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.
|data1 | data2 as the first row and |data3 | data4 as the second, |pic1 | pic2 as the third and |pic3 | pic4 as the fourth row?
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>";
}
query_data_to_extract?