At 10:52 -0500 6/3/03, Steve Marquez wrote:
>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
>
>smarquez@stripped
