CODEWITHSUNDEEP
symfony1symfony-1.4propel
Jane
Jane

Reputation: 21

mysql to Criteria() in symfony 1.4.9

I have the following complex query in mySQL 

SELECT courseId,courseName
FROM course WHERE courseId NOT IN (SELECT courseId FROM coursestaken NATURAL JOIN student WHERE grade >= 60 AND studentId =2) 
AND
courseId NOT IN (SELECT courseId FROM stable WHERE studentId = 2 )
AND
courseId NOT IN (SELECT DISTINCT courseId FROM prerequisites 
WHERE
prereqId NOT IN (SELECT courseId FROM coursestaken NATURAL JOIN student WHERE grade >= 60 AND studentId =2  )) ;

Can someone help me convert this to a Criteria() query in Propel?

Upvotes: 2

Views: 615

Answers (1)

Bhanu Krishnan
Bhanu Krishnan

Reputation: 3726

Try using prepare function in propel like below

    $con=Propel::getConnection();
            $obj = $con->prepare("SELECT courseId,courseName
FROM course WHERE courseId NOT IN (SELECT courseId FROM coursestaken NATURAL JOIN student WHERE grade >= 60 AND studentId =2) 
AND
courseId NOT IN (SELECT courseId FROM stable WHERE studentId = 2 )
AND
courseId NOT IN (SELECT DISTINCT courseId FROM prerequisites 
WHERE
prereqId NOT IN (SELECT courseId FROM coursestaken NATURAL JOIN student WHERE grade >= 60 AND studentId =2  )) ");
            $obj->execute();
            $resultset = $obj->fetchAll();

Upvotes: 4

Related Questions