[RESOLVED] Cannot get data from select drop-list

[seamres]

This is my form.

<form action="success_neworder.php" method="post">
					<table id="contable">
						<tr><th colspan="2">Add Order</th></tr>
						<tr><td>Product and Quantity</td><td>
								<input type="radio" value="Slimfit Shirt" name="prod"/>Slimfit Shirt<select style="float:right" name="qty"><option value="0">Select quantity</option><option value="30">30</option><option value="50">50</option><option value="75">75</option><option value="100">100</option><option value="200+">200+</option></select><br/>
								<input type="radio" value="T-Shirt" name="prod"/>T-shirt <select style="float:right" name="qty"><option value="0">Select quantity</option><option value="30">30</option><option value="50">50</option><option value="75">75</option><option value="100">100</option><option value="200+">200+</option></select><br/>
								<input type="radio" value="Polo Shirt" name="prod"/>Polo Shirt <select style="float:right" name="qty"><option value="0">Select quantity</option><option value="30">30</option><option value="50">50</option><option value="75">75</option><option value="100">100</option><option value="200+">200+</option></select><br/>
								<input type="radio" value="Baller" name="prod"/>Baller <select style="float:right" name="qty"><option value="0">Select quantity</option><option value="500">500</option><option value="1000">1000</option></select><br/>
								<input type="radio" value="Lanyard" name="prod"/>Lanyard <select style="float:right" name="qty"><option value="0">Select quantity</option><option value="100">100</option></select><br/>							
							</td></tr>	
						<tr><td>Describe your order</td><td><input type="text" name="descr"/></td></tr>
						<tr><td>Upload a Design <small><small>(Optional)</small></small></td><td><input type="file" name="image" accept="image/jpeg"/></td></tr>
						<tr><td><input type="submit" name="add" value="submit"/></td></tr>
					</table>
					</form>

Code snippet for success_addorder.php

	if(isset($_POST['add']))
	{	
		//get data from the form
		$descr=$_POST['descr'];
		$prod=$_POST['prod'];
		$qty=$_POST['qty'];

	if(!isset($prod) || $qty=='0')
	{
		echo "<div id=\"panel\"><table id=\"contable\"><tr><th colspan=\"2\">Please choose a product and select quantity</th></tr>";
		echo "<tr><td><a href=\"cust_addorder.php\">Back to Add Order</a></td></tr>";			
		echo "</table></div>";
	}

	else
	{			
		//determine cost
		if($prod=='Slimfit Shirt')
		{
			if($qty=='30')
				$total_amount=6900;
			elseif($qty=='50')
				$total_amount=11000;
			elseif($qty=='75')
				$total_amount=15375;
			elseif($qty=='100')
				$total_amount=1500;
			elseif($qty=='200+')
				$total_amount=35000;
		}

		elseif($prod=='Polo Shirt')
		{
			if($qty=='30')
				$total_amount=8250;
			elseif($qty=='50')
				$total_amount=13250;
			elseif($qty=='75')
				$total_amount=18750;
			elseif($qty=='100')
				$total_amount=24500;
			elseif($qty=='200+')
				$total_amount=48000;
		}			
		elseif($prod=='T-Shirt')
		{
			if($qty=='30')
				$total_amount=5850;
			elseif($qty=='50')
				$total_amount=9250;
			elseif($qty=='75')
				$total_amount=12750;
			elseif($qty=='100')
				$total_amount=16000;
			elseif($qty=='200+')
				$total_amount=28000;
		}			
		elseif($prod=='Baller')
		{
			if($qty=='500')
				$total_amount=12500;
			elseif($qty=='1000')
				$total_amount=20000;
		}			
		elseif($prod=='Lanyard') 				/* <<- this seems to be the only product that gets input right */
		{
			if($qty=='100')
				$total_amount=6500;
		}

		//add order to database
		$query=mysql_query("INSERT INTO order_t(order_desc, prod, prod_qty, total_amount, order_date, cust_id) values('$descr', '$prod', '$qty', $total_amount, CURDATE(), $id)");
		echo "<div id=\"panel\"><table id=\"contable\"><tr><th colspan=\"2\">New order has been added.</th></tr>";
		echo "<tr><td><a href=\"cust_manageorders.php\">Back to Manage Orders</a></td></tr>";			
		echo "</table></div>";
	}
}		

Even if I did select a product (input type radio) and choose quantity from a select box, I still get the 'Please choose a product and select quantity' message. Apparently the only product that gets input right is Lanyard, since it doesn't have any elseif statement. Help?

[bradgrafelman]

The problem is that you've got multiple <select> elements that all share the same name. Thus, they're going to be essentially overwriting each other's values until you get to the last one. In other words, it would probably work if you chose the last product since that is the only 'qty' <select> element that matters.

Here are two possible solutions:

1. Give each <select> dropdown a unique name and update your PHP code to check for the appropriate $_POST element depending upon which product was selected.

2. Get rid of the multiple boxes and use only a single <select> element. Use Javascript to dynamically alter the group of options for that <select> element depending upon which product was selected.

[seamres]

I don't even know Javascript 🙁 I'm a newbie among newbies. I implemented your first solution and my codes just got more tedious and longer. But now it works perfectly fine. Thank you once again.