List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 3 2003 4:12pm
Subject:Re: links...
View as plain text  
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

Thread
links...Steve Marquez3 Jun
  • Re: links...Paul DuBois3 Jun
    • Re: links...Steve Marquez3 Jun