In order to get the results vertically aligned properly, you can use a table for your display. To caccomplish what you want: there are 2 ways of doing this:
(1) echo the fixed headers and fixed column values
(2) echo the content of your result dynamically, so when you change the no of columns in your select you don't have to change your echo statement.
The following code is for option 2 results:
[php]
// perform select query
$result=mysql_query("SELECT * from tablea")
or die ("invalid query: ".mysql_error());
// display only when there are results
if (mysql_num_rows($result) > 0) {
// get the number of columns inn the result
$numfields = mysql_num_fields($result);
// start the output table
echo "<table><tr>";
// loop and echo all column names
for ($i=0; $i < $numfields; $i++) { // header
echo '<th>'.mysql_field_name($result, $i).'</th>';
}
echo "</tr>";
// loop and display all column values
while ($row = mysql_fetch_row($result)) { // Data
echo '<tr><td>'.implode($row,'</td><td>')."</td></tr>";
}
// close the output table
echo "</table>";
}[/php]
Ronald :cool:
4
