It worked.
Thanks!
-Steve
> 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
>>
>> [EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
