Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : Mysql Query - DATETIME

[Barti1987]

referring to this post:

http://www.webhostingtalk.com/showth...hreadid=306727

I changed the date time, but the problem comes when I try to fetch the appointments.

I can not seem to get the right query..

As I said there are appointments that are recorded by the 15's and 30's and 45's... Can that be evaluated in the DATETIME?

Thnx alot,

[Barti1987]

I made this query:

PHP Code:

$query_it = "SELECT * FROM appointments WHERE `" . $to_tell . "`='$the_id'
                     AND ((`st` > '$start_datetime' AND `st` < '$end_datetime' ) OR (`et` > '$start_datetime' AND `et` < '$end_datetime'))"; 


the good thing is that it catches all the appointments on the edges, 15,30,45.. I have to test it more..

anyone has a bad side to that query please tell me

Peace,

[Barti1987]

Seems to be that i am the only one looking

problem: appt reserverd for 01 --> 20 (hours)..

when making one from 01 --> 05 the first one does not get cought?