> > $sql = "SELECT WorkOrderID AS Work_Order_ID, DATE_FORMAT(StartDate, '%b. > %e, %Y %l:%i %p') AS Start_Date, > DATE_FORMAT(EndDate, '%b. %e, %Y %l:%i %p') AS End_Date, "; > $sql .= "Advertiser AS Advertiser_Name,AccountNum AS Account_Number, > Impressions AS Ad_Impressions, "; > $sql .= "AdSize AS Ad_Size, CPM AS CPM_Rate, "; > $sql .= "ORDER BY StartDate DESC"; >
You forgot the tables, plus you have an extra comma after CPM_Rate. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
