MYsqlL IF status=0 statement never returns row , it works if i remove IF statment

See more:

MySQL

Dear All:
i m a newbie in MySql
kindly help me where i m mistaken in that IF Statement that its not running when i give last paramenter(Status)=0.
Same queries working fine independently when i run them in query editor.
also tell me some authentice MYSQL envoirnment esp. to run Functions and procedure.
thanks
Nazish

BEGIN
IF   (Status =0)  THEN
SELECT * , st.SRTech_Description AS RStatus, st.SRTechStatus_Name AS RSInitials
FROM requestdeployment rd, sr_TechStatus st, SupportRequest SR
LEFT JOIN Locations L ON SR.SR_SupportLId = L.Id
WHERE Scc_id
IN ( Con )
AND sr.SR_id = rd.requestid
AND SRTechStatus_ID
IN (
SELECT STATUS FROM requestdeployment
WHERE RequestId = SR.SR_Id
)
and rd.active!=1
and rd.deployedby=DPID
and rd.status=st.srtechstatus_id;



ELSE

SELECT * , st.SRTech_Description AS RStatus, st.SRTechStatus_Name AS RSInitials
FROM requestdeployment rd, sr_TechStatus st, SupportRequest SR
LEFT JOIN Locations L ON SR.SR_SupportLId = L.Id
WHERE Scc_id
IN ( Con )
AND sr.SR_id = rd.requestid
AND SRTechStatus_ID
IN (

SELECT STATUS FROM requestdeployment
WHERE RequestId = SR.SR_Id
)
and rd.active!=1
and rd.deployedby=DPID
and rd.status=st.srtechstatus_id
and st.SrtechStatus_ID=Status;
END IF;

END