DISTINCT question

[netfrugal]

I have a list in mysql of ip addresses and other things like date, pages viewed, etc....

I don't want to see duplicate ip addresses, so I am assuming the DISTINCT command is what I need, however, I still see duplicates:

<? 
$today = date('Ymd');

$sql = mysql_query("SELECT DISTINCT * FROM table1 WHERE date_created = '$today'"); // order by today  


while ($row = mysql_fetch_array($sql)) {
$recID = $row['recID'];
$ip = $row['ip'];
$date_created = $row['date_created'];
$time1 = $row['timeentered1'];
$time2 = $row['timeentered2'];
$time3 = $row['timeentered3'];
$referer = $row['referer'];
$page1 = $row['page1'];
$page2 = $row['page2'];
$page3 = $row['page3'];

?>

Am I missing something from the query? Or does this look right?

[Roger_Ramjet]

DISTINCT means all fields selected are distinct - which of course they are not when you have timestamps etc in there.

What you need depends on what you want: just the IP then DISTINCT will work, last entry then GROUP BY with MAX(recID) is the answer.