Order Form Question.

[cheater1034]

Hello, I am working on an order form for my site , bfgraphics.net.

I have a name field, an email address field, and a message field all set up and coded.

I also have a drop down box with this following code

<select name="options">
<option value="selectone" selected>Select One...
<option value="1">88x31+88x11(non-animated) $1
<option value="2">88x31+88x11(animated) $2
<option value="3">PSD Template $8
<option value="4">Bronze Service $20
<option value="5">Silver Service $25
<option value="6">Gold Service $30
<option value="7">Other (Negotiate a deal)
</select>

that information is in my services.php file

I have a seperate php file (order.php) to tell the form what to do.

I have all the other fields all setup, but I don't know how to setup the drop down box, can anyone help?

if you want the 2 complete php files or more content inside of them, I will post them as well.

[Kudose]

//assuming that the column name is option and it has an optionID
echo '<select name="option">';
echo '<option value="">Select one . . .</option>';

$sql = mysql_query("SELECT optionID, option FROM table");
while(($row = mysql_fetch_array($sql)) !== FALSE)
  echo '<option value="'.$row['optionID'].'">'.$row['option'].'</option>';

echo '</select>';

[cheater1034]

Thanks for the response, but i'm not setting it up with sql or anything, i just want what they selected from the drop down shown in the emails message.

Here's my order.php file

<?php

//variables 

$youremail = "[e-mail]";
// email

$subject = "BlueFireGraphics - Order Information";

// subject

$thankyou = "thankyou.php";

// thankyou

if($email == ""){
?>
No email address added. Please go back.<br/>
<?php
}elseif($name == ""){
?>
No name added. Please go back.<br/>
<?php
}elseif($message == ""){
?>
No message added. Please go back.<br/>
<?php
}else{

$msg = ereg_replace("\\\'", "'", $message);
$msg = ereg_replace('\\\"', "\"", $msg);
$message1 = "from: $name\nemail: $email\nmessage:\n$msg1";

mail($youremail, $subject, $msg, "From: $email\r\nReply-to: $email\r\n");
?>
<meta http-equiv="refresh" content="0; url=<?echo $thankyou;?>"">
<?php
}
?>

and here's my form code.

<form action="order.php" method="post">
<p align="center">
<b><font size="2" face="Verdana">Name: 
<input type="text" name="name" value="Your Name" size="30"/>
<br>
<br>
Email: 
<input type="text" name="email" value="[e-mail]" size="30">
<br>
<br>Service Wanted:
<select name="options">
<option value="selectone" selected>Select One...
<option value="1">88x31+88x11(non-animated) $1
<option value="2">88x31+88x11(animated) $2
<option value="3">PSD Template $8
<option value="4">Bronze Service $20
<option value="5">Silver Service $25
<option value="6">Gold Service $30
<option value="7">Other (Negotiate a deal)
</select>
<br>
<br>
Side Notes: 
<textarea name="message"  cols="30" rows="5"> </textarea>
<br>
<br>
<input type="submit" value="send"> </font></p>
</form>

Anyway, what would i place in the first file, in order to get the drop down menu functional?

[Kudose]

You need to end your options with </option> and you need to get your variabes via $_POST

i.e.

if(!$_POST){
 echo '<select name="option">';
 echo '<option value="None">Select one . . .</option>';
 echo '<option value="1">Stuff</option>';
 echo '<option value="2">More Stuff</option>';
 echo '</select>';
} else { //submitted
 $option = $_POST['option'];
 $to = '[e-mail]';
 $from = '[e-mail]';
 $subject = 'The one stuff...';
 $headers = 'FROM: '.$from;
 $message = 'You selected: '.$option;
 if(mail($to, $subject, $message, $headers))
  echo 'Message sent.';
 else
  echo 'Sending failed . . .';
}

[Kudose]

The reason why you need to get your variables via $_POST is for security. Also, some web servers have [man]register_globals[/man] turned off by default. In which case your posted variables to not get initialized by default on the page you posted to.

i.e.

//register_globals = off
//this does not work
echo 'The email you posted was :';
echo $email;

//register_globals = off
//this does work
$email = $_POST['email'];
echo 'The email you posted was: ';
echo $email;

//register_globals = on
//this does work
echo 'The email you posted was: ';
echo $email;

//register_globals = on
//this does work
$email = $_POST['email'];
echo 'The email you posted was: ';
echo $email;