php Volgende dag

CREATE TABLE `car_auto` (
  `auto_id` int(11) NOT NULL auto_increment,
  `auto_merk` varchar(255) collate latin1_general_ci default NULL,
  `auto_type` varchar(255) collate latin1_general_ci default NULL,
  `auto_bouwjaar` varchar(10) collate latin1_general_ci NOT NULL,
  `auto_foto` varchar(255) collate latin1_general_ci default NULL,
  `auto_beschrijving` text collate latin1_general_ci,
  `auto_kenteken` varchar(10) collate latin1_general_ci default NULL,
  `auto_reparaties` text collate latin1_general_ci,
  `auto_onderhoud` text collate latin1_general_ci,
  `auto_apk` text collate latin1_general_ci,
  `auto_toekomstapk` int(10) collate latin1_general_ci default NULL,
  `auto_beschikbaar` enum('0','1') collate latin1_general_ci default NULL,
  `auto_tarief` varchar(10) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`auto_id`)
) ENGINE=MyISAM

CREATE TABLE `car_reservering` (
  `reservering_id` int(11) NOT NULL auto_increment,
  `reservering_autoid` int(11) default NULL,
  `reservering_userid` int(11) default NULL,
  `reservering_van` int(10) default NULL,
  `reservering_tot` int(10) default NULL,
  `reservering_bevestigd` enum('0','1') collate latin1_general_ci NOT NULL default '0',
  `reservering_betmethode` varchar(100) collate latin1_general_ci NOT NULL,
  `reservering_betaald` enum('0','1') collate latin1_general_ci NOT NULL default '0',
  `reservering_afgehandeld` enum('0','1','2') collate latin1_general_ci NOT NULL default '0',
  `reservering_verhuurd` enum('0','1','2') collate latin1_general_ci NOT NULL default '0',
  `reservering_kilovoor` varchar(100) collate latin1_general_ci NOT NULL default '0',
  `reservering_kilona` varchar(100) collate latin1_general_ci NOT NULL default '0',
  PRIMARY KEY  (`reservering_id`)
) ENGINE=MyISAM

SELECT
    *
FROM
    car_auto
WHERE 
    auto_id
        NOT IN
        (
            SELECT
                reservering_autoid
            FROM
                car_auto
            WHERE
                    reservering_van > 'timestamp van 0.00 morgenochtend'
                AND
                    reservering_tot < 'timestamp van 23.59 morgenavond'
        )

<?php
select * from car_auto blabla
// je haalt nu fijn alle auto's op.
if (auto != gereserveerd){
//alle beschikbare auto's in een array stoppen
$status= beschikbaar
}
if(auto==gereserveerd){
//checken op tijd etc
//daarna alles wat morgen beschikbaar is ook in een array //proppen.
}
echo "beschikbare autos $inhoud array1+inhoud array2";
?>