order by name

[kvnirvana]

foreach($db->query("SELECT * FROM company_people WHERE company_id = ".(int) $company_id) as $row) {

$r[] = new People($row['people_id'], $row);

 

 

I want to make this query order by name, how should I do that, can't figure it out

 

Thanks in advance

[Adam]

It's a little messy having the SQL within the function like that, separate it into a variable and you'll probably find it easier to work out the syntax in future. In this case, you just need to re-open the string after the variable and add the order by clause:

 

$sql = "SELECT * FROM company_people WHERE company_id = " . (int) $company_id . " order by name";
[...]