if/else statement question

[micmac]

Hi all,
As you can see from my code snippet below i am trying to SELECT the values for 'listing_postion', either 1, 2 or 3.
What i am wanting to do with the results is that if, for example, the values 1 and 2 are already in the DB then i want to show a radio button allowing the user to choose Postion 3.
I have started the process below, realising that i could do a whole lot of if/else statements but what i want to know is if there is an easier, more simplified way to go about this?

Cheers,
micmac

<?

		 $result1 = mysql_query("SELECT * FROM cat1,pref WHERE cat1.CatID = pref.CatID AND pref.listing_position IN('1', '2', '3')");
         while($row1 = mysql_fetch_array($result1)){
		 $available = $row1['listing_position'];
         ?>
		<?php 
		if($available == '1' || $available == '2'){
		echo "Position 2 <input type=\"radio\" name=\"listing_position\" value=\"2\"> Position 3 <input type=\"radio\" name=\"listing_position\" value=\"3\">"; 
		} 
		?>
		<?
		}
		?>

[herve]

Hi,

you need to recode things a bit :

--- 8< ------------------------------------

<?PHP

$result1 = mysql_query("SELECT * FROM cat1,pref WHERE cat1.CatID = pref.CatID AND pref.listing_position IN('1', '2', '3')");

$found_1 = 0;
$found_2 = 0;
$found_3 = 0;

while ($row1 = mysql_fetch_array($result1))
{
$value = $row1['listing_position'];

if ($value == 1) $found_1 = 1;
if ($value == 2) $found_2 = 1;
if ($value == 3) $found_3 = 1;

}

if ( $found_1 == 0)
{
echo "Position 1 <input type=\"radio\" name=\"listing_position\" value=\"1\">";
}

if ( $found_2 == 0)
{
echo "Position 2 <input type=\"radio\" name=\"listing_position\" value=\"2\">";
}
if ( $found_3 == 0)
{
echo "Position 3 <input type=\"radio\" name=\"listing_position\" value=\"3\">";
}

?>

--- 8< ------------------------------------

Hervé.