[SOLVED] Dim moment with echoes!

[bladechob]

Hi, I can't remember the query string to return specific 'clients' from the SQL. I.e. I have a database set up with a number of clients X, Y, Z. X has their own prefs as does Y and Z although sometimes their needs cross. Here's the code as it stands for returning the products (allonames). What I need to to is that on this ocassion only return entries for client Z.

 

<?php
		$query="SELECT alloname FROM abacus group by alloname";
		mysql_select_db('cimnet_europe');
		if(!$result=mysql_query($query)){echo mysql_error();}
		while ($r=mysql_fetch_array($result)){
			echo '<option value="'.$r['alloname'].'">'.$r['alloname'].'</option>';
		}
		?>

It's bringing back all the entries from the alloname table all I want these guys to see is their stuff from the allonames specific to them...

 

Does that make sense?

[effigy]

SELECT alloname FROM abacus WHERE client = 'Z' group by alloname

[bladechob]

cheers - I'll give that a go!