[Caine78]

I am following Lynda PHP training, and I have recieved an error in SQL syntax. Can somebody please can help me? I am new with it, so I am sorry if it is stupid question.

I have try this code on two different systems:
Windows XP, PHP 5.2.8, MySQL 5.1.30 - xampp
Windows Vista, PHP 5.2.1, MySQL 5.1.35 - Zend Server CE

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 ' )' at line 4

<?php require_once("includes/connection.php"); ?>
<?php require_once("includes/functions.php"); ?>
<?php
$menu_name = $_POST['menu_name'];
$position = $_POST['position'];
$visible = $_POST['visible'];
?>
<?php
$query = "INSERT INTO menu (
menu_name, position, visible
) VALUES (
'{$menu_name}', {$position}, {$visible}
)";
$result = mysql_query($query, $connection);
if ($result) {
// Success!
header("Location: content.php");
exit;
} else {
// Display error message.
echo "<p>Menu creation failed.</p>";
echo "<p>" . mysql_error() . "</p>";
}
?>
<?php mysql_close($connection); ?>

HOWEVER when I have change:
'{$menu_name}', {$position}, {$visible}
into
'$menu_name', '$position', '$visible'

It start working, but is not passing any information about position and visible on XP
Warning: Cannot modify header information - headers already sent by (output started at D:\xampp\htdocs\fixedgearleeds\includes\functions. php:98) in D:\xampp\htdocs\fixedgearleeds\create_subject.php on line 19
Plus I am recieving an error's on Vista where is still not working
Incorrect integer value: '' for column 'position' at row 1.

Thanks for any help!

[misterchucker]

Start by removing any whitespace characters from the beginning and end of the functions.php file. There should be nothing before "<?php" and nothing after "?>".

[abbieonline]

Just have 1 set of <?php's

PHP Code:

<?php
all your code in here
?>

Try this:

PHP Code:

$query = "INSERT INTO menu (menu_name, position, visible) VALUES (
'{$menu_name}', '{$position}', '{$visible}')"; 


You need to keep the same formatting around the variables

'var1','var2','var3'

or

var1,var2,var3

(with or without quotes)