[SOLVED] Using POST

[Daney11]

Hey guys

 

Im currently using

 

<select class="forminput" name="server_game">
<?php 
$gamequery=mysql_query("SELECT * from `games` WHERE `game_active`='Yes' ORDER BY `game_name` ASC");

while($row_games=mysql_fetch_array($gamequery)){

echo "<option value=\"{$row_games['game_name']}\"";

echo ">{$row_games['game_name']}</option>\n";
}

?>
</select>

 

It works fine but after the form has been submitted, the options dissappear..... Any ideas?

[budimir]

Where do you redirect after POST?

[PHP Monkeh]

Try adding mysql_error() on your query to see if it's generating any errors after you submit:

 

$gamequery=mysql_query("SELECT * from `games` WHERE `game_active`='Yes' ORDER BY `game_name` ASC") or die(mysql_error());

[Daney11]

Try adding mysql_error() on your query to see if it's generating any errors after you submit:

 

$gamequery=mysql_query("SELECT * from `games` WHERE `game_active`='Yes' ORDER BY `game_name` ASC") or die(mysql_error());

 

when i add the or die bit my page breaks and doesnt show me an error. :S

 

and the page stays as it is after posting.

[Daney11]

Ive got it working now

 

Im using

 

<select class="forminput" name="server_game">
<?php 
$gamequery = "SELECT * from `games` WHERE `game_active`='Yes' ORDER BY `game_name` ASC";
$gameresult = mysql_query($gamequery, $connect) or die(mysql_error());

while($row_games=mysql_fetch_array($gameresult)){

echo "<option value=\"{$row_games['game_name']}\"";

echo ">{$row_games['game_name']}</option>\n";
}

?>
</select>

 

Thanks anyway guys.