ORDER BY name ASC problem

[kvnirvana]

I need to add ORDER BY name ASC to this code

 

foreach($db->query("SELECT * FROM company_subcategory WHERE category_id = ".(int) $category_id) as $row) { $r[] = new CompanySubCategory($row['subcategory_id'], $row);}

 

Tried to do it like this, but it doesn't work

 

foreach($db->query("SELECT * FROM company_subcategory WHERE category_id = ".(int) $category_id ORDER BY name ASC) as $row) { $r[] = new CompanySubCategory($row['subcategory_id'], $row);}

 

Any help much appreciated

 

Thanks in advance

[Buddski]

You will need to close the quote around the $category_id, assuming that the original code worked

foreach($db->query("SELECT * FROM company_subcategory WHERE category_id = ".(int)$category_id." ORDER BY name ASC") as $row) { $r[] = new CompanySubCategory($row['subcategory_id'], $row);}

[kvnirvana]

Thank you so much