I am having a problem doing a simple insert into a table. When I only attempt to insert into a few colums - no problem but, if I try to insert the full set of variables into the table It returns 0 and nothing happens. Here is my sql:
$db = mysql_connect("localhost", "username","password");
mysql_select_db("my_db",$db);
$sql = "INSERT INTO table (first_name,last_name,street1,street2,city,state,zip,email,phone,order_date,sep_ship_address,s_first_name,s_last_name,s_street1, s_street2,s_city,s_state,s_zip,s_country,s_phone,s_fax,product1qty,product2qty,product3qty,s_h,tax,ordertotal,cc_name,cctype,cc_expdate,cc_number) VALUES ('$sess_first_name','$sess_last_name','$sess_street1','$sess_street2','$sess_city','$sess_state','$sess_zip','$sess_email','$sess_phone','$order_date','$sess_sep_ship','$sess_s_first_name','$sess_s_last_name','$sess_s_street1','$sess_s_street2,'$sess_s_city','$sess_s_state','$sess_s_zip','$sess_s_country','$sess_s_phone','$sess_s_fax','$sess_product1qty','$sess_product2qty','$sess_product3qty','$sess_s_h','$sess_tax','$sess_total','$sess_cc_name','$sess_cctype','$sess_cc_expdate','$sess_cc_num')";
$result = mysql_query($sql);
It's kind of jumbled here but, you get the idea.
thanks
$db = mysql_connect("localhost", "username","password");
mysql_select_db("my_db",$db);
$sql = "INSERT INTO table (first_name,last_name,street1,street2,city,state,zip,email,phone,order_date,sep_ship_address,s_first_name,s_last_name,s_street1, s_street2,s_city,s_state,s_zip,s_country,s_phone,s_fax,product1qty,product2qty,product3qty,s_h,tax,ordertotal,cc_name,cctype,cc_expdate,cc_number) VALUES ('$sess_first_name','$sess_last_name','$sess_street1','$sess_street2','$sess_city','$sess_state','$sess_zip','$sess_email','$sess_phone','$order_date','$sess_sep_ship','$sess_s_first_name','$sess_s_last_name','$sess_s_street1','$sess_s_street2,'$sess_s_city','$sess_s_state','$sess_s_zip','$sess_s_country','$sess_s_phone','$sess_s_fax','$sess_product1qty','$sess_product2qty','$sess_product3qty','$sess_s_h','$sess_tax','$sess_total','$sess_cc_name','$sess_cctype','$sess_cc_expdate','$sess_cc_num')";
$result = mysql_query($sql);
It's kind of jumbled here but, you get the idea.
thanks