exclude - mysql query
| From: | Brad Ciszewski | Date: | Mon, 29 Nov 2004 00:28:24 +0000 |
| Subject: | exclude - mysql query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-203036@lists.php.net to get a copy of this message | ||
i have several tables with data, and they all have a server column. there
are a few tables which i need to exclude a particular server from that
table. i am currently running an array to extract the data, and was
wondering if i could either use PHP code or a mysql-query exclude function
or something so these servers are available. below is the php script i
currently have... which needs the excluding script/query.
<select name="s1" id="s1">
<?PHP
// List servers from game \\
$get_servers = mysql_query("SELECT * FROM game_$game ORDER BY server ASC");
while($gs=mysql_fetch_array($get_servers)){
extract($gs);
echo ?>
<option value="<?PHP echo($server); ?>"><?PHP echo($server);
?></option>
<?PHP } ?>
</select>
any ideas at all?
www.BradTechnologies.com
99.9% Uptime
24/7 FREE Support
Plans starting at $3.50 per month
www.BradTechnologies.com