Forum Moderators: coopster
$sql="INSERT INTO $fromwhere SET day='$date', maincourse='$maincourse', veggie='$veggie', veggie2='$veggietwo', fruit='$fruit', dessert='$dessert', drink='$drink', bread='$bread'";
$sql="INSERT INTO $fromwhere SET day='$date', maincourse='$maincourse', veggie='$veggie', veggie2='$veggietwo', fruit='$fruit', dessert='$dessert', drink='$drink', bread='$bread' WHERE id = 1";
WHERE id = 1 is just an example you can use any column and any value.
$sql="INSERT INTO $fromwhere (day, maincourse )
VALUES ('$date', '$veggie')";
(I'm assuming you're using MySQL here -- is that correct?)
then after that didn't work(I first though it worked cause I didn't get an error message)
I have now re written it another way. I don't know what kind of where statement I would add cause this is a new entry
now the code is like :
if (isset($_POST['change'])):
$fromwhere=$_POST['fromwhere'];
$date=$_POST['date'];
$maincourse=$_POST['maincourse'];
$veggie=$_POST['veggie'];
$veggietwo=$_POST['veggie2'];
$fruit=$_POST['fruit'];
$dessert=$_POST['dessert'];
$drink=$_POST['drink'];
$bread=$_POST['bread'];
$sql = "INSERT INTO '$fromwhere'
(day, maincourse, veggie, veggie2, fruit, dessert, drink, bread)
VALUES ('$date','$maincourse','$veggie','$veggietwo','$fruit','$dessert','$drink','$bread')";
if (@mysql_query($sql)) {
echo '<p>Menu added</p>';
} else {
echo '<p>Error adding menu: ' .
mysql_error() . '</p>';
}
$sql = "INSERT INTO $fromwhere VALUES ('$date','$maincourse','$veggie','$veggietwo','$fruit','$dessert','$drink','$bread')";
$result=mysql_query($sql);
As long as your values are in the same order as your
table is setup you dont need the other part of the query that you had with the parentheses. Try the above.
Error adding menu: 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 'VALUES ('2005-05-10','Rost Pork','','','','','','')' at line 1
$sql = "INSERT INTO $fromwhere VALUES ('','$date','$maincourse','$veggie','$veggietwo','$fruit','$dessert','$drink','$bread')";
$result=mysql_query($sql);
here is the whole code. I'm wandering if it is just a missing quote or ; somewhere?
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Meals for Better Living Menu Admin</title>
</head><body>
<?php //connects to the server and database
include_once 'db.inc.php';
if (isset($_POST['change'])):
$fromwhere=$_POST['fromwhere'];
$date=DATE($_POST['date']);
$maincourse=$_POST['maincourse'];
$veggie=$_POST['veggie'];
$veggietwo=$_POST['veggie2'];
$fruit=$_POST['fruit'];
$dessert=$_POST['dessert'];
$drink=$_POST['drink'];
$bread=$_POST['bread'];
$sql = "INSERT INTO $fromwhere VALUES ('','$date','$maincourse','$veggie','$veggietwo','$fruit','$dessert','$drink','$bread')";
$result=mysql_query($sql);
if ($result) {
echo '<p>Menu added</p>';
} else {
echo '<p>Error adding menu: ' .
mysql_error() . '</p>';
}
?>
<p><a href="<?php echo $_SERVER['PHP_SELF'];?>?fromwhere=meals_menus_bbjj"> Add another menu for Bartholomew, Brown, Jackson, and Jennings Counties. </a></p><br />
<p><a href="<?php echo $_SERVER['PHP_SELF'];?>?fromwhere=meals_menus_d"> Add another menu for Decatur County. </a></p>
<?php elseif (isset($_GET['fromwhere'])):
$fromwhere=$_GET['fromwhere'];
if($fromwhere==meal_menus_bbjj)
echo '<p> Enter menu for Bartholomew, Brown, Jackson, and Jennings Counties.</p>';
elseif($fromwhere==meal_menus_d)
echo '<p> Enter menu for Decatur County.</p>';
else
echo '<p>menu error.</p>';?>
<form action="addmenu.php" method="post">
<label>Date (y-m-d): <input type="text" name="date" /></label><br />
<label> Main Course: <input type="text" name="maincourse" /></label><br />
<label> Vegetable #1: <input type="text" name="veggie" /></label><br />
<label> Vegetable #2: <input type="text" name="veggie2" /></label><br />
<label> Fruit: <input type="text" name="fruit" /></label><br />
<label> Bread: <input type="text" name="bread" /></label><br />
<label> Dessert: <input type="text" name="dessert" /></label><br />
<label> Drink: <input type="text" name="drink" /></label><br />
<input type="hidden" name="fromwhere" value="<?php $fromwhere?>" />
<input type="hidden" name="change" value="1" />
<input type ="submit" value="SUBMIT"/>
</form>
<?php else: //if no area has been selected?>
Select area menu you would like to update:
<p><a href="addmenu.php?fromwhere=meal_menus_bbjj">Add a menu for Bartholomew, Brown, Jackson, and Jennings Counties. </a></p>
<p><a href="addmenu.php?fromwhere=meal_menus_d">Add a menu for Decatur County.</a></p>
<?phpendif;?>
</body>
</html>
<input type="hidden" name="fromwhere" value="<?php $fromwhere?>" />
had to be
<input type="hidden" name="fromwhere" value="<?php echo "$fromwhere";?>" />
Duhh
