RE: SV: [PHP] Booking by Date/Time in mySQL

2001-03-22 Thread Jeff Armstrong
overboard. [soapbox.off] Kiora -Original Message- From: Jon Snell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 10:54 PM To: Thomas Edison Jr. Cc: [EMAIL PROTECTED] Subject: RE: SV: [PHP] Booking by Date/Time in mySQL Yes, I would recommend locking your tables before doing this ju

RE: SV: [PHP] Booking by Date/Time in mySQL

2001-03-21 Thread Jon Snell
statement and worry about race conditions... -Original Message- From: Jeff Armstrong [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 12:36 PM To: Thomas Edison Jr. Cc: [EMAIL PROTECTED] Subject: RE: SV: [PHP] Booking by Date/Time in mySQL the logic goes: $start

RE: SV: [PHP] Booking by Date/Time in mySQL

2001-03-20 Thread Thomas Edison Jr.
ike you are just > > testing > > the FIRST one. > > > > why not turn it round and do: > > select * from booking where > > ('$start'>=startdate and '$start'<=enddate) or > > ('$end'>=startdate and '$en

RE: SV: [PHP] Booking by Date/Time in mySQL

2001-03-20 Thread Thomas Edison Jr.
ike you are just > > testing > > the FIRST one. > > > > why not turn it round and do: > > select * from booking where > > ('$start'>=startdate and '$start'<=enddate) or > > ('$end'>=startdate and '$en

RE: SV: [PHP] Booking by Date/Time in mySQL

2001-03-20 Thread Jeff Armstrong
aranteed safe, as you can end up with double bookings in the pico seconds between the select and the insert - but hey, how many hits a second do you expect. Regards Jeff's Granny -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 5:08

RE: SV: [PHP] Booking by Date/Time in mySQL

2001-03-20 Thread Thomas Edison Jr.
age- > From: Thomas Edison Jr. > [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 20, 2001 11:50 AM > To: Peter Chr. Hansen > Cc: [EMAIL PROTECTED] > Subject: Re: SV: [PHP] Booking by Date/Time in mySQL > > > Peter, > > what do you mean by Newdate between date1

RE: SV: [PHP] Booking by Date/Time in mySQL

2001-03-20 Thread Jeff Armstrong
AM To: Peter Chr. Hansen Cc: [EMAIL PROTECTED] Subject: Re: SV: [PHP] Booking by Date/Time in mySQL Peter, what do you mean by Newdate between date1 & date2?? the logic i'm using is that i'm checkin if the new Start Date & End date lies between the old Start Date & End Date

Re: SV: [PHP] Booking by Date/Time in mySQL

2001-03-20 Thread Thomas Edison Jr.
Peter, what do you mean by Newdate between date1 & date2?? the logic i'm using is that i'm checkin if the new Start Date & End date lies between the old Start Date & End Date or not. If it does, than entry is denied, else booking is succesfull. But things are not running, following is the code i