Record Set Filtering

[deviant.studio]

Hi everyone, new here, I found one post relevant to this, but it was from 2007 and still had no answer so I thought I'd ask it.

 

I have one recordset "dates"

"SELECT session_date FROM jp_sessions GROUP BY session_date "

 

And this does what it should. Displays the Unique dates. Now the next task, is to use those dates as a filter on another record set. So I used this statement.

"SELECT session_time FROM jp_sessions WHERE session_date = %s", GetSQLValueString($colname_times, "date"));
$times = mysql_query($query_times, $janpat) or die(mysql_error());
$row_times = mysql_fetch_assoc($times);
$totalRows_times = mysql_num_rows($times);

 

And that works almost as well as it should, with one minor flaw. It only returns the times for the first record. Do I have to create some kind of repeat to get the rest? I'm not sure, and Im at a loss.

 

So In the end I should achieve something like this.

 

01/11/2009

 

10:50:00

12:50:00

15:50:00

 

01/12/2009

 

9:35:00

10:55:00

12:50:00

11:50:00

 

01/13/2009

 

10:50:00

12:50:00

15:50:00

 

But right now I just get:

 

01/11/2009

 

10:50:00

12:50:00

15:50:00

 

01/12/2009

 

01/13/2009

 

So if someone can let me know what to do, that would be great. Im so at a loss and I think I am wearing down my floor by walking in circles.