Select Statment from Database

[seran128]

I have a select statement that works but I need to add a default value from a database

my value is

[code=php:0]<? echo $row['CategoeyID']; ?>[/code]

My WORKING Select Statement

[code=php:0]<?
  echo '<SELECT name="category" >';
  echo "<OPTION>Select a category</OPTION>\n";
  foreach ($category as $c)
  echo "<OPTION value={$c['CategoryID']}>{$c['category_description']} </OPTION>\n";
  echo '</SELECT>';
?>[/code]

My Broken Statement

[code=php:0]<?
  echo '<SELECT name="category" >';
  echo "<OPTION>Select a category</OPTION>\n";
  foreach ($category as $c)
  echo "<OPTION value={$c['CategoryID']} if($row['CategoeyID'] == $c['CategoryID']){selected='selected'}else{}(>{$c['category_description']} </OPTION>\n";
  echo '</SELECT>';
?>[/code]

[Psycho]

You're trying to put code within the echo string. Instead of trying to get everything on one line, break it out and you should have no problem:

[code]<?php 
  echo '<SELECT name="category" >';
  echo "<OPTION>Select a category</OPTION>\n";
  foreach ($category as $c)
    echo "<OPTION value={$c['CategoryID']}"
    if ($row['CategoeyID'] == $c['CategoryID']) { echo " selected"; }
    echo ">{$c['category_description']} </OPTION>\n";
  }
  echo '</SELECT>';
?>[/code]