Hi
what you need is:
$sql = "INSERT INTO orders (product,name,email)
:    VALUES ('$product','$name','$email')";
You will also need to escape any single quotes in the variables
Tom

At 01:05 PM 24/03/01 +1200, YoBro wrote:
>I have tried that, and I have been reading all sorts of info and been
>copying it exact, but it still doesn't work. I am not receiving any errors,
>but the data just doesn't appear in the database. I have the table set up
>and it all works fine in phpMyAdmin, but I cant get my own form to work.
>
>There is a page called order.php with a form that on submit goes to the
>discussed page. All field variables are correct. Any other ideas.
>
>: You don't say where the failure is, but I'm guessing its when you do the
>: mysql_query. Your INSERT statement looks a bit odd.
>: Try:
>:
>:  $sql = "INSERT INTO orders (product,name,email)
>:    VALUES ($product,$name,$email)";
>:
>: John
>:
>:
>:
>: --
>: PHP General Mailing List (http://www.php.net/)
>: To unsubscribe, e-mail: [EMAIL PROTECTED]
>: For additional commands, e-mail: [EMAIL PROTECTED]
>: To contact the list administrators, e-mail: [EMAIL PROTECTED]
>:
>
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to