Insert into MySql database

[Anon]

If the following problem,

I've tested and overlooked following code several times, but data will not be submitted into the database,
connection file is working correctly (also used by other query's

What could be the problem??

<?php

if (!$first_name || !$last_name || !$payment)

{ Echo " You do not entered all the requireddetails.<br>"."Please go back and try gain.";
exit;
}

$first_name = addslashes($first_name);
$last_name = addslashes($last_name);
$email = addslashes($email);
$street = addslashes($street);
$zip = addslashes($zip);
$city = addslashes($city);
$telephone = addslashes($telephone);
$payment = addslashes($payment);
$remarks = addslashes($remarks);

include('../../../php-scripts/connect.inc');
mysql_select_db("order",$db);
$query = "INSERT INTO order (first_name,last_name,email,street,zip,city,telephone,payment,remarks) VALUES('".$first_name."', '".$last_name."', '".$email."','".$street."','".$zip."','".$city."','".$telephone."','".$payment."','".$remarks."')";
$result = mysql_query($query);
if ($result)
ECHO mysql_affected_rows(). "order inserted into database";

	?>		

[Anon]

i don't know why you people used to make a "SIMPLE QUERY" is complicated one

$query = "INSERT INTO order (first_name,last_name,email,street,zip,city,telephone,payment,remarks) VALUES('$first_name', '$last_name', '$email','$street','$zip','$city','$telephone','$payment','$remarks')";

use it and it wil work..

Cheers
Tabish

[[deleted]]

"What could be the problem?"

The query most likely. Use errorchecking:

if (!$mysql_query($query))
{
echo mysql_error().'<BR>'.$query;
}
else
{
echo 'query ok';
}

[Anon]

What are the datatypes of the columns? The "payment" looks suspicious, is that really a character type that should be quoted?