SQL Query Problem

[danrah]

Why doesn't this work? Please?
[code]<?php                $serializeditems=addslashes($_SESSION['items']); //this field is serialized
$buyername=addslashes($_POST['name']);
$telephone=addslashes($_POST['telephone']);
$paymentmethod=addslashes($_POST['paymentmethod']);
$address=addslashes($_POST['address']);
$deliverytime=addslashes($_POST['deliverytime']);
$email=addslashes($_POST['email']);
                $extrainfo=addslashes($_POST['extrainfo']);

$query="INSERT INTO buyer_details". "(order,buyer_name,buyer_phone,payment_method,address,delivery_time,email,comments) VALUES" . "('$serializeditems','$buyername','$telephone','$paymentmethod','$address','$deliverytime','$email','$extrainfo')"; ?>[/code]
an SQL syntax error is produced:
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 'order,buyer_name,buyer_phone,payment_method,address,delivery_time,email,comments'

[Orio]

You have a few quotes that I dont understand. Try it this way:

[code]$query="INSERT INTO buyer_details (order,buyer_name,buyer_phone,payment_method,address,delivery_time,email,comments) VALUES ('$serializeditems','$buyername','$telephone','$paymentmethod','$address','$deliverytime','$email','$extrainfo')";[/code]

Orio.

[Zane]

buyer details?

shouldn't it buyer_details

you can't have a space in the name

[danrah]

it was buyer_details in the query.
but i have found the problem:
order is a reserved word