Add order by to php query.

[crazylegseddie]

Hi just a quick one. How do I add 'ORDER BY ap.Date' to this query

 
$sql = 'Select ap.Appointment_ID, ap.Date, ap.Time, ap.Pet_ID, p.Name, p.Species, p.Client_ID, cl.First_Name, cl.Last_Name, n.Notes
										From appointment as ap, pet as p, client as cl, notes as n
										Where ap.Pet_ID = p.Pet_ID AND p.Client_ID = cl.Client_ID AND ap.Appointment_ID = n.Appointment_ID AND cl.Client_ID=' . $_GET['Client_ID'];

Ive tried adding it in inverted comments at the end of the script but I recieve an error. Any solution? Thank You

[bogu]

$sql = 'Select ap.Appointment_ID, ap.Date, ap.Time, ap.Pet_ID, p.Name, p.Species, p.Client_ID, cl.First_Name, cl.Last_Name, n.Notes ';
$sql.= 'From appointment as ap, pet as p, client as cl, notes as n ';
$sql.= 'Where ap.Pet_ID = p.Pet_ID AND p.Client_ID = cl.Client_ID AND ap.Appointment_ID = n.Appointment_ID AND cl.Client_ID=' . $_GET['Client_ID'].' '; 
$sql.= 'ORDER BY ap.`Date`'; 

[crazylegseddie]

thx alot worked a charm 😉

[bogu]

crazylegseddie wrote:

thx alot worked a charm 😉

I'm glad that I could help. 😉