SQL syntax error

[waynew]

I keep getting

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id FROM jobs WHERE status = 1 AND MONTH(reg_date) = '10'' at line 2

 

$i=0; //reset counter

while($i < sizeof($x_months)){
     
 $profit_result[$i] = mysql_query("SELECT SUM(tender_price) FROM tenders 
                                   WHERE job_id = SELECT id FROM jobs WHERE status = 1 AND MONTH(reg_date) = '$months_timeline[$i]'") or die(mysql_error());
 $i++;
}

 

What's wrong????!

[atticus]

Have you tried running the sub query in parenthesis?

 

 

[atticus]

Have you tried running the sub query in parenthesis?

 

 

 

SELECT SUM(tender_price) FROM tenders 
WHERE job_id = (SELECT id FROM jobs WHERE status = 1 AND MONTH(reg_date) = '$months_timeline[$i]')