hi...i have racked my brain trying to figure this out. i have what I am calling "multi grouping"
Main groups are Month Year
then in each Month Year group is a multiple mini groups
Month Year
city 1
course 1 and dates
course2 and dates
course 3 and dates
city 2
course 1 and dates
course2 and dates
course 3 and dates
then the next month year...
my query statement right now
<?php$query_prodates = "SELECT * FROM prodates p
LEFT JOIN cities ci ON p.session_city = ci.city_name
LEFT JOIN courses co ON p.session_course = co.course_number
LEFT JOIN monthyear my ON p.session_month_year = my.month_year
WHERE p.session_month_year = p.session_month_year AND p.date_session_id =
p.date_session_id ORDER BY my.my_id";
$proschedule = mysql_query($query_prodates) or die(mysql_error());
$row_proschedule = mysql_fetch_assoc($proschedule);
$totalRows_proschedule = mysql_num_rows($proschedule);
?>
my code for the query is NOT any where correct. I am writing it php/mysql blind!!!
here is what i have so far, laughing out loud is ALOUD!!! i am humbly trying though...
<table>
<tr>
<td><?php echo $row_proschedule['session_month_year']; ?></td>
</tr><?php do { ?>
<tr >
<td><?php echo $row_proschedule['session_city']; ?></td>
</tr>
<tr>
<td><?php echo $row_proschedule['session_course']; ?></td>
<td><?php echo $row_proschedule['session_dates']; ?></td>
</tr>
<?php } while ($row_proschedule = mysql_fetch_assoc($proschedule)); ?>
}
</table>
which is VERY VERY wrong. i feel i am googling the wrong search terms, both in google and here. any help is much appreciated
barbara
