Jump to content
Killersites Forums

ckbis1

New Members
  • Posts

    2
  • Joined

  • Last visited

ckbis1's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. Hi I need to create a pdf report of one of my tables in my database, creating the pdf was easy just used fpdf, but what i am struggling with now is trying to generate that report on data for the past 30 days (i am trying to make a monthly report), my snap shot of my code follows: " echo $date = date("Y-m-d") ; echo $date2 = "select(DATESUB($date, INTERVAL 31 DAY)"; $pdf->Table("select j_num, building,room, description,reason, type, contractors, staff, start_time, end_time, cost, note FROM job WHERE completed = 'yes' BETWEEN $date and $date2 ",$prop); $pdf->Output(); ?> " the first echo gives me this - "2012-05-09" which is right i need the system date the second echo gives me this - "select(DATESUB(2012-05-09, INTERVAL 31 DAY)" which is wrong it should be minusing 30days from the system date THIS IS THE ENTIRE ERROR THAT I GET IN MY BROWSER: 2012-05-09select(DATESUB(2012-05-09, INTERVAL 31 DAY)Error: 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 'select(DATESUB(2012-05-09, INTERVAL 31 DAY)' at line 1 Query: select j_num, building,room, description,reason, type, contractors, staff, start_time, end_time, cost, note FROM job WHERE completed = 'yes' BETWEEN 2012-05-09 and select(DATESUB(2012-05-09, INTERVAL 31 DAY) is there something wrong with my syntax? well i guess its kinda obvious there is, but what and any suggestions on how to fix it Thanx Chris
  2. Hi I have managed to connect to my DB using OOP php classes and what not and can view my DB, but now i am struggling to insert data from my form into my database, and I am lost with how to code it. Any help or direction would be much appreciated. thanx chris
×
×
  • Create New...