displaying data in table cells

STXman

I want to output the results on my query onto a 3x4 table. Each cell on the table will contain the contents of a row from a table. How do I output data in the sequence shown below i.e Cell1, cell2, Cell3 …etc?

Table:

Cell1, Cell2, Cell3
Cell4, Cell5, Cell6
Cell7, Cell8, Cell9
Cell10, Cell11, Cell12

Please see my feeble attempt below where I have tried to populate 2 of the cells.

<?
echo "<table width='400' border='1' cellspacing='1' cellpadding='1'>";
$i = 1;
while ($row = mysql_fetch_assoc($myQuery))
{

$output[$i][0] = $row['FIRSTNAME'];
$output[$i][1] = $row['LASTNAME'];
$output[$i][2] = $row['GENDER'];
$output[$i][3] = $row['COUNTRY'];

		echo "This is i1: $i";	 
		echo "<tr>";
		echo "<td rowspan='3'></td>";
		echo "<td width = '10'>&nbsp;</td>";
		echo "<td rowspan='3'></td>";
		echo "</tr>";
		echo "<tr >";
		echo "<td>&nbsp;</td>";
		echo "</tr>";
		echo "<tr>";
		echo "<td>&nbsp;</td>";
		echo "</tr>";
		echo "<tr>";
		echo("<td><p>\n"

. "Firstname: " . $output[$i][0] . " \n"

. "Lastname: " . $output[$i][1] . " \n"

. "Country: " . $output[$i][2] . " \n"

. "contact:<hr style=\"color:grey;width:150;text-align:left;\">\n\n\n\n\n</td>");
echo "<td> </td>";

		 $i=$i++;
		 echo "This is i2: $i";
			echo("<td><p>\n"

devinemke

a simple example:

<?
// connect to db first

$result = mysql_query('SELECT * FROM table');
while ($row = mysql_fetch_assoc($result))
{
	$array[] = $row;
}

$array_chunks = array_chunk($array, 3);

echo '<table border="1">';
foreach ($array_chunks as $value)
{
	echo '<tr>';
	foreach ($value as $row)
	{
		echo '<td>';
		print_r($row);
		echo '</td>';
	}
	echo '</tr>';
}
echo '</table>';
?>

STXman

Thanx for replying. I have incorporated your suggestion but cant seem to get it working properly: it generates repeating columns of data when i click on the next page. How can I remove the duplicate data?

<?
$page = (!isset($GET['page']))? '0' : $GET['page'];

$country =(!isset($GET['country']))? '0' : $GET['country'];

$gender =(!isset($GET['gender']))? '0' : $GET['gender'];

echo "This is country: $country";

$limit = 10;
$sql_text = "SELECT *
FROM userdetails

WHERE country = '$country'
AND gender = '$gender'
ORDER BY id DESC LIMIT $page,10";

//query one (Get 10 rows)
$myQuery = mysql_query($sql_text);

$myQueryTwo = mysql_query($sql_text);

//$numRows = mysql_num_rows($myQueryTwo);

//echo "<table width='400' border='0' cellspacing='1' cellpadding='1'>";

while ($row = mysql_fetch_assoc($myQuery))

//$picture_path = $row['PICTURE_PATH'];
{
$array[] = $row;
}
$array_chunks = array_chunk($array, 3);

echo "<table border='1'>";
foreach ($array_chunks as $value)
{
echo "<tr>";
foreach ($value as $row)
{
echo("<td>\n"

. "Firstname: " . $row["FIRSTNAME"] . " \n"

. "Lastname: " . $row["LASTNAME"] . " \n"

. "Country: Test1" . $row["COUNTRY"] . " \n"

. "contact:<hr style=\"color:grey;width:150;text-align:left;\">\n\n\n\n\n</td>");
}
echo "</tr>";

}
echo "</table>";
$page = (!isset($GET['page']))? '0' : $GET['page'];

//Pagination below
$numRows = mysql_num_rows($myQueryTwo);//total rows

if(($page-1) < $numRows && $page != 0) {
//display previous
echo '<a href="MLresultsPageEnd2.php?page='.($page-1).'&country='.$country.'&gender='.$gender.'">Previous</a> ';

}

echo "This is numRows: $numRows";
//get Next link

if($numRows >= $limit){
echo '|<a href="MLresultsPageEnd2.php?page='.($page+1).'&country='.$country.'&gender='.$gender.'">Next</a>';

}