Forum Moderators: coopster

Message Too Old, No Replies

query error what is wrong with this?

         

Sarah Atkinson

7:37 pm on Jun 13, 2007 (gmt 0)

10+ Year Member



$cussql="INSERT INTO Customers (first_name, last_name, e_mail, street, city, state, zip, phone, e_mail, vin, make, model, year, miles, o_date, plan, term, deductible, price) VALUES ($first_name, $last_name, $e_mail, $street, $city, $state, $zip, $phone, $e_mail, $vin, $make, $model, $year, $miles, $o_date, $plan, $term, $deductible, $price) ";

eelixduppy

7:50 pm on Jun 13, 2007 (gmt 0)



What error are you getting? Also, try something like this:

$cussql="INSERT INTO Customers (first_name, last_name, e_mail, street, city, state, zip, phone, e_mail, vin, make, model, year, miles, o_date, plan, term, deductible, price) VALUES ('$first_name', '$last_name', '$e_mail, $street', '$city', '$state', '$zip', '$phone', '$e_mail', '$vin', '$make', '$model', '$year', '$miles', '$o_date', '$plan', '$term', '$deductible', '$price')";

Notice how I added the quotes.

Sarah Atkinson

8:31 pm on Jun 13, 2007 (gmt 0)

10+ Year Member



ty