Re: PHP/MySQL Query help with Two Tables
Posted: Tue Nov 17, 2009 11:37 am
WOOOOT!!
That fixed it! It now clears the old jobs from yesterday and displays new jobs for the next days 
Code: Select all
$result = mysql_query("SELECT
j.jobs_id,
j.jobs_description,
d.jobs_done_id,
d.jobs_timedone,
d.jobs_comment,
d.jobs_user
FROM tbl_jobs AS j
LEFT JOIN tbl_jobs_done AS d
ON j.jobs_id = d.jobs_id
AND DATE(d.jobs_date) = DATE(NOW()+INTERVAL 16 HOUR)
WHERE j.jobs_datetype IN('$everyday', '$dayname', '$wtype')
ORDER BY jobs_id ASC");