Data from table in multple cols

[dcjones]

Hi All,

I've spent the last few hours looking for any post that cover the subject of extracting data from a table and displaying it in more than one column.

Can this be done and if so can anyone point me in a direction for help and if possible an example.

[endurox]

<?php
// Formulate Query
$sql = ("SELECT table FROM database WHERE tablefield = 'record'");

// Perform Query
$result = mysql_query($sql);

// BEGIN :: Page Body
echo "<table>\n<tr>\n";

// Run Loop for Data Retreival
while($results = mysql_fetch_array($result)) {
	// Creates columns
	echo "<td align=\"center\">", $results['field'], "</td>\n";
} // end while loop

echo "</tr></table>\n";
// END :: Page Body

// Free the resultset...
mysql_free_result($result);
// close the database connection...
mysql_close($dblink);
?>

Should do it.... replacing the values with yours of course... and inserting the database connection information as an include file.