php - sql: result be only data with a specific item_id -



php - sql: result be only data with a specific item_id -

how can, in code, result info specific item_id item_id = 3?

$articles = $dbread->select() ->from('articles', array('article_id', 'name', 'item_id')) ->joinusing('items', 'item_id', array('item_name')) ->order(array('updated desc'));

try :

$articles = $dbread->select() ->from('articles', array('article_id', 'name', 'item_id')) ->joinusing('items', 'item_id', array('item_name'))->where("items.item_id = 3") ->order(array('updated desc'));

php sql

Comments

Popular posts from this blog

formatting - SAS SQL Datepart function returning odd values -

c++ - Apple Mach-O Linker Error(Duplicate Symbols For Architecture armv7) -

php - Yii 2: Unable to find a class into the extension 'yii2-admin' -