[SOLVED] Need Multiple Columns Select Statement

[TecTao]

Have a 3 column table, id, category_names, category_status.  There are 37 rows.

 

The select statement works fine, produces a long list of the 37 category_names.  Would like to break up the list into 3 columns and am stuck.

 

Here the select statement I'm using.

 

		<?php 
$result = mysql_query( "SELECT * FROM _list WHERE category_status <> 1 ORDER BY category_names ASC" )
or die("SELECT Error: ".mysql_error());

$num_rows = mysql_num_rows($result);

  while ($row = mysql_fetch_array($result))
  {
     extract($row);

echo $category_names;
echo "<br> ";

$row_count++; 
}

mysql_close;
?>

 

Thank you for any help or suggestions in advance.

Mike

[GingerRobot]

You mean you want to output the data in a table with 3 columns? Check out this FAQ/post : http://www.phpfreaks.com/forums/index.php/topic,95426.0.html

[TecTao]

Thanks for the link, that is what i've been searching for...  that did it.