mssql subselect to mysql

[valen53]

i need to change my DB from mssql to mysql now. i face a problem.

$dept_Fr = "Select depart_from from OT_login where emp_id ='$ecm'";
$dept_To = "Select depart_to from OT_login where emp_id ='$ecm'";

$query = "Select * from dw_emp where DEPT_ID >=($dept_Fr) and DEPT_ID <=($dept_To)";

this subselect was function for mssql but possible or not for mysql ? b'cos i can't select out any data when using mysql. any method can used for replace this subselect ?
thank a lot...

[rrijnders]

Run 2 queries seperately:

$query1="Select depart_from, depart_to from OT_login where emp_id ='$ecm'";

Put the results of that query into variables $fromand $to, then:

$query2="Select * from dw_emp where DEPT_ID >=$from and DEPT_ID <=$to";