How to rewrite normal sql select with IF to Zend Framework select?

Question

I have a normal mysql select and I would like to rewrite it to a Zend Framework mysql select. Here is my select:

$sql = "
     SELECT 
        IF(mu.recieverUserId = '{$userId}', u.senderUserId, 
            mu.recieverUserId) friend1,
            u.mesaj, u.senderUserId, mu.recieverUserId,
            u.created
        FROM 
            (SELECT * 
            FROM mesaje
            ORDER BY `created` desc) AS u
        LEFT JOIN `mesaje_utilizatori` AS `mu` ON u.id=mu.mesajId   
        WHERE (mu.recieverUserId = '{$userId}' OR   u.senderUserId='{$userId}')             
              GROUP BY friend1 ASC 
          ORDER BY `u`.`created` DESC, u.id DESC
        ";

This is not the way to ask the question, this is some one else is solving you problem and you are putting zero effort on it.. You can ask like how inner query works in zend and how to write conditions in zend select query — Sahal
– Sahal, Commented Nov 12, 2012 at 9:26
stackoverflow.com/questions/1340564/… .... stackoverflow.com/questions/5792229/… — Sahal
– Sahal, Commented Nov 12, 2012 at 9:28
this appears to be a useful reference incl joins framework.zend.com/manual/1.12/en/zend.db.select.html — Drew
– Drew, Commented Nov 12, 2012 at 9:29
It's not a duplicate, this question is more than just a simple JOIN — tsergium
– tsergium, Commented Nov 12, 2012 at 9:47

tsergium · Accepted Answer · 2012-11-12 09:45:50Z

2

Here is the documentation: Zend_Db_Statement

Zend Query

$sql = $db->query(
   'SELECT 
   IF(mu.recieverUserId = ?, u.senderUserId, 
     mu.recieverUserId) friend1,
   u.mesaj, u.senderUserId, mu.recieverUserId,
   u.created
    FROM 
   (SELECT * 
   FROM mesaje
   ORDER BY `created` desc) AS u
   LEFT JOIN `mesaje_utilizatori` AS `mu` ON u.id=mu.mesajId 
    WHERE (mu.recieverUserId = ? OR u.senderUserId = ? )    
    GROUP BY friend1 ASC 
    ORDER BY `u`.`created` DESC, u.id DESC',
   array($userId, $userId,$userId)
  );

Zend Result

 while ($row = $sql->fetch()) {
   Zend_Debug::dump($row);
  }

answered Nov 12, 2012 at 9:45

tsergium

1,1761 gold badge14 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to rewrite normal sql select with IF to Zend Framework select?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related