Inserting data into table

[seany02]

Im trying to insert data into a table. I get a parse error in the browser when i try to run the script. The parse error doesnt tell me whats expected or unexpected. Any ideas? thanks

 

<?php
if (isset($_REQUEST['Submit'])) {
# THIS CODE TELL MYSQL TO INSERT THE DATA FROM THE FORM INTO YOUR MYSQL TABLE
$sql = "INSERT INTO $db_table(contact_id,contact_name,contact_address,telephone_no,email) values ('".mysql_real_escape_string(stripslashes($_REQUEST['contact_id']))."','"mysql_real_escape_string(stripslashes($_REQUEST['contact_name']))."','"mysql_real_escape_string(stripslashes($_REQUEST['contact_address']))."','"mysql_real_escape_string(stripslashes($_REQUEST['telephone_no']))."','".mysql_real_escape_string(stripslashes($_REQUEST['email']))."')";
if($result = mysql_query($sql ,$db)) {
echo '<h1>Thank you</h1>Your information has been entered into our database<br><br><img src="http://www.webune.com/images/headers/default_logo.jpg"';
} else {
echo "ERROR: ".mysql_error();
}
} else {
?>

[jackpf]

Well what's the error then?

[seany02]

I don't know what the error is. Thats the problemo

[jackpf]

I get a parse error in the browser when i try to run the script.

What is that error?

[seany02]

Parse error: parse error in C:\xampp\htdocs\contacts.php on line 61

 

line 61 is the fourth line of the code i posted

[radi8]

Here it is:

 

original SQL:

<?php
$sql = "INSERT INTO $db_table(contact_id,contact_name,contact_address,telephone_no,email)values ('".mysql_real_escape_string(stripslashes($_REQUEST['contact_id']))."','"mysql_real_escape_string(stripslashes($_REQUEST['contact_name']))."','"mysql_real_escape_string(stripslashes($_REQUEST['contact_address']))."','"mysql_real_escape_string(stripslashes($_REQUEST['telephone_no']))."','".mysql_real_escape_string(stripslashes($_REQUEST['email']))."')";
?>

corrected SQL:

<?php
$sql = "INSERT INTO $db_table(contact_id,contact_name,contact_address,telephone_no,email)values ('".mysql_real_escape_string(stripslashes($_REQUEST['contact_id']))."','".mysql_real_escape_string(stripslashes($_REQUEST['contact_name']))."','".mysql_real_escape_string(stripslashes($_REQUEST['contact_address']))."','".mysql_real_escape_string(stripslashes($_REQUEST['telephone_no']))."','".mysql_real_escape_string(stripslashes($_REQUEST['email']))."')";
?>

you forgot to add several "."  before the mysql_real_escape_string(...) statements

[jackpf]

You should put your posted data into variables.

Makes it much easier to spot errors like this.

& nice catch radi8.