Zend insert user and set value to max()+1

Question

My code:

public function insertMember($member) 
{   
    $maxOrderNumber = $this->select()
        ->from($this, array(new Zend_Db_Expr('max(order_number)')));

    $id = $this->insert($member, $maxOrderNumber);
    return $id;
}

I want to insert member to last position in members table and order_number entity. Tried with $maxOrderNumber but i keep getting 0 value in database.

Im using MySql. Also i have user_id with (AI) Autoincrement so i'm forced to function this way.

It's been a while since I used ZF1, but `$this->select()` returns a query object - you will need to execute that query to get your integer value. — Tim Fountain, Jul 17 '16 at 11:51

score 0 · Accepted Answer · answered Jul 19 '16 at 04:36

public function insertMember($member) 
{   
    $maxOrderNumber = $this->select()
        ->from($this, array(new Zend_Db_Expr('max(order_number)')));
    $stmt = $maxOrderNumber ->query();
     $result = $stmt->fetchAll();

    $id = $this->insert($member, $result ['order_number']);
    return $id;
}

soemthing like that...

Zend insert user and set value to max()+1

1 Answers1