remyaarun

$expdate = date("M-d-Y",mktime(0,0,0, date("m")+28, date("d"), date("Y")));

I tried out this same code with my tables. And its correctly working.

SELECT * FROM bonanza_weeks WHERE bonanza_weeks.week_id NOT IN (SELECT bonanza_actuals.week_id FROM bonanza_actuals WHERE bonanza_actuals.week_id = bonanza_weeks.week_ID)

select * from weeks where weeks.week_id not in (select * from actuals where actuals.id=weeks.week_id) try with this

select * from weeks left join actuals on weeks.id = actuals.id; Try out with this code.

This was the previous code: ***** $conn = mysql_connect('host:port',username','password'); $db = mysql_select_db('dbname', $conn); May be the problem is for the statement mysql_connect('host:port',username','password'); here the single quotes for username is not corect ..just change it to 'username' and do check it out