Comparing hours in one single day

[drone11]

I got this problem for days or weeks now. I have to write a program using PHP5 and mysql 5.0.51b thats found on the WAMP 2.2
The dilemma is the following:
I have 5 meeting rooms each one named c1,c2,c3 etc
How do make a table where I can reserve a room at a certain date and certain time? This is the table i have so far:

Table name:centros
name         type
centroid =  datetime
horainicio= datetime
horafinal = datetime
user      = varchar
ultmod  = datetime
 

This is my query that i do with mysql. Yet if I tell it that if there is a meeting room available between a certain reservation it will come out as true. For example C1 is reserved from 13:00:00 - 18:00:00. And if i do my query stating that horainicio= 14:00:00 it will not find it and say i can book the place. Please help me out I am going nuts.

$conn = connectDB();
 
 
   $query = "select *
           from centros 
           where horainicio = '$horainicio' 
              and centroid = '$centroid'";
     $resultado = $conn->query($query);
         if (!$resultado || $resultado->num_rows>0)
          return false;
 
 
   $query = "insert into centros
                 values('',$centroid','$horainicio', '$horafinal','$status', '$lastmod', '$user'";
 
  $result = $conn->query($query);
   if (!$result)
     return false;
   else
     return true;
 

[Atli]

Hi, welcome to Bytes!

Have you tried the BETWEEN... AND satements?
For example:

SELECT COUNT(*) FROM myTable
WHERE NOW() BETWEEN startDate AND endDate;
 

P.S.
Naming your fields using non-english words is never a good idea. You never know who's going to be using your tables in the future. I for one can't really understand your query because I don't understand the field names.
Same goes for variables in you PHP code ;)