[SOLVED] How to Save Query Value into variable?

[arkanimus]

how can i save the value of a query into a variable...??

 

example..

 

$sql = select name from products where id_product = '33';

 

$name = (HERE I NEED SAVE THE NAME)

 

help me please!

Edited November 26, 2013 by vekia (see edit history)

[Krystian Podemski]

See classes/Db.php - getValue method. 

[arkanimus]

Solved:

 

in the controller:

 

$id_cart = $this->context->cart->id;   


//SE CONSULTA EN LA BD LA CANTIDAD DE CAJAS


$sql = 'SELECT cantcajas FROM `'._DB_PREFIX_.'cart`
where `id_cart` = '.$id_cart.' ';   


// LA CANTIDAD SE ASIGNA A $CANTIDAD
$cantidad = Db::getInstance()->getValue($sql);

[vekia]

hello

 

thank you for confirmation that you solved it and for your full solution, it will be really helpful for other merchants here

thread marked as [solved]

 

with regards,

Milos