PHP - Drop Down Menu And Database Values

Hello all 

Ok here is the problem...
I want when a user inputs the requested data to the text fields , the script to insert those data in the prope table depending on the choise the user does by choosing one option from the drop down menu.
Below is the php code (apparently not working)


$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
$site_type = $_REQUEST['category_selection'];
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "link_submission") && ($site_type = "Web_Sites")) {
  $insertSQL = sprintf("INSERT INTO partner_sites (url, url_title, anchor_text, `description`, webmaster_name, webmaster_email, category) VALUES (%s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['url_field'], "text"),
                       GetSQLValueString($_POST['title_field'], "text"),
                       GetSQLValueString($_POST['anchor_field'], "text"),
                       GetSQLValueString($_POST['description_field'], "text"),
                       GetSQLValueString($_POST['webmaster_nane_field'], "text"),
                       GetSQLValueString($_POST['webmaster_email_field'], "text"),
                       GetSQLValueString($_POST['category_selection'], "text"));

  mysql_select_db($database_content_conn, $content_conn);
  $Result1 = mysql_query($insertSQL, $content_conn) or die(mysql_error()); 

}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "link_submission") && ($site_type = "Blogs")) {
  $insertSQL = sprintf("INSERT INTO partner_blogs (url, url_title, anchor_text, `description`, webmaster_name, webmaster_email, category) VALUES (%s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['url_field'], "text"),
                       GetSQLValueString($_POST['title_field'], "text"),
                       GetSQLValueString($_POST['anchor_field'], "text"),
                       GetSQLValueString($_POST['description_field'], "text"),
                       GetSQLValueString($_POST['webmaster_nane_field'], "text"),
                       GetSQLValueString($_POST['webmaster_email_field'], "text"),
                       GetSQLValueString($_POST['category_selection'], "text"));

  mysql_select_db($database_content_conn, $content_conn);
  $Result1 = mysql_query($insertSQL, $content_conn) or die(mysql_error());

}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "link_submission") && ($site_type = "Directories")) {
  $insertSQL = sprintf("INSERT INTO partner_directories (url, url_title, anchor_text, `description`, webmaster_name, webmaster_email, category) VALUES (%s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['url_field'], "text"),
                       GetSQLValueString($_POST['title_field'], "text"),
                       GetSQLValueString($_POST['anchor_field'], "text"),
                       GetSQLValueString($_POST['description_field'], "text"),
                       GetSQLValueString($_POST['webmaster_nane_field'], "text"),
                       GetSQLValueString($_POST['webmaster_email_field'], "text"),
                       GetSQLValueString($_POST['category_selection'], "text"));

  mysql_select_db($database_content_conn, $content_conn);
  $Result1 = mysql_query($insertSQL, $content_conn) or die(mysql_error());
}

And the html form

<form action="<?php echo $editFormAction; ?>" method="POST" enctype="multipart/form-data" name="link_submission" id="link_submission">

<table width="630" border="0" align="center" cellpadding="5" cellspacing="5">
  <tr>
    <td width="76">URL:*</td>
    <td width="519"><label for="url_field"></label>
      <span id="sprytextfield1">
      <label for="url_field"></label>
      <input name="url_field" type="text" id="url_field" size="50" />
      <span class="textfieldRequiredMsg">A value is required.</span><span class="textfieldInvalidFormatMsg">Invalid format.</span></span></td>
    </tr>
  <tr>
    <td>Anchor Text:*</td>
    <td><label for="anchor_field"><span id="sprytextfield2">
      <input type="text" name="anchor_field" id="anchor_field" />
      <span class="textfieldRequiredMsg">A value is required.</span></span></label></td>
    </tr>
  <tr>
    <td>URL Title:*</td>
    <td><label for="title_field"><span id="sprytextfield3">
      <input type="text" name="title_field" id="title_field" />
      <span class="textfieldRequiredMsg">A value is required.</span></span></label></td>
    </tr>
  <tr>
    <td>Description:*</td>
    <td><span id="sprytextarea1">
    <label for="description_field"></label>
    <textarea name="description_field" id="description_field" cols="45" rows="3"></textarea>
    <span id="countsprytextarea1">&nbsp;</span><span class="textareaRequiredMsg">A value is required.</span><span class="textareaMaxCharsMsg">Exceeded maximum number of characters.</span></span></td>
    </tr>
  <tr>
    <td>Webmaster Name:*</td>
    <td><label for="textfield2"><span id="sprytextfield4">
      <input type="text" name="webmaster_nane_field" id="webmaster_nane_field" />
      <span class="textfieldRequiredMsg">A value is required.</span></span></label></td>
    </tr>
  <tr>
    <td>Webmaster E-mail:*</td>
    <td><label for="textfield3"><span id="sprytextfield5">
    <input name="webmaster_email_field" type="text" id="webmaster_email_field" size="40" />
    <span class="textfieldRequiredMsg">A value is required.</span><span class="textfieldInvalidFormatMsg">Invalid format.</span></span></label></td>
    </tr>
  <tr>
    <td>Category:*</td>
    <td><span id="spryselect1">
      <label for="category_selection"></label>
      <select name="category_selection" id="category_selection">
        <option>Select An Option</option>
        <option value="Web_Sites">Web Sites</option>
        <option value="Blogs">Blogs</option>
        <option value="Directories">Directories</option>
      </select>
