need help with looping LEFT JOIN

Nasser_Kamal

hi ,, need help with looping LEFT JOIN
its a boat trip price list
need to show prices for each month
i have 2 mysql tables
1. months (month_id, month_order, month_name)
2. prices (prices_id, month_id, prices_order, date_from, date_to, boat, prices_amount)
i have got help to write the code to join and fetch data from those tables

<?
$query_recBookingList = "SELECT month_name, date_from, date_to, boat, prices_amount
FROM
months m
LEFT JOIN prices p
ON p.month_id = m.month_id
ORDER BY month_order, price_order";
$recBookingList = mysql_query($query_recBookingList, $mermaid) or die(mysql_error());
$row_recBookingList = mysql_fetch_assoc($recBookingList);
$totalRows_recBookingList = mysql_num_rows($recBookingList);

mysql_free_result($recBookingList);
?>

now i need to get the other months and tours prices for each month to display like example
February 2012
Date From | Date To | Boat | Price
09.02.12 | 16.02.12 | Sea Star| 500
16.02.12 | 23.02.12 | Sea Star | 4480
23.02.12 | 01.03.12 | Sea Star | 560
March 2012
02.03.12 | 09.03.12 | Sea Star | 500
09.03.12 | 16.03.12 | Sea Star | 500
16.03.12 | 23.03.12 | Sea Star | 4480
23.03.12 | 30.03.12 | Sea Star | 560
etc..

so if someone know how to create the while loop ,,, thanks

bradgrafelman

I already explained in your other thread how to do this:

bradgrafelman;10996215 wrote:
As for the display format, you'd want to use a temporary variable to store the previous row's month_name value; if the current row's month_name value does not match the previous' value, then you'll know that you're processing rows from the next month and that you'll need to output the new "month_name" header/separator/etc.

Nasser_Kamal

hi,, thanks for your care ,, i understand you trying to help me but i don't understand you last advise,, may i ask if you can advise me with another form where they can help php beginners

thanks

Weedpacket

Help for those who just getting started.