BD for listing mod
Posted: Tue Nov 14, 2006 3:39 pm
Ok.. so kind of a open ended question im looking for suggestions.
Im building a booking mod for a classified web page im building and much thanks to The Ninja Space Goat for helping me out with some great information to get me going.
My question is if you were creating a your own booking/availibility what information would you pass back and for from the DB
The plan is to have a calendar display on each listing that shows when that object is and isnt avalible.
And then in the admin area where a user will modify their listing there will be a section to reserver and unreserve days/weeks/months.
Currently im trying to figure out the best information and how to pass that information to the db to make it easy to call back to the calendar.
To update the table im thinking of passing the below information to the tables..
$listingid to make it specific to each listing..
$date or range of dates specified
$avalible yes or no
and then when someone views the listing do the following
Onload call the following info
dates specific to the $listingid and if they are availible or not... then somehow format to the calendar.
this is my first real web app so be gentle with me. Am i way off? does that even make any sence? or should i just pack it up now?
Im building a booking mod for a classified web page im building and much thanks to The Ninja Space Goat for helping me out with some great information to get me going.
My question is if you were creating a your own booking/availibility what information would you pass back and for from the DB
The plan is to have a calendar display on each listing that shows when that object is and isnt avalible.
And then in the admin area where a user will modify their listing there will be a section to reserver and unreserve days/weeks/months.
Currently im trying to figure out the best information and how to pass that information to the db to make it easy to call back to the calendar.
To update the table im thinking of passing the below information to the tables..
$listingid to make it specific to each listing..
$date or range of dates specified
$avalible yes or no
and then when someone views the listing do the following
Onload call the following info
dates specific to the $listingid and if they are availible or not... then somehow format to the calendar.
this is my first real web app so be gentle with me. Am i way off? does that even make any sence? or should i just pack it up now?