Run custom query in symfony 1.2 with propel
Sometimes we require to execute complex query in symfony 1.2 with propel. For this following code can be used.
$conn = Propel::getConnection(); $query = “Select * from table” $statement=$conn->prepare($query); $statement->execute(); $rowObj = $statement->fetch(PDO::FETCH_OBJ);
$rowObj will have result of your given query. You can check it via var_dump or print_r and show it as you want.