Got it! Thanks. I changed my code to this and it works:
/*Get address detail*/
$result = db_query('SELECT street FROM {terr_master} AS m
WHERE tid = %d
GROUP BY m.street
ORDER BY m.street ASC', $tid);
while($data = db_fetch_object($result)) {
$streets = $data->street;
$result2 = (db_query('SELECT `house`, `apt`, `name`
FROM {terr_master} AS m
WHERE tid = %d
AND street = \'%s\'
ORDER BY m.house ASC', $tid, $data->street));
$page_content .= '<strong>' . $streets . '</strong><br/>';
while ($addresses = db_fetch_object($result2)){
$cells = $addresses->house . ' ' . $addresses->apt .' ' . $addresses->name . '<br/>';
$page_content .= $cells;
}
}
return $page_content;
I'm actually using placeholders in my query where I escape the streetname string. I didn't show that in my previous post. Thanks again!