problem with the output format

[Francis_htli]

Here's the PHP code

<?php
$sql="select b.company, b.address, b.city, b.province, b.postcode, b.phone, b.fax, a.firstname, a.lastname, a.email, a.title, a.accountid FROM m_users a, CG_branch_profile b where a.accountid=b.account order by b.company, b.address, b.city, b.province, b.postcode, b.phone, b.fax";

$result=mysql_query($sql, $dblink);
while ($result1=mysql_fetch_array($result)) {

echo "<table border='1' width='100%'><tr><td>";
echo $result1['branch'];
echo "<BR>";
echo $result1['company'];
echo "<br>";
echo $result1['address'];
echo "<br>";
echo $result1['city'];
echo ", ";
echo $result1['province'];
echo " ";
echo $result1['postcode'];
echo "<br>Telephone: ";
echo $result1['phone'];
echo "<br>Fax: ";
echo $result1['fax'];
echo "</td></tr><tr><td>";
echo $result1['firstname'];
echo " ";
echo $result1['lastname'];
echo ", ";
echo $result1['email'];
echo ", ";
echo $result1['title'];
echo "</td></tr></table>";


}
?>

The following is the output:

ABC INC.
123 - 167 ST.
EDMONTON, Alberta T5M 9U7
Telephone: (780) 589-4589
Fax: (780) 589-1897
Richard king, king@abc.ca, Technical Support Spe******t
ABC INC.
123 - 167 ST.
EDMONTON, Alberta T5M 9U7
Telephone: (780) 589-4589
Fax: (780) 589-1897
Curtis King, , Product Manager
ABC INC.
123 - 167 ST.
EDMONTON, Alberta T5M 9U7
Telephone: (780) 589-4589
Fax: (780) 589-1897
Andrew King, kinga@abc.ca, Product Manager

What do I need to change to the php code that generate the following output?
ABC INC.
123 - 167 ST.
EDMONTON, Alberta T5M 9U7
Telephone: (780) 589-4589
Fax: (780) 589-1897
Richard king, king@abc.ca, Technical Support Spe******t
Andrew King, kinga@abc.ca, Product Manager
Curtis King, , Product Manager

[strasm]

ok, this is pretty easy. You have a pretty complex query; I would try and break the query into to separate queries. The first query for the general data, then the second query will be a loop that will go for each contact. like this.

while($result2 = mysql_fetch_array($result)){
  echo "<tr><td>";
  echo $result1['firstname'] ." " .$result1['lastname'] .", " .$result1['email']. ", " .$result1['title'];
  echo "</td></tr>";
}