Hi all, ive got a big question about conducting mysql_queries.. i have a schedule program that needs to sort through and pick the records that apply.. the date will change, and used a php date() formatted to mysql date and pick out the ones records that are active vers inactive. and finally sort through the other fields..
$sql="SELECT * FROM $dbtable WHERE date = $sysdate AND recstatus='active' ORDER BY ftime ASC, stime ASC, tailnum ASC";
can anyone tell me if im on the right track or am i going the wrong direction? THX to anyone that can help!!