[Selecting completed jobs between 2 dates]

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

[inserting data into a DB using OOP php]

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