Error in a column

Ask about general coding issues or problems here.

Moderators: egami, macek, gesf

Post Reply

Mon Feb 04, 2013 4:47 pm

:help: :help: 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'

User avatar
php-forum Active User
php-forum Active User
Posts: 300
Joined: Sun Dec 11, 2011 12:51 am
Location: Shrewsbury, Shropshire

Sun Feb 10, 2013 11:38 pm

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

php-forum Fan User
php-forum Fan User
Posts: 974
Joined: Mon Oct 01, 2012 12:32 pm

Thu Feb 14, 2013 2:07 pm

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

Post Reply