when I try to get the information populated in a web page i just seem to get their ID instead of the information related to it?
for example:
Address: 2
Fax#:2
Email:2
here is the sql string:
$sql = "SELECT DISTINCT ag.AgencyID, ag.CompanyName, ag.Address, ag.StateOrProvince, ag.City,
ag.Phone, ag.Email, ag.Fax, ag.ContactName, ag.TollFree, ag.WebSite,
ar.Area, s.Services
FROM Agencies ag
INNER JOIN AgencyAreas aa ON (ag.AgencyID = aa.AgencyID)
INNER JOIN Areas ar ON (aa.AreaServedID = ar.AreaServedID)
INNER JOIN AgencyServices ags ON (ag.AgencyID = ags.AgencyID)
INNER JOIN Services s ON (ags.ServiceID = s.ServiceID)
INNER JOIN UserLogin ul ON (ag.AgencyID = ul.AgencyID)
WHERE ul.UserName ='".$username."'
AND ul.Password LIKE '".$password."'";
$result= mysql_query($sql);
$CompanyName = mysql_result($result,"CompanyName");
$Address = mysql_result($result,"Address");
$Province = mysql_result($result,"StateOrProvince");
$City = mysql_result($result,"City");
$ContactName = mysql_result($result,"ContactName");
$fax = mysql_result($result,"fax");
$email = mysql_result($result,"email");
$web = mysql_result($result,"web");
Thanks for looking