<span class="selectRequiredMsg">Please select an item.</span></span></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td><label for="select"></label>
      <input type="submit" name="button" id="button" value="Url Submission" /></td>
    </tr>
</table>
<input type="hidden" name="MM_insert" value="link_submission" />
</form>

Im begging for your help.....

Hi guys, I had a problem before which is similar to the problem im about to describe, however Pikachu helped me solve the last problem so a big thanks to him! However this problem is slightly different and im struggling to find a solution. I will first describe the problem I had which pikachu helped me solve as it would be easier for me to describe this past problem.

I have an update form, so a user can edit existing records which are pulled from a database. When the user changes the values in a text field then submits the form, the values in the text fields updates fine. However if they change the values in the text box and then tries to submit the form but there was an error, the values in the text fields go back to the values from the database and the user has to change the text fields again.

Well this problem was solved with the help of pikachu and the this is what I did...

<?php if(isset($_POST['title'])){echo htmlspecialchars($_POST['title']);} else if (isset($title)) {echo htmlspecialchars($title);}?>

Again, the above works fine however the problem I have now is the same problem as described above however it relates to drop down menus and not text fields. I can't seem to figure out how to retain the values in a drop down menu the same way I have for text fields. Below is the code that im using that I thought would work however it isnt working, the values of the drop down menu (if there was an error) are going back to the values from the database. Heres the code...

<option value="Psychopathic" <?php if ((isset($_POST['category']))&&($_POST['category'] == 'Psychopathic')) { echo ' selected=selected'; }  else if ((isset($category))&&($category == 'Psychopathic')) { echo ' selected=selected'; } ?>>Psychopathic</option>

Does anybody know what i am doing wrong and how i can fix this problem? I understand what i need to do but i cant seem to get the code to do what i want to do and thats to retain values of a drop down menu when the page is returned with an error.

Any help would be much appreciated.

AJay

GREAT this forum - JUST GREAT !...

Issue: All data entered into my online form was lost (blanked out) and the form returned correctly with message "wrong verification code", when submitted with the wrong verification code.  However, going through this great forum I managed to get all - manually entered - data back ! I placed 
value="<?php echo $_GET['the_field_name'];?>"/  after each input field.

BUT... not so with input fields entered from drop-down menu !
How do I put a similar string for the field "Payment by" in this sample:

<tr>
<td class="table-inquire" width="47%">
<font face="Verdana" size="1" color="#000042">
Payment by:</font></td>
<td class="table-inquire" width="51%" colspan="2">
<font color="#400000" face="Verdana">
<select name="payment" size="1">
<option value="VISA">VISA</option>
<option value="MASTER">MASTER</option>
<option value="CASH">CASH</option>
<option value="T/T Banktransfer">T/T Banktransfer</option>
<option selected>Please select</option>
</select></font><font size="2" color="#400000" face="Verdana"></font></td>
</tr>

Any advise greatly appreciated. Thanks.

Hi all,
i want my list/menu field values to come from my database. how can i accomplish that?
thanks

i did
Code: [Select]
<select name="select">
                  <option value="0">--select below--</option>
  <option value="1">Me</option>
  <?php
  
                  require_once '../konnect/konex.php';

$result = mysql_query("SELECT * FROM is_clients");

while($row = mysql_fetch_array($result))
  {
  echo "<option value ='2'>".$row"['name']</option>";
  echo "<br />";
  }

?>
                  </select>

I'm trying to make it so that someone can add an item to the shop based upon the current items within the database.

How do I go about doing that? I know i have to change <input> to <select>, but beyond that, how do I code it so I can run an array to get all the current items from the table `items` and list them by their `name` field?

Thanks in advance!

Here is what I have so far:


function addshopinv($id) {
error_reporting(E_ALL);
ini_set('display_errors', 1);
   if (isset($_POST["submit"])) {
        extract($_POST);
        $errors = 0;
        $errorlist = "";
        if ($name == "") { $errors++; $errorlist .= "Name is required.<br />"; }
else if ($errors == 0) { 
$dbh=dbconnect() or die ("Userlist read error: " . mysql_error()."<br>");
mysql_select_db("XXX");
$query = mysql_query("SELECT id FROM items WHERE name='$name'");
while ($result = mysql_fetch_array($query)){
$item_id = $result['id'];
$query1 = mysql_query("INSERT INTO sale SET shop_id='$id', item_id='$item_id'");
}
            admindisplay("Inventory Item Added.","Add New Inventory Item");
        } else {
            admindisplay("<b>Errors:</b><br /><div style=\"color:red;\">$errorlist</div><br />Please go back and try again.", "Add New Item to Shop");
        }        
   }

   $page = <<<END
<b><u>Add New Inventory Item</u></b><br /><br />
<form action="admin_panel.php?do=addshopinv:$id" method="post">
<table width="90%">
<tr><td width="20%">Name:</td><td><input type="text" name="name" size="30" maxlength="255" value="" />*255 character max</td></tr>
</table>
<input type="submit" name="submit" value="Submit" /> <input type="reset" name="reset" value="Reset" />
</form>
END;
    $page = parsetemplate($page, $row);
    admindisplay($page, "Add New Inventory Item");
}