next three months

[hanzi]

This is the error I get

Code: Select all

ERROR checking id item availability dates
mysql_error
SELECT * FROM bookings_calendar WHERE id_item= AND MONTH(the_date)=07 AND YEAR(the_date)=2009

[chris]

OK, so we can see from that that you haven't defined the ID_ITEM constant in the index.php page
This is strange as it is defined in your index.php page (as per the original example)

In index.php you have this:

Code: Select all

if(isset($_REQUEST["id_item"]))       define("ID_ITEM",   $_REQUEST["id_item"]);   #   id sent via  url, form session etc
else                           define("ID_ITEM",   2);                  #   default used for demo

which detects the id if is sent to the page via the url or via a form - $_REQUEST["id_item"] or sets the default id to "2".

Are you showing the calendar from an url or from a form?
If so you will need to check that the id_item has a value.

Do you have an url I can see (pm me if you prefer)


Chris

[chris]

[ This has been resolved via pm messages ]

Chris