Jump to content

Inserting values from a dynamic drop down list into Database


Recommended Posts



I am trying to insert values in my database from a dynamic drop down list. I have created the following program, its not given me any error message, but also its not inserting any record in database. Kindly check it and tell me where is the problem.

I have also echo the fields which i am inserting in database, and all the fields are entering correctly in variables.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>




	include 'connect.php';
			$select_query= 			'Select * from category';
			$select_query_run =		mysql_query($select_query);
	echo "	
		<form action='insert_product.php' method='POST' ></br>
		Product Name: 	<input type='text' name='product_name'  /></br>
		Price		:	<input type= 'text' name= 'price'  /></br>
		Description	:	<input type='text' name='description'  />*Seperate by Comma</br>
	//  Drop Down Display	

			echo "<select name='category'>";
			while	($select_query_array=	mysql_fetch_array($select_query_run) )
					echo "<option value='".$select_query_array['category_id']."' >".
		 $selectTag= "<input type='submit' value='Insert'  /></select></form>";
		 echo $selectTag;
	//Drop Down End!
	if(isset($_POST['product_name']) && isset($_POST['price']) && isset($_POST['description']) 	)
		echo $product_name	= 		$_POST['product_name'];
		echo $price			=		$_POST['price'];
		echo $description	=		$_POST['description'];
		echo $category		=		$_POST['category'];
//Problem Area 

	$query= "insert into products (name, price, description,  category_id ) 
				VALUES( '$product_name', $price, '$description', $category )";

	if($query_run=		mysql_query($query))
		echo 'Data Inserted';
			'Error In SQL'.mysql_error();
		echo 'empty Field';


	echo 'You Must Log in To View this Page!';

Link to comment
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.