> The one thing I cannot get into my head is how can you tell the database
> that all the days between the "start" and "end" dates are booked.
> Also when
> people search for a caravan on a specific date and say they want it for 7
> day the database/PHP checks to see if the entire period is
> tot
Andy,
I do use the "ENUM" technique quite a bit, with good results.
it's even easier if you set the ENUM values to 1 and 0, then when you do a
database query, you don't have to read the string, you can simply check for
it's presence.
Here's a fictitious example:
In user_table, make a field for
(', '', $row_table_def['Type']);
$enum= ereg_replace('\\)$', '', $enum);
$enum= explode('\',\'', substr($enum, 1, -1));
$enum_cnt= count($enum);
Which apparantly takes the result from the &qu
