ideas

[juice]

i have the login resister and view car pages done alrite. its just ideas about how to cheack availability of cars fpr rent. Have antone any ideas on that? would i check this using sql or would i use php?

[daynah]

You should be using both mysql and php to check this.

mysql would hold the data, and php would be used to write the script.

You can have a tinyint field for 'car_availability.' And if it's 1, that means it's available, if it's 0, then it's not. Then on a page that displays all available cars, run a query like:

$query = "SELECT * FROM cars WHERE car_availability='1'"

Of course, you could would be more complex, but this is only a simple example.

[juice]

thats a good idea, having a status field in car table. would it not just be the mysql used to retrieve the availability of the car then tho? php would be just used to display out the information?

but problem with this idea is that a car could could be reserved for a partcular date say the 5/5/05 to the 10/5/05. it can still be reserved before those dates and after those dates. that is probably the tricky part any suggestions?

[alfoxy]

For that second problem (date) I would make a second table with a car id field and when the car is booked from and to fields.

Then I would just do a check, is that car booked between those two dates. You could add as many 'booked out' dates as needed

e.g.

Table
Car Id: 3 (Car number 3, reg number etc.)
Date From:15 (The fifteenth)
Month From: 2 (February)
Year From: 2005
Date To:30 (The fifteenth)
Month To: 2 (February)
Year To: 2005

Something like ......

Select * From Cars Where
Car Id=3 AND
(Date From <= This Date AND DateTo >= This Date) AND
(Month From <= This Month AND Month To >= This Month ) AND
(Year From <= This Year AND Year To >= This Year )

Hope this helps, bit messy !

Al