[SOLVED] Simple php problem

[SocomNegotiator]

Does anyone know why this does not work...

 

^{<select name="name" id="name">}

          ^{<option selected="selected">          </option>}

          ^<?

         

    ^{$sql2 = "SELECT * FROM teams ORDER BY name ASC";}

    ^{$result2 = mysql_query($sql2);}

    ^{while($data2 = mysql_fetch_array($result2))}

    ^{

      ^{$country = $data2['name'];}

  ^{echo "<option value='$country'>$country</option>";}

  ^}

    ^?>

        ^</select>

[darkfreaks]

<?php
           
     $sql2 = "SELECT * FROM teams ORDER BY name ASC";
     $result2 = mysql_query($sql2) or die(mysql_error());
     while($data2 = mysql_fetch_array($result2))
     {
      $country = $data2['name'];
   echo "<option value=$country>$country</option>";
  }
     ?>
     

[SocomNegotiator]

Hmmm...so no quotes around variable in the echo statement. I knew it was going to be something stupid

 

[darkfreaks]

Please click Topic Solved