Create form with db data - problems!

[move3rd]

Hi,

I'm create a form from db data:

// Define Promotions
$promo1 = "Burn-On-Demand";
$promo2 = "Burn-On-Demand-Plus";
$promo3 = "Standard"; 

$cd_description_value .= ''.$row[cd_description].''; 


if ($row[cd_status] == Active)
 {
$option_cd_status_value1 .= '<option value="Active">Active</option>';
 $option_cd_status_value2 .= '<option value="Inactive">Inactive</option>';
  } else
 {
$option_cd_status_value1 .=  '<option value="Inactive">Inactive</option>';
$option_cd_status_value2 .= '<option value="Active">Active</option>';
 }

if ($row[cd_promotion] == $promo1) 
	  { $option_cd_promotion_value1 .= '<option value="$promo1">$promo1</option>';
        $option_cd_promotion_value2 .= '<option value="$promo2">$promo2</option>';
        $option_cd_promotion_value3 .= '<option value="$promo3">$promo3</option>';
      }
  else { if ($row[cd_promotion] == $promo2){ $option_cd_promotion_value1 .= '<option value="$promo2">$promo2</option>';
										$option_cd_promotion_value2 .= '<option value="$promo1">$promo1</option>';
                                        $option_cd_promotion_value3 .= '<option value="$promo3">$promo3</option>';
                                           }
								       else { $option_cd_promotion_value1 .= '<option value="$promo3">$promo3</option>';
											  $option_cd_promotion_value2 .= '<option value="$promo1">$promo1</option>';
										      $option_cd_promotion_value3 .= '<option value="$promo2">$promo2</option>';
										    }
    }//End -- else { if ($cd_promotion == $promo2)
}//End -- while statment   

It outputs the the correct $cd_description_value but it's outputting the promo variable names ($promo1,$promo2) rather than there values (Burn-On-Demand,Burn-On-Demand-plus)

Any help with this would be greatly apreciated.

Thanks

[laserlight]

it is a simple single quote vs double quote delimited strings mistake.

[move3rd]

Do you mean I should define my promo variables in single quotes:

// Define Promotions 
$promo1 = 'Burn-On-Demand'; 
$promo2 = 'Burn-On-Demand-Plus'; 
$promo3 = 'Standard';  

I treid that but it didnt work.

Or do you mean I should only use double quotes in the scipt. 😕

[laserlight]

I dont mean either.

Read the PHP Manual on strings

[move3rd]

PHP Manual

Unlike the two other syntaxes, variables and escape sequences for special characters will not be expanded when they occur in single quoted strings.

Thanks laserlight