> the tricky part is I could have fifteen rows in the db all with
> different start and end dates that I need to check each day against.
Then do the data comparison in the DB --
SELECT * FROM your_table
WHERE {$check_time} >= start_time
AND {$check_time} <= end_tim
: [PHP] Re: best way to do this with arrays...
> $start = '2004-07-04';
> $end = '2004-07-09';
> $check = '2004-07-06'; // the date you want to check
>
> $timestampStart =
> mktime(0,0,0,substr($start,5,2),substr($start,8,2),substr($start,0,4));
> $start = '2004-07-04';
> $end = '2004-07-09';
> $check = '2004-07-06'; // the date you want to check
>
> $timestampStart =
> mktime(0,0,0,substr($start,5,2),substr($start,8,2),substr($start,0,4));
> $timestampEnd =
> mktime(0,0,0,substr($end,5,2),substr($end,8,2),substr($end,0,4));
> $timestampCh
"Edward Peloke" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello,
>
> I have a table in a database that holds begin and end dates...I would like
> to select all the begin and end dates for a certain id, then add those
> dates, plus the dates between them to an array...example.
>
4 matches
Mail list logo
