bladechob Posted October 25, 2007 Share Posted October 25, 2007 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? Link to comment https://forums.phpfreaks.com/topic/74725-solved-dim-moment-with-echoes/ Share on other sites More sharing options...
effigy Posted October 25, 2007 Share Posted October 25, 2007 SELECT alloname FROM abacus WHERE client = 'Z' group by alloname Link to comment https://forums.phpfreaks.com/topic/74725-solved-dim-moment-with-echoes/#findComment-377803 Share on other sites More sharing options...
bladechob Posted October 26, 2007 Author Share Posted October 26, 2007 cheers - I'll give that a go! Link to comment https://forums.phpfreaks.com/topic/74725-solved-dim-moment-with-echoes/#findComment-378427 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.