QUERY - Duplicates, But Only Shows One

tuf-web_co_uk

i have a jokes database set up, and i want to automate links to categories, using the type field in my table.

when i run my query it shows the same category multiple times because of multiple jokes in that category.

is there anyway of only showing one instance of the category instead of many.

i'm currently using this code

$sql = "SELECT * FROM jokes";
// Request the text of all the jokes  

$result = mysql_query($sql);  

if (!$result) {    

echo("<P>Error performing query: " .
mysql_error() . "</P>");    

exit();  }

while ( $row = mysql_fetch_array($result) ) {   

  echo("<P><font size=1 face=Verdana color=#000080><b>" . $row["type"] . "</P>");  

  }

thanks in advance 😉

Lars_Berg

select distinct type from jokes

tuf-web_co_uk

hhmm.... ok so i changed it to

$sql = "SELECT type FROM jokes";

like u sed, where type is the only column i want from the table.

but it still brought the error message up 🙁

please help

Lars_Berg

What error message?

tuf-web_co_uk

oops sorry, not error message, it still brings more than 1 instance of the data.

http://www.theutherfish.com/comms/jokes/jokes.php

as that page shows

xblue

Lars':
select distinct type from jokes

yours:
SELECT type FROM jokes

seems as if you are missing something? why did you drop the distinct keyword?

tuf-web_co_uk

thanks alot peeps!

that worked a charm!! 🆒