[SOLVED] Get datetime "to" and "from" from specific price in script using

[shaft]

Hi,

 

I am writting a script, that use a db. Last 2 hours I trying to get a value in datetime "from" and "to" column, but withnout sucess. 

 

Trying like this:

$foreach_speci_price = "2";
$get_speci_to = Db::getInstance()->getValue('SELECT to FROM '._DB_PREFIX_.'specific_price WHERE id_specific_price = \''.pSQL($foreach_speci_price).'\'');
echo $get_speci_to;

But it is not working.

 

Can anyone help?

 

Thank you.

 

Shaft :-)

Edited October 3, 2015 by shaft (see edit history)

[shaft]

Hi,

 

I am writting a script, that use a db. Last 2 hours I trying to get a value in datetime "from" and "to" column, but withnout sucess. 

 

Trying like this:

$foreach_speci_price = "2";
$get_speci_to = Db::getInstance()->getValue('SELECT to FROM '._DB_PREFIX_.'specific_price WHERE id_specific_price = \''.pSQL($foreach_speci_price).'\'');
echo $get_speci_to;

But it is not working.

 

Can anyone help?

 

Thank you.

 

Shaft :-)

So after trying next hours it is a simple way. Problem was in table called "to" and "from" ... It is a same name in MySQL syntax.

In my case:

$foreach_speci_price = "2";
$get_speci_to = Db::getInstance()->getValue('SELECT `to` FROM '._DB_PREFIX_.'specific_price WHERE id_specific_price = \''.pSQL($foreach_speci_price).'\'');
echo $get_speci_to;

Maybe it help someone. Marked as SOLVED.