[RESOLVED] Show selected option in dropdown with mysql

Vitez_Kolya

Hi, I'm new to this forum and PHP in general. This code is for an admin editing page that I'm working on. What I'm trying to do is have the dropdown box fill out from game_categories table, and have the option that has been set in games table to be selected.

<?php

echo '<p><a id="rows2">Games Select:</a><select name="game_cat_id" id="game_cat_id"><option value="">Select a Game</option>';

$serverQuery = "SELECT c.game_cat_id AS gameCat_id, c.game_category FROM game_categories AS c";

$serverCompareQuery = "SELECT game_cat_id , game_id FROM games AS g WHERE game_id=$id";

$serverCompareResult = @mysql_query ($serverCompareQuery);

$serverResult = @mysql_query ($serverQuery);

while ($serverRows = mysql_fetch_array($serverResult, MYSQL_ASSOC)) {

	$compareRows = mysql_fetch_array($serverCompareResult, MYSQL_ASSOC);

	echo '<option ';

		if($compareRows['game_cat_id'] == $serverRows['gameCat_id']) {
			echo 'selected="selected"';
		} else {
			echo '';
		}

	echo ' value=' . $serverRows['gameCat_id'] . '>' . $serverRows['game_category'] . '</option>\n';
}

echo '</select></p>';
?>

sneakyimp

I'm not sure exactly what your code was attempting to do, but it looks a bit suspect. I'm guessing that there is some current game that belongs to some game category? I would probably simplify it:

//1) Fetch the current game information including the current game id and put it in array using mysql_fetch_assoc()
$sql = "SELECT game_cat_id, game_id FROM games WHERE game_id=$id";
$result = mysql_query($sql)
  or die('query to fetch game info failed!');
$game_info = mysql_fetch_assoc($result)
  or die('query failed to fetch anything');
$current_game_cat_id = $game_info['game_cat_id'];
//2) Fetch all the game categories and loop through them, setting selected if the category_id matches the current game id
$sql = "SELECT game_cat_id, game_category FROM game_categories";
$result = mysql_query($sql)
  or die('query to fetch game categories failed!');
if (mysql_num_rows($result) < 1) {
  die('NO GAME CATS FOUND');
}
echo '<select>';
while($row = mysql_fetch_assoc($result)) {
  // the line below is a bit of shorthand...it mimics an if/then statement but is shorter
  $selected = ($row['game_cat_id'] == $current_game_cat_id) ? ' selected' : '';
  echo '<option value="' . $row['game_cat_id'] . '"' . $selected . '>' . $row['game_category'] . '</option>';
}
echo '</select>';

Vitez_Kolya

Thanks, the code worked. Sorry about not explaining things better.