Error in a column

[ychan20]

Hi i am updating my php and mysql update when i had suddenly encounter this problem , please help thanks

$str = "insert into userregister (username,email,password,usertype,firstname,lastname,gender,dob,address1,address2,country, state,city,postalcode,landline,mobile,companyname,fax,website,userlearn,message,terms,newsletter,status, delete_status,reg_date,reg_IP_address,randomkey,reg_regon,reg_nip,reg_krs,landline_show,mobile_show) values ('$reg_username','$reg_useremail','$reg_userpassword','$reg_usertype', '$reg_userfirstname','$reg_userlastname','$reg_gender','$dob','$reg_addr1','$reg_addr2','$reg_country','$reg_state', '$reg_city','$reg_pin','$reg_phone','$reg_mobile','$reg_companyname','$reg_fax','$reg_website','$reg_userlearn','$reg_usermessage','$chk','$nletter','$status','$dstatus',NOW(),'$ip','$random_req_id','$reg_regon','$reg_nip','$reg_krs','$lshow','$mshow')";


and the output is Unknown column 'landline_show' in 'field list'

[armandohg]

Make sure you have that column on table 'userregister'

[simplypixie]

ychan20 - I have already told you a while back to check if the column exists in your database table

[seandisanti]

Yes, i think this is not the 3rd iteration of the same thread