MySql errors!

mrxxlphp

Any ideas why this code doesnt work?

<?php

{ $conn = @mysql_connect("localhost", "username", "password")
or die("Could not connect to database"); 
$db = @mysql_select_db("hydroart_enquirys", $conn) 
or die("Could not connect to database"); 
$sql = "insert into emails 
(to, date, ebay_no, message) values (\"$to\", \"$date\", \"$ebay_no\", \"$message\")"; 
$results = @mysql_query($sql, $conn) 
or die (mysql_error()); }
?>

I get this error

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 'to, date, ebay_no, message) values ("fvd", "", "f;", "")' at li

Thanks

Stuart

LordShryku

To is a reserved word.

mrxxlphp

Any ideas why this wont work?

{ $conn = @mysql_connect("localhost", "username", "password")
or die("Could not connect to database"); 
$db = @mysql_select_db("hydroart_enquirys", $conn); 
$sql5 = "insert into archive
(id_number, ebay_no, ebay_id, purchase_date, email, name, house_n_n, address_1, address_2, town_city, postcode, enquiry, id_number, track) values 
(\"$id_number\", \"$ebay_no\", \"$ebay_id\", \"$purchase_date\", \"$email\", \"$name\", \"$house_n_n\", \"$address1\", \"$address2\", \"$town_city\", \"$postcode\", \"$enquiry\", \"$id_number\", \"$track\")"; 
$results5 = @mysql_query($sql15, $conn)
or die("Could not connect to database"); }

LordShryku

What error are you getting? It might be because you do id_number twice...

mrxxlphp

Basicaly what i want is a script that will take a row from enuqirys and copy it to archive then delete the copy in enquirys

Anyone got any ideas?

Stuart