How to Add one more WHERE condition in PHP ?

Question

I am new to PHP . I am editting a php script . This script has a function that selects many values from a table but I need this Script to SELECT values from those rows only whose country_id = 100 only .
Can you please add this condition for me into following script (to select only values whose row has country_id = 100 } )
...............

$sql = "SELECT
c.category_id,
c.parent_id,
cd.name,

(SELECT COUNT(*) FROM `" . DB_PREFIX . "category` cc WHERE cc.parent_id = c.category_id) as children

FROM `" . DB_PREFIX . "category` c
LEFT JOIN `" . DB_PREFIX . "category_description` cd
ON (c.category_id = cd.category_id)
WHERE c.parent_id = " . (int)$parent_id . "
AND c.status = 1

AND cd.language_id = " . (int)$this->config->get('config_language_id') . "
ORDER BY c.sort_order, cd.name ASC";

Answer 1

Just add it anywhere in the WHERE clause:



AND c.status = 1 AND country_id = 100 AND cd.language_id = ...

Answer 2

One of the most HORRIBLE query I have seen for the last 20 years...

When you have to use "JOIN", your database is badly structured.

When you have to use functions in a query, your access to db is drafty to say the least.

Jeff P gave you the answer, but you will hit similar problems all the way through your development.

Answer 3

You should use where statement inside if statement