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.