How to spererate groups of results?

[sgtpepper]

I have a query like this

$query="SELECT * FROM agents where office_name='florida'
or office_name='texas' or office_name='london'";

When I display the results....it lists them all togther....how can I add a graphic or line seperating each group? For example

florida result
florida result
florida result
florida result

---

texas result
texas result
texas result

---

london result
london result

---

thanks!

[devinemke]

the basic idea:

$result = mysql_query("SELECT * FROM agents WHERE office_name = 'florida' OR office_name = 'texas' OR office_name = 'london' ORDER BY office_name") or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	$office_name[$row['office_name']][] = $row;
}

foreach ($office_name as $key => $value)
{
	foreach ($value as $sub_key => $sub_value)
	{
		echo $key . ' (result)<br>';
	}
	echo '<hr>';
}

[sgtpepper]

Wow....thanks...this is very close....but I have a few questions....

1) How can I replace the lines with a graphic for each group? For example....a graphic that has the name of the office.....than the group results?

2) I also need to print out more data about the group. This is basically a database a real estate agents. I would like to be able to display images, bios, and name data from the group. What I have is below.....you will see that I tried to echo $row[agent_pic]

$result = mysql_query("SELECT * FROM agents where office_name='Coldwell Banker 1'
or office_name='Coldwell Banker 1'
or office_name='Coldwell Banker 3'") or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
    $office_name[$row['office_name']][] = $row;
}

foreach ($office_name as $key => $value)
{
    foreach ($value as $sub_key => $sub_value)
    {


    echo $key . ' (result)<br>';

echo $row[agent_pic];

}
echo '<hr>';
}

I really appreciate your help! Thanks

[TheDefender]

Few things to consider...
1) You've already exited out of the WHILE loop where you are fetching the array's contents of the query, so when you echo the agent_pic, you are only ever going to echo the last one retrieved.
2) This echo $row[agent_pic]; should be this: echo $row['agent_pic']; You need to quote your index name so the PHP parser properly understands what you're trying to echo out.
3) Because of what you are wanting to do, and the manner in which you are trying to do it, you're going to start getting into multi-dimensional arrays so you can associate all of that with the particular office name...

How familiar are you with arrays and multi-dimensional arrays? Post back, and we (collectively) should be able to guide you along the right path.

[sgtpepper]

Thanks defender!

I use and am fairly familiar with arrays....however multi-demensional arrays are totally new to me. They also seem very complicated. 😕

Thanks