[SOLVED] Why is this query giving errors?

[jwwceo]

$query="INSERT INTO reservations (package_id,user_id,ccnum,exp_date,avs,total,num_people,)
VALUES('$_SESSION['packageid_v']','$_SESSION['user_id_v']','$_SESSION['ccnum_v']','$_SESSION['expdate_v']','123','$_SESSION['total_v']','$_SESSION['numpeople_v']')";

 

I get an T_ENCAPSED_AND_WHITESPACE error. But can't see why?

 

JW

[kenrbnsn]

Your getting it because of the multiple quotes used incorrectly. Try

<?php
$query="INSERT INTO reservations (package_id,user_id,ccnum,exp_date,avs,total,num_people,)
VALUES('{$_SESSION['packageid_v']}', '{$_SESSION['user_id_v']}', '{$_SESSION['ccnum_v']}', '{$_SESSION['expdate_v']}', '123', '{$_SESSION['total_v']}','{$_SESSION['numpeople_v']}')";
?>

 

Ken

[xiao]

And maybe remove the last comma in

$query="INSERT INTO reservations (package_id,user_id,ccnum,exp_date,avs,total,num_people,)

(the one after num_people)