search

phproad / phpr-framework

[PHPR Framework] PHPRoad system files
http://phproad.com
MIT License
12 stars 2 forks source link

DB query with multiple variable placeholders #20

Closed highruned closed 7 years ago

highruned commented 11 years ago

Currently this does not work:

                Db_Helper::query('update tickets set item_id = ? where id = ?', $item->id, $this->id);

We should fix at some point. We're using this for now:

                Db_Helper::query('update tickets set item_id=:item_id where id=:ticket_id', array(
                    'item_id' => $item->id, 
                    'ticket_id' => $this->id
                ));
highruned commented 7 years ago

Still love what we built here but gotta clean up my open issues~