Please Help

What am I doing wrong?
[php]<?php

$name = $_POST[‘name’];
$email = $_POST[‘email’];
$source = $_POST[‘source’];
$category = $_POST[‘category’];
$ingredient1 = $_POST[‘ingredient1’];
$ingredient2 = $_POST[‘ingredient2’];
$ingredient3 = $_POST[‘ingredient3’];
$ingredient4 = $_POST[‘ingredient4’];
$ingredient5 = $_POST[‘ingredient5’];
$ingredient6 = $_POST[‘ingredient6’];
$ingredient7 = $_POST[‘ingredient7’];
$ingredient8 = $_POST[‘ingredient8’];
$quantity1 = $_POST[‘quantity1’];
$quantity2 = $_POST[‘quantity2’];
$quantity3 = $_POST[‘quantity3’];
$quantity4 = $_POST[‘quantity4’];
$quantity5 = $_POST[‘quantity5’];
$quantity6 = $_POST[‘quantity6’];
$quantity7 = $_POST[‘quantity7’];
$quantity8 = $_POST[‘quantity8’];
$procedure = $_POST[‘procedure’];
include(“connect.php”);
$sql = “INSERT INTO recipes (email, name, procedure, source, ingredient1,
ingredient2, ingredient3, ingredient4, ingredient5, ingredient6, ingredient7,
ingredient8, quantity1, quantity2, quantity3, quantity4, quantit5, quantity6, quantity7,
quantity8) VALUES(’$email’, ‘$name’, ‘$procedure’, ‘$source’,
‘$ingredient1’, ‘$ingredient2’, ‘$ingredient3’, ‘$ingredient4’, ‘$ingredient5’
‘$ingredient6’, ‘$ingredient7’, ‘$ingredient8’, ‘$quantity1’, ‘$quantity2’,
‘$quantity3’, ‘$quantity4’, ‘$quantity5’, ‘$quantity6’, ‘$quantity7’, ‘$quantity8’)”;
$insert = mysql_query($sql);
if ($insert) {
echo ("slayed it ");
} else {
“mysql_error())”;
}
?>
[/php]

Thanks?

Your insert query needs to end in a semi-colon;

[php]
‘$quantity8’);";
[/php]

Also:
[php]
else {
“mysql_error())”;
}
[/php]
Should be
[php]
else {
echo mysql_error();
}[/php]

Sponsor our Newsletter | Privacy Policy | Terms of Service