[SOLVED] Display once

[papaface]

Hello,

I have this code:

		$_getnames = mysql_query("select inspector_id from requests");

if	(mysql_num_rows($_getnames) >0)
	{

		while(list($inspector_id) = mysql_fetch_array($_getnames))

 

That correctly displays the ID's for the inspectors. However how can I make it so it only shows each ID once, rather than displaying it for every record?

 

Thanks

[papaface]

Ah i figured it out.

select inspector_id from requests group by inspector_id

thanks