I solve this issue on my own.. yay.. seems that i havent been waisting my time learning and cramming all this stuff for the past few months now... ahhh
the problems is , i think, is the way how the translation works when running this stuff on windows 2003. the sql string works great from any admin tool and even the command line but doesnt from the php page.. IIS??? php under 2003? mysql handler under 2003?? who knows
but this is what i did - this is the original code
$sql_data_array = array('vendors_id' => $vendors_id,
'vendors_name' => $vendors_name,
'vendors_contact' => $vendors_contact,
'vendors_phone1' => $vendors_phone1,
'vendors_phone2' => $vendors_phone2,
'vendors_email' => $vendors_email,
'vendors_send_email' => $vendors_send_email,
'vendors_status_send' => $vendors_status_send,
'vendor_street' => $vendor_street,
'vendor_add2' => $vendor_add2,
'vendor_city' => $vendor_city,
'vendor_state' => $vendor_state,
'vendors_zipcode' => $vendors_zipcode,
'vendor_country' => $vendor_country,
'account_number' => $account_number,
'vendors_url' => $vendors_url,
'vendor_add_info' => $vendor_add_info,
'handling_charge' => $handling_charge,
'handling_per_box' => $handling_per_box,
'tare_weight' => $tare_weight,
'percent_tare_weight' => $percent_tare_weight,
'max_box_weight' => $max_box_weight,
'zones' => $zones);
$sql_data_array = array('vendors_name' => $vendors_name,
'vendors_contact' => $vendors_contact,
'vendors_phone1' => $vendors_phone1,
'vendors_phone2' => $vendors_phone2,
'vendors_email' => $vendors_email,
'vendors_send_email' => $vendors_send_email,
'vendors_status_send' => $vendors_status_send,
'vendor_street' => $vendor_street,
'vendor_add2' => $vendor_add2,
'vendor_city' => $vendor_city,
'vendor_state' => $vendor_state,
'vendors_zipcode' => $vendors_zipcode,
'vendor_country' => $vendor_country,
'account_number' => $account_number,
'vendors_url' => $vendors_url,
'vendor_add_info' => $vendor_add_info,
'handling_charge' => $handling_charge,
'handling_per_box' => $handling_per_box,
'tare_weight' => $tare_weight,
'percent_tare_weight' => $percent_tare_weight,
'max_box_weight' => $max_box_weight,
'zones' => $zones);
this is what i changed it to... I believe it has to do with how the mysql handler for windows deals with certain sql calls based on column type in the table. Something i have had alot of experience with using ms sql ect... yes im a windows guy
since vendors_id is a pri key with auto_increment.. i just deleted this part out of the sql string.. looks like this
$sql_data_array = array('vendors_name' => $vendors_name,
'vendors_contact' => $vendors_contact,
'vendors_phone1' => $vendors_phone1,
'vendors_phone2' => $vendors_phone2,
'vendors_email' => $vendors_email,
'vendors_send_email' => $vendors_send_email,
'vendors_status_send' => $vendors_status_send,
'vendor_street' => $vendor_street,
'vendor_add2' => $vendor_add2,
'vendor_city' => $vendor_city,
'vendor_state' => $vendor_state,
'vendors_zipcode' => $vendors_zipcode,
'vendor_country' => $vendor_country,
'account_number' => $account_number,
'vendors_url' => $vendors_url,
'vendor_add_info' => $vendor_add_info,
'handling_charge' => $handling_charge,
'handling_per_box' => $handling_per_box,
'tare_weight' => $tare_weight,
'percent_tare_weight' => $percent_tare_weight,
'max_box_weight' => $max_box_weight,
'zones' => $zones);
Works good now! Keep up the good work with this stuff. I Love it :thumbsup: :thumbsup:::thumbsup: