Help with a calender

somle

Hi,

im making a calender in php/mysql. The calender will be used to see which classrom that are available.

The calender contains 30 days at the time, but one ”problem” is that I have to make 30 mysql querries, one for each day.
How can I make this easier?

And one more thing. The mysql querry is selecting the text where date = the date in the mysql row, but if the classrom should be unavailable for more than one day, I have to insert one row for each day. How can I use From date – To date ?

And another problem, not about the calender.
I have made a webside that uses $http_get_vars[] but this is not working when I write A+ Hardware, then the result will be A Hardware. How can I use the + in the url ?

Thanks!

TheDefender

Originally posted by somle

And one more thing. The mysql querry is selecting the text where date = the date in the mysql row, but if the classrom should be unavailable for more than one day, I have to insert one row for each day. How can I use From date – To date ?

And another problem, not about the calender.
I have made a webside that uses $http_get_vars[] but this is not working when I write A+ Hardware, then the result will be A Hardware. How can I use the + in the url ?

Thanks!

For the first part, use a BETWEEN clause in your query...
SELECT * FROM table WHERE date BETWEEN 'date1' AND 'date2'

For the second part, use $POST, $GET, $SERVER, etc, instead of the deprecated $HTTP*_VARS method. Also, to use the + symbol in the URL, you need to use the ASCII code for the + symbol instead of the + symbol itself.

twilson

Originally posted by somle
Hi,

im making a calender in php/mysql. The calender will be used to see which classrom that are available.

The calender contains 30 days at the time, but one ”problem” is that I have to make 30 mysql querries, one for each day.
How can I make this easier?

Use a LIKE statement, for example:

SELECT * FROM Calendar WHERE Date LIKE '2004-09-%'

That should select all of September, 2004.

Peace,
Tom