Search found 3 matches

Return to advanced search

Re: SQL QUERY php page

Have you tried ececting that query? Bear in mind that non-booked days are not stored in the database so in theory just doing SELECT * FROM bookings WHERE id_item=1 will return just the booked dates (in deed this is basically the query that the code executes anyway to create the calendar month booke...
by mpjltd2
Sat Oct 09, 2010 3:06 pm
 
Forum: Support
Topic: SQL QUERY php page
Replies: 3
Views: 2234

Re: SQL QUERY php page

Second one

how to create a form where a user can enter dates and check for availability?
by mpjltd2
Sat Oct 09, 2010 3:05 pm
 
Forum: Support
Topic: SQL QUERY php page
Replies: 3
Views: 2234

SQL QUERY php page

Is it possible to make a sql query which shows a table only with booked days?
how the php page should look like

Code: Select all
SELECT *
FROM bookings
WHERE bookings.id_state=1 AND bookings.id_item=1
ORDER BY bookings.the_date

is this query ok ?
by mpjltd2
Sat Oct 09, 2010 2:58 pm
 
Forum: Support
Topic: SQL QUERY php page
Replies: 3
Views: 2234

Return to advanced search

cron