You shouldn't need to use parameters or session variables. You can just use:
SELECT dreamcarCOMPID, dreamcarCOMPDATESTART, dreamcarCOMPDATEND, dreamcarCOMPTITLE, dreamcarCOMPSUMMARY, dreamcarCOMPTEXT, dreamcarCOMPIMG, dreamcarCOMPDELETE FROM dreamcarCOMPS WHERE dreamcarCOMPDATESTART <= CURDATE() AND dreamcarCOMPDATEND >= CURDATE()