Help structuring a mysql query

[Nico]

I have a table with dates and times (date and time columns respectively). Some of the date fields contain equal values. I want to select all the times for a particular date and I'm not sure how to structure the query in mysql to do it.

ex.

This is what I get:

1/2/2004 12:23:42 16:37:26 
1/2/2004 16:57:04 20:12:02 
1/3/2004 12:26:24 16:14:47 
1/3/2004 16:32:04 21:06:31 
1/4/2004 12:26:28 16:20:27 
1/4/2004 16:41:48 20:56:19 

This is what I want:

1/2/2004 12:23:42 16:37:26 16:57:04 20:12:02 
1/3/2004 12:26:24 16:14:47 16:32:04 21:06:31 
1/4/2004 12:26:28 16:20:27 16:41:48 20:56:19

How could I structure the query to get what I want?

Thanx

Nico

[nemonoman]

You can't the exactly the results you want by a single SQL query. You'll have to build the output using a loop.

This should do it:

$result=mysql_query("SELECT mydate, mytime FROM sometable ORDER BY mydate, mytime");
$row=mysql_fetch_array($result);
if($row){$currentdate=$row[0];
   do{
      if($row[0]==$currentdate){
       echo "  $row[1];"
      }
   else{
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;echo "<BR>$row[0]&nbsp; $row[1];"
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$currentdate=$row[0];
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}
&nbsp;&nbsp;&nbsp;}while($row=mysql_fetch_array($result));
}

[Nico]

ah excellent, thanx much!

Nico

[nemonoman]

Is said:
echo "$row[0] $row[1];"

Should have been:

echo "<BR>$row[0] $row[1];"