Re: SQL syntax?

Try this: $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.= "FROM workorderform "; $sql .= " WHERE WorkOrderID = WorkOrderID ORDER BY StartDate DESC"; I just removed extra commas from CPM_Rate and workorderform Terion Miller wrote: > ah...I also though it was because I didn't have a statement like where > adsize = adsize or something but I tried that and got the same error I have > been getting ... > > You have an error in your SQL syntax; check the manual that corresponds to > your MySQL server version for the right syntax to use near 'FROM > workorderform, WHERE WorkOrderID = WorkOrderID ORDER BY StartDate DESC' at > line 2 > > and why does it keep saying line 2... > here is the snippet as it is now: > > $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.= "FROM workorderform, "; > $sql .= " WHERE WorkOrderID = WorkOrderID ORDER BY StartDate DESC"; > > > On Fri, Dec 5, 2008 at 4:14 PM, Allan Arguelles <allan@arguelles.com.ph>wrote: > > >> Umm.. I meant you need to put >> >> $sql .= "FROM workorderform "; >> >> between these: >> >> $sql .= "AdSize AS Ad_Size, CPM AS CPM_Rate, "; >> $sql .= "ORDER BY StartDate DESC"; >> >> >> :) >> >> >> Terion Miller wrote: >> >> On Fri, Dec 5, 2008 at 3:57 PM, Allan Arguelles <allan@arguelles.com.ph> >> <allan@arguelles.com.ph>wrote: >> >> >> >> $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. >> >> well I changed it to: >> >> $sql = "SELECT workorderform.WorkOrderID AS Work_Order_ID, >> DATE_FORMAT(workorderform.StartDate, '%b. %e, %Y %l:%i %p') AS Start_Date, >> DATE_FORMAT(workorderform.EndDate, '%b. %e, %Y %l:%i %p') AS End_Date, >> "; >> $sql .= "workorderform.Advertiser AS >> Advertiser_Name,workorderform.AccountNum AS Account_Number, >> workorderform.Impressions AS Ad_Impressions, "; >> $sql .= "workorderform.AdSize AS Ad_Size, workorderform.CPM AS >> CPM_Rate "; >> $sql .= "ORDER BY StartDate DESC"; >> >> and got the same error.... >> >> >> >> >> >> > >