Adding values from dropdowns into db

Hi,

My form has 6 dropdowns, 3 each for vendor selection and 3 each for category selection. If I choose a vendor/category from each of the dropdowns, all is well. But, if I choose only from the first vendor dropdown, and only from the first category dropdown, I get this error message:

Error in query: INSERT INTO recipes (titleID, vendorID, categoryID, approved, date_submitted) VALUES (17, 1, 6, 'Y', NOW()), (17, Select One, Select One, 'Y', NOW()), (17, Select One, Select One, 'Y', NOW()). You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Select One, Select One, 'Y', NOW()), (17, Select One, Select On

The 'Select One' is what seems to be causing the problem... but why and what can I do about it?

Here's the code that processes the "add_recipe" page:


<?php// put variables into something usable
$vendor1 = $_POST['vendor1'];
$vendor2 = $_POST['vendor2'];
$vendor3 = $_POST['vendor3'];
$category1 = $_POST['category1'];
$category2 = $_POST['category2'];
$category3 = $_POST['category3'];
$imagepath = $_POST['imagepath'];
$title = $_POST['title'];
$ingredients = nl2br($_POST['ingredients']);
$directions = nl2br($_POST['directions']);
$contributor = $_POST['contributor'];
// connect to the database
require ("../Connections/mysql_connect2.php");
// add the recipe to the recipe_titles table
$query = "INSERT INTO recipe_titles (imagepath, title, ingredients, directions, contributor) VALUES ('$imagepath', '$title', '$ingredients', '$directions', '$contributor')";
  
// run the query
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
$tid = mysql_insert_id(); // get the title id
// insert values into recipes table
if ($tid > 0) { // if it ran ok
// build the query
$query = 'INSERT INTO recipes (titleID, vendorID, categoryID, approved, date_submitted) VALUES ';
if ($_POST['vendor1'] OR $_POST['category1'] > 0) {
  $query .= "($tid, {$_POST['vendor1']}, {$_POST['category1']}, 'Y', NOW()), ";
  }
if ($_POST['vendor2'] OR $_POST['category2'] > 0) {
  $query .= "($tid, {$_POST['vendor2']}, {$_POST['category2']}, 'Y', NOW()), ";
  }
if ($_POST['vendor3'] OR $_POST['category3'] > 0) {
  $query .= "($tid, {$_POST['vendor3']}, {$_POST['category3']}, 'Y', NOW()), ";
  }
  $query = substr ($query, 0, -2); // Chop off last comma and space
  
// run the query
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
if ($result) {
echo '<p><strong>Thank you for your submission</strong></p>';
}
else { // if it did not run okay
echo '<p><font color = "red">Your submission could not be processed due to a system error.</font></p>';
}
}?>

And the dropdowns in the form:


<?php// connect to recipe database
require_once ("../Connections/mysql_connect2.php");
// create sql statement
// select vendor names for drop-down list
// create sql statement
// make category pull-down menus from recipe_category table
$query = "SELECT * FROM recipe_vendor ORDER BY vendor ASC";
$result = @mysql_query ($query);
$pulldown = '<option>Select One</option>';
while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {
$pulldown .= "<option value=\"{$row['vendorID']}\">{$row['vendor']}</option>\n";
}
?>
<tr>
<td align="right">Vendor 1:</td>
  <td><select name="vendor1"><?php echo $pulldown;?></select></td>
 </tr>
 <tr>
  <td align="right">Vendor 2:</td>
  <td><select name="vendor2"><?php echo $pulldown;?></select> 
  (optional)</td>
 </tr>
 <tr>
  <td align="right">Vendor 3:</td>
  <td><select name="vendor3"><?php echo $pulldown;?></select> 
  (optional)</td>
 </tr>
 <?php// create sql statement
// make category pull-down menus from recipe_category table
$query = "SELECT * FROM recipe_category ORDER BY category ASC";
$result = @mysql_query ($query);
$pulldown = '<option>Select One</option>';
while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {
$pulldown .= "<option value=\"{$row['categoryID']}\">{$row['category']}</option>\n";
}
?>
  <tr>
<td align="right">Category 1:</td>
  <td><select name="category1"><?php echo $pulldown;?></select></td>
 </tr>
 <tr>
  <td align="right">Category 2:</td>
  <td><select name="category2"><?php echo $pulldown;?></select> 
  (optional)</td>
 </tr>
 <tr>
  <td align="right">Category 3:</td>
  <td><select name="category3"><?php echo $pulldown;?></select> 
  (optional)</td>
 </tr>
 <tr>
  <td align="right">Image Path:</td>
  <td><input name="imagepath" type="text" id="imagepath" value="recipeimages/clearpixel.gif" size="50"></td>
 </tr>
 <tr>
  <td align="right">Title:</td>
  <td><input name="title" type="text" id="title" size="50"></td>
 </tr>
 <tr>
  <td align="right" valign="top">Ingredients:</td>
  <td><textarea name="ingredients" cols="50" rows="10" id="ingredients"></textarea></td>
 </tr>
 <tr>
  <td align="right" valign="top">Directions:</td>
  <td><textarea name="directions" cols="50" rows="10" id="directions"></textarea></td>
 </tr>
 <tr>
  <td align="right">Contributor:</td>
  <td><input name="contributor" type="text" id="contributor" size="50"></td>
 </tr>
 <tr>
  <td align="right">&nbsp;</td>
  <td><input type="submit" name="Submit" value="Submit">
   <input type="reset" name="Submit2" value="Reset"></td>
 </tr>
</table>
</form>

Hope someone can help. I've been working on this all day today with no luck.

Thanks,
ksp

Adding values from dropdowns into db

Won't work if one not selected from each dropdown

ksdfla

sned

ksdfla

sned

ksdfla

sned

ksdfla

sned

jatar_k

ksponline

m_shroom

m_shroom

ksponline

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week