SQL query

[Chill_user]

Hello, here is my code:

$result = Db::getInstance()->getRow('
                        SELECT `id_category`
                        FROM `'._DB_PREFIX_.'category_group` 
                        WHERE `id_category` = '.$id_category'
                        AND `id_group` = '.$id_customer'
                        ');

But I have an error! If I delete 'AND' statement line, all is working (valid code)

Tried to send this request with "Advanced Parameters -> Database -> SQL" and all is working well! (of course I changed $id_category and $id_customer for numbers)

What is the problem with code?

Edited January 24, 2020 by Amantha Bill (see edit history)

[Nishith Nesdiya]

Hi..

use this code may be help not tested i hope its wrok

 

$query = 'SELECT id_category FROM `'._DB_PREFIX_.'category_group` WHERE `id_category` = '.$id_category.' AND `id_group` = '.$id_customer;
$result = Db::getInstance()->getRow($query);

Thanks

[Chill_user]

10 minutes ago, Nishith said:

Hi..

use this code may be help not tested i hope its wrok

 

$query = 'SELECT id_category FROM `'._DB_PREFIX_.'category_group` WHERE `id_category` = '.$id_category.' AND `id_group` = '.$id_customer;
$result = Db::getInstance()->getRow($query);

Thanks

Thanks 4 quick reply!

Yes, it's working! But I didn't understand what was incorrect in my code...

[Knowband Plugins]

Hi,

Kindly refer to line below for the error (& Differences).

Your Code:

SELECT `id_category`
FROM `'._DB_PREFIX_.'category_group` 
WHERE `id_category` = '.$id_category'
AND `id_group` = '.$id_customer'

 

It should be
 

SELECT `id_category`
FROM `'._DB_PREFIX_.'category_group` 
WHERE `id_category` = '.$id_category.'
AND `id_group` = '.$id_customer.'

 

(Dot after the $id_category & $id_customer)