Showing results in a 3 column table

sinanapi

I want to page my query results and show them not just row by row but as a table....Like 3 columns and 4 rows so totaly 12 results can be shown...
How can I do this?

nemonoman

<? 
//this is the basic idea
//put your results into the cells of a table
//add a new row until you've got all the results

$myquery='SELECT col0, col1, col2 FROM mytable';
$result = mysql_query($myquery);

echo "<TABLE>";

$colarray=mysql_fetch_array($result);

while($colarray) {
  echo "<TR>
       <TD>$colarray[0]</TD>
       <TD>$colarray[1]</TD>
       <TD>$colarray[0]</TD>
   </TR>";
  $colarray=mysql_fetch_array($result);
  }  //end while

echo "</TABLE>";

?>

PHPdev

nemonoman,

Your ideas are correct... but I would never want to maintain your code.

Try to analize your code and clean it up a bit. Not that all instructions should be contained on one line like you can do with PERL, but just a little more thought...

PHPdev

nemonoman

Agreed...presented in that form for instructional clarity only.

You assume a lot.

I would think it better to be careful about guessing the expertise levels of those posting here.

Nemo.

PHPdev

nemonoman,

I must agree with you that I do assume a lot. This is something that I have aquired from my time on the forums, since most do not provide enough information to troubleshoot thier problems.

I am sorry to have assumed to much about your experteise, from just one sample of your code. From reading your other posts I can see that you are in inteligent individual rather than just another NEWBIE.

Glad to have you around...

Sorry to offend...

PHPdev

nemonoman

Oops. Looks like my comment could be interpreted 2 ways.

Meant: best to write extremely clear, even simplistic, example code -- even if it's less than optimum.

If your reader is experienced s/he'll figure out the elegant method once s/he's gotten over the impediment that generated the question in the first place.

Sorry if you took my comments otherwise.