if statements within a value?

I need to place an if statement as a value of a selection dropdown. I can do it fine when there is static options but when I have the options populate based on a table in mySQL I cannot figure out how to add the if statement again.

Really what i'm looking for is someone to maybe clean up the code I have below so that the if statement does what it should.

<?php
$result = mysql_query("SELECT description FROM sppkg WHERE optiontype='special'");
print "<select name=sppkgspecial> \n";
print "<option></option>";
print "<option value="if (isset($_SESSION['sppkgspecial'])) {echo "$_SESSION[sppkgspecial]";} "> if (isset($_SESSION['sppkgspecial'])) {echo "$_SESSION[sppkgspecial"];} </option>"
while($row = mysql_fetch_assoc($result))
{ print "<option value=\"{$row['description']}\">{$row['description']}</option> \n"; }
print "</select> \n";
?>

I know the highlighted line is wrong I just am not sure how to fix it?

 

print "<option value=\"if (isset($_SESSION['sppkgspecial'])) {echo "$_SESSION[sppkgspecial]";} \"> if (isset($_SESSION['sppkgspecial'])) {echo "$_SESSION[sppkgspecial"];} </option>"

 

Hi,

<?php
	$result = mysql_query("SELECT description FROM sppkg WHERE optiontype='special'");

	print "<select name=sppkgspecial> \n";
	print "<option value=";

	if(isset($_SESSION['sppkgspecial'])) 
	{
		echo $_SESSION[sppkgspecial] . ">" . $_SESSION[sppkgspecial] . "</option>";;
	}  

	while($row = mysql_fetch_assoc($result))
	{ 
		print "<option value=\"{$row['description']}\">{$row['description']}</option> \n"; 
	}

	print "</select> \n"; 
?>

PHP:

That should work, although haven't tested it as i can't access PHP at the mo.

Regards,

Steve

 

Thank you Steve136 what you have above seems to work very well but now I have another question (of course )

if it says 12' 10" Wide beam in the database then it shows 12' 10" Wide beam in the drop down but when the session variable is called it only shows 12' 10 and nothing else any thoughts?

 

Hi,

Glad it worked. The session won't save the " character unless it is escaped, which if you are inserting a " into a session it needs to be done like "\

Example code below of inserting " into a session variable.

<?php

	$_SESSION["test"] = "12' 10\"";

	echo $_SESSION["test"];
?>

PHP:

Which will output:

12' 10"

Code (markup):

Hope that helps,

Regards,

Steve

 

So if there is a " in a database entry remove it so that when pulling from the database it doesn't ignore everything after it?

12' 10" wide .. in database
12' 10" wide .. in option list
12' 10 .. in session variable

12' 10 wide .. in database
12' 10 wide .. in option list
12' 10 wide .. in session variable

Just a recap tp be sure I understand....

Thank you for your help it has saved me alot of frusterations

 

Hi,

I believe it's just in PHP that it will ignore it (unless it is escaped) I would remove the " in the database entry and add them in manually when displaying, however if you do want to use them there is a PHP function that will escape strings for you so they can be displayed properly.

http://uk3.php.net/manual/en/function.mysql-escape-string.php

Regards,

Steve