query("SELECT * FROM dealers ORDER BY Company", MYSQLI_USE_RESULT); if ($uresult) { echo ""; while ($data = $uresult->fetch_assoc()) { $ID = $data["ID"]; $Company = $data["Company"]; $POC = $data["POC"]; $Address1 = $data["Address1"]; $Address2 = $data["Address2"]; $Location = $data["Location"]; $Phone = $data["Phone"]; $Office = $data["Office"]; $Cell = $data["Cell"]; $Fax = $data["Fax"]; $Link = $data["Link"]; $Email = $data["Email"]; echo ""; $count=$count+1; if ($count > 3) { echo ""; $count=1; } } $uresult->close(); ?>

"; if ($Company!='') { echo "$Company "; if ($POC!='') { echo "$POC "; } } if ($Company=='') { echo "$POC "; } if ($Address1!='') { echo "$Address1 "; } if ($Address2!='') { echo "$Address2 "; } if ($Location!='') { echo "$Location "; } if ($Phone!='') { echo "$Phone "; } if ($Office!='') { echo "$Office "; } if ($Cell!='') { echo "Cell - $Cell "; } if ($Fax!='') { echo "$Fax - Fax "; } if ($Link!='') { echo "Website "; } if ($Email!='') { echo "$Email"; } echo "