Need some array help BIGTIME!!!

[johnvca]

OK so I'm having a serious brain fart here... Could someone help me figure something out please? I'm trying to get titles of salon processes to display and have each individual service display underneath.  For example, if it's hair color services, I want hair color services in bold with a list of all hair color services underneath. Here's my code:

 

$results = mysql_query(
"SELECT * " .
"FROM menu " . 
"INNER JOIN menu_process " .
"ON menu_process.id=menu.process_id " . 
"WHERE menu.category_id=1 " . 
"ORDER BY menu.process_id"
);

while ($data = mysql_fetch_array($results)) {

$title	 = $data["process"];
$service = $data["service"];

printf ("<b>$title</b><br />$service");

};

 

What this is returning is the title (ie. hair color services) above EVERY hair color service listed below. 

 

Now there are about 5 or 6 titles in the database and each has about 10 items to display underneath as services. HELP PLEASE!!!

[johnvca]

anyone???

[PFMaBiSmAd]

See the method used in this post - http://www.phpfreaks.com/forums/php-coding-help/retrive-from-mysql-by-date/msg1504124/#msg1504124

[johnvca]

Thank you so much, that worked great! These forums are a fantastic resource!