Databases
StackOverflow2013
Postsdbo
POUnable to get value from Dynamic Drop Down List in PHP - Undefined index Error
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUnable to get value from Dynamic Drop Down List in PHP - Undefined index Error
    text
    copied!<p>I have created the following program in which a user can update any specific records from the list. When a user clicks on Update button a form opens which has a Name field, Image field, and a drop down list to select categories. The problem is that I am getting <em>Notice: Undefined index: category</em> error message. I tried to echo it but still its giving me the same error message. I am unable to understand why its not getting category' value from the Drop-Down List. Kindly check it and guide me.</p> <pre><code>&lt;?php include 'connect.php'; $sub_category_id= $_GET['sub_category_id']; $query= "Select * from sub_categories where sub_category_id =$sub_category_id"; $query_run= mysql_query($query); $fetch= mysql_fetch_array($query_run); $name= $fetch['sub_category_name']; $image_query= "select * from sub_categories_images where sub_category_id=$sub_category_id"; $image_query_run= mysql_query($image_query); $image_query_fetch= mysql_fetch_array($image_query_run); $image= $image_query_fetch['location']; echo " &lt;form action='update_sub_category.php?sub_category_id=$sub_category_id' method='POST' enctype='multipart/form-data'&gt; &lt;table border=1&gt; &lt;tr&gt; &lt;td&gt; Sub-Category Name: &lt;/td&gt;&lt;td&gt; &lt;input type='text' name='sub_category_name' value=$name &gt;&lt;/td&gt;&lt;/tr&gt; &lt;tr&gt; &lt;td&gt; Image1:&lt;/td&gt;&lt;td&gt; &lt;input type='file' name= 'file' value=$image&gt;&lt;/td&gt;&lt;/tr&gt; &lt;/form&gt; &lt;/table&gt; "; /*-------------- Drop Down List ---------------*/ echo "&lt;select name='category'&gt;"; $select_query= 'Select * from category'; $select_query_run = mysql_query($select_query); while ($select_query_array= mysql_fetch_array($select_query_run) ) { echo "&lt;option value='".$select_query_array['category_id']."' &gt;" .htmlspecialchars($select_query_array["name"]). "&lt;/option&gt;"; } echo "&lt;/br&gt;"; $selectTag= "&lt;/br&gt;&lt;input type='submit' value='Update Product' /&gt;&lt;/select&gt;"; echo "&lt;/div&gt;&lt;/div&gt;"; echo $selectTag; echo "&lt;/form&gt;"; /*-------------- Drop Down List ---------------*/ $category_tag= $_POST['category']; /* $query_sub_category= "update sub_categories set sub_category_name= $name, category_id= $category where sub_category_id=$sub_category_id "; */ ?&gt; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload