How would I make a coloumn for half the results?
here's the code to assist you
$SQL = "SELECT DISTINCT `category` FROM `ezines` ORDER BY category ASC"; $result = @mysql_query( $SQL ); while( $row = @mysql_fetch_array( $result ) ) {
It depends on what you mean by "half". Do you only want to display half the number of rows returned? Do you want to display all of the rows in two columns? Do you want to display every row, but only half the data from each?
The second one
(Do you want to display all of the rows in two columns? )