Query help, only getting back 1 element

[DougieC]

here is a sample of how i set up my tables:

[AgencyID|ServiceID]      [ServiceID|Services]
|    1   |     1  |       |  1    | blah1    |
|    1   |     2  |       |  2    | blah2    |
|    1   |     3  |       [  3     | blah3   ]
[    2   |     1  ]  

so an Agency might offer many services.

when I do my query

$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.ServiceID


	FROM Agencies ag, AgencyServices ags

	INNER JOIN AgencyAreas aa ON (ag.AgencyID = aa.AgencyID)
	INNER JOIN Areas ar ON (aa.AreaServedID = ar.AreaServedID)

	INNER JOIN AgencyServices a 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."'";

and try to get the values for ServiceID
$ServiceID =mysql_result($result,0,"ServiceID");
I only get the first value?
any ideas?

[stolzyboy]

$sql = "blah, blah......";
$result = mysql_query($sql);

while ($row = mysql_fetch_array($result))
{
echo $row['ServiceID'];
}

[DougieC]

Thanks again 😃