[SOLVED] List Help

[verdrm]

Is there a way to echo only one thing of a similar name? For example, if I have four posts, two in column (MySQL) 'Title' named 'Post' and two in column 'Title' named 'Draw', so on the PHP page:

 

Post Title

 

Post

Post

Draw

Draw

 

how can I echo just one of each name?

 

I would like the above to look like:

 

Post Title

 

Post

Draw

[ToonMariner]

use DISTINCT in your query

[verdrm]

Thanks, that worked! Now, the only problem is that I also have dates next to the post names, which I forgot to mention.

 

Post Title        Revision Date

 

Post              Oct 12, 2007 7:03:43 PM EDT

 

 

How do I use DISTINCT when dealing with dates?

[MmmVomit]

Are the dates the same?  Different?

Would you like the earliest date? Latest date?

[verdrm]

The dates are different. I would like the most current date. If it helps, my code looks like this:

 

<?php

$query = "SELECT DISTINCT title,date FROM info WHERE group_id = '".$_SESSION['ferpa']."' ORDER BY date DESC";

$result = mysql_query($query);

?>

<?php

while(list($title,$date) = mysql_fetch_array($result, MYSQL_NUM))

{

 

?>

 

I can get distinct TITLES but the corresponding dates do not echo.

[MmmVomit]

You could also use a GROUP BY clause and a MAX function on the date field.