[solved]Prestashop 1.6.1.14 - Database Query Returns 1 on Execute

[PrestashopEnthu]

I am currently using the code below in Prestashop to retrieve a cart id.

public function hookDisplayPDFInvoice($params) {

$order_invoice = $params['object'];
$id_order = (int)$order_invoice->id_order;

$sql = 'SELECT id_cart FROM '._DB_PREFIX_.'orders WHERE id_order="'.$id_order.'"';
//example id_cart
$id_cart = Db::getInstance()->execute($sql);
return $id_cart;

In database, there are id_cart and id_timeslot. Table is called ps_cart_timeslot.

I am quite stuck as I am baffled as to why the data return is 1 for any data I am retrieving.

$id_order is fine, it is returning the right value. Any data select I am querying will return 1.

Am I missing anything? Pardon me if this is a silly mistake.

Thank you.

[PrestashopEnthu]

Solved.

$query = new DbQuery();
$query->select('xxx')
->from('yyy')
->where('zzz = ' . (int)$www);
Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($query);

 

Edited November 1, 2017 by Enthu86 (see edit history)