[SOLVED] Query Seems right to me??

[jwwceo]

I have been staring at this query for an hour. It gives me a SYNTAX error. Any ideas??

 

James

 $query="INSERT INTO user (
    name_last,
    name_first,
    email,
    password,
    username,
    address_home,
    city_home,
    state_home,
    zip_home,
    country_home,
    phone_home,
    address_bill,
    city_bill,
    state_bill,
    zip_bill,
    country_bill,
    phone_bill,
    citizenship)

    VALUES (
    {$_SESSION['name_last_v']},
    {$_SESSION['name_first_v']},
    {$_SESSION['email_v']},
    {$_SESSION['password_v']},
    {$_SESSION['username_v']},
    {$_SESSION['address_home_v']},
    {$_SESSION['city_home_v']},
    {$_SESSION['state_home_v']},
    {$_SESSION['zip_home_v']},
    {$_SESSION['country_home_v']},
    {$_SESSION['phone_home_v']},
    {$_SESSION['address_bill_v']},
    {$_SESSION['city_bill_v']},
    {$_SESSION['$state_bill_v']},
    {$_SESSION['$zip_bill_v']},
    {$_SESSION['$country_bill_v']},
    {$_SESSION['$phone_bill_v']},
    {$_SESSION['$citizenship_v']})";

[boushley]

Whats the exact error?

 

What values are being passed in?

 

Whats the table structure look like?

[papaface]

Should be:

 $query="INSERT INTO user (
    name_last,
    name_first,
    email,
    password,
    username,
    address_home,
    city_home,
    state_home,
    zip_home,
    country_home,
    phone_home,
    address_bill,
    city_bill,
    state_bill,
    zip_bill,
    country_bill,
    phone_bill,
    citizenship)

    VALUES (
    ".$_SESSION['name_last_v'].",
    ".$_SESSION['name_first_v'].",
    ".$_SESSION['email_v'].",
    ".$_SESSION['password_v'].",
    ".$_SESSION['username_v'].",
    ".$_SESSION['address_home_v'].",
    ".$_SESSION['city_home_v'].",
    ".$_SESSION['state_home_v'].",
    ".$_SESSION['zip_home_v'].",
    ".$_SESSION['country_home_v'].",
    ".$_SESSION['phone_home_v'].",
    ".$_SESSION['address_bill_v'].",
    ".$_SESSION['city_bill_v'].",
    ".$_SESSION['$state_bill_v'].",
    ".$_SESSION['$zip_bill_v'].",
    ".$_SESSION['$country_bill_v'].",
    ".$_SESSION['$phone_bill_v'].",
    ".$_SESSION['$citizenship_v'].")";

I think

[trq]

All your values need surrounding single quotes.

[papaface]

So:

 $query="INSERT INTO user (
    name_last,
    name_first,
    email,
    password,
    username,
    address_home,
    city_home,
    state_home,
    zip_home,
    country_home,
    phone_home,
    address_bill,
    city_bill,
    state_bill,
    zip_bill,
    country_bill,
    phone_bill,
    citizenship)

    VALUES (
    '".$_SESSION['name_last_v']."',
    '".$_SESSION['name_first_v']."',
    '".$_SESSION['email_v']."',
    '".$_SESSION['password_v']."',
    '".$_SESSION['username_v']."',
    '".$_SESSION['address_home_v']."',
    '".$_SESSION['city_home_v']."',
    '".$_SESSION['state_home_v']."',
    '".$_SESSION['zip_home_v']."',
    '".$_SESSION['country_home_v']."',
    '".$_SESSION['phone_home_v']."',
    '".$_SESSION['address_bill_v']."',
    '".$_SESSION['city_bill_v']."',
    '".$_SESSION['$state_bill_v']."',
    '".$_SESSION['$zip_bill_v']."',
    '".$_SESSION['$country_bill_v']."',
    '".$_SESSION['$phone_bill_v']."',
    '".$_SESSION['$citizenship_v']."')";

[trq]

The op's original method is also correct, just missing the quotes. eg;

 

{$_SESSION['name_last_v']},

 

needs to be....

 

'{$_SESSION['name_last_v']}',

[jwwceo]

Thanks guys. That did it!!!