I have a links page that has categories.
I am attempting to place category links on one side, and the actual links on the other.
However when I do this, I get the following result:
category1 category1 category1 category2
Here is the code I am using:
<?php // Read... $link_info = "SELECT cat_link FROM links;"; $response = mysql_query( $link_info, $dbh );
/* Printing results in HTML */ print "<table border =\"0\" cell cellspacing=\"0\" cellpadding=\"3\">\n";
while ($table_data = mysql_fetch_array($response, MYSQL_ASSOC)) { foreach ( $table_data as $col_value ) { print "\t\t<tr class=\"text\"><td>$col_value</td></tr>\n"; } } print "</table>\n"; ?>
Is there any way that I can output:
category1 category2...
SELECT DISTINCT cat_link FROM links
perhaps?
Also, omit the semicolon from the query. You need that only in the mysql client.
Thanks,
Steve Marquez Marquez Design
[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
