phpraid_raids  CREATE TABLE `phpraid_raids` (                           
                 `raid_id` int(10) NOT NULL auto_increment,             
                 `description` text NOT NULL,                           
                 `freeze` int(10) NOT NULL default '0',                 
                 `invite_time` varchar(255) NOT NULL default '',        
                 `location` varchar(255) NOT NULL default '',           
                 `officer` varchar(255) NOT NULL default '',            
                 `old` tinyint(1) NOT NULL default '0',                 
                 `start_time` varchar(255) NOT NULL default '',         
                 `dr_lmt` int(2) NOT NULL default '0',                  
                 `hu_lmt` int(2) NOT NULL default '0',                  
                 `ma_lmt` int(2) NOT NULL default '0',                  
                 `pa_lmt` int(2) NOT NULL default '0',                  
                 `pr_lmt` int(2) NOT NULL default '0',                  
                 `ro_lmt` int(2) NOT NULL default '0',                  
                 `sh_lmt` int(2) NOT NULL default '0',                  
                 `wk_lmt` int(2) NOT NULL default '0',                  
                 `wa_lmt` int(2) NOT NULL default '0',                  
                 `min_lvl` int(2) NOT NULL default '0',                 
                 `max_lvl` int(2) NOT NULL default '0',                 
                 `max` varchar(255) NOT NULL default '',                
                 PRIMARY KEY  (`raid_id`)                               
               ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
 
phpraid_signups  CREATE TABLE `phpraid_signups` (                         
                   `signup_id` int(10) NOT NULL auto_increment,           
                   `char_id` int(10) NOT NULL default '0',                
                   `profile_id` int(10) NOT NULL default '0',             
                   `raid_id` int(10) NOT NULL default '0',                
                   `comments` varchar(255) NOT NULL default '',           
                   `cancel` int(1) NOT NULL default '0',                  
                   `queue` int(1) NOT NULL default '0',                   
                   `timestamp` varchar(255) NOT NULL default '',          
                   PRIMARY KEY  (`signup_id`)                             
                 ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
 
 
Mission:
 
Fetch the last next 5 raids from and including today, and add a colum to the result that shows if a user is signed up or not.
 
So far:
select raid_id,location,FROM_UNIXTIME(start_time) as start_time from phpraid_raids where DATE_SUB(CURDATE(), INTERVAL 0 DAY) <= FROM_UNIXTIME(invite_time) order by raid_id asc limit 5

This shows the next 5 raids.. and.. well.. that's about it :-/

When a raid(an event) is made, a row is inserted into phpraid_raids

And when a user signs up for this raid(event) a row is inserted into phpraid_signups, with a raid_id that matches the one i phpraid_raids.