next three months

Re: next three months

Postby hanzi » Thu Jul 16, 2009 2:23 pm

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
hanzi
 
Posts: 3
Joined: Wed Jul 15, 2009 2:20 pm

Re: next three months

Postby chris » Thu Jul 16, 2009 2:32 pm

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
User avatar
chris
Site Admin
 
Posts: 1089
Joined: Mon Dec 17, 2007 7:42 pm
Location: Málaga, Spain

Re: next three months - Resolved

Postby chris » Fri Jul 17, 2009 12:16 pm

[ This has been resolved via pm messages ]

Chris
User avatar
chris
Site Admin
 
Posts: 1089
Joined: Mon Dec 17, 2007 7:42 pm
Location: Málaga, Spain

Previous

Return to General

Who is online

Users browsing this forum: No registered users and 1 guest

cron