Jump to content

[SOLVED] Dim moment with echoes!


bladechob

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.