Board index   FAQ   Search  
Register  Login
Board index php forum :: php coding PHP coding => General

Error in a column

Ask about general coding issues or problems here.

Moderators: macek, egami, gesf

Error in a column

Postby ychan20 » 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'
ychan20
New php-forum User
New php-forum User
 
Posts: 5
Joined: Mon Feb 04, 2013 4:44 pm

Re: Error in a column

Postby armandohg » Sun Feb 10, 2013 10:30 pm

Make sure you have that column on table 'userregister'
armandohg
New php-forum User
New php-forum User
 
Posts: 3
Joined: Sun Feb 10, 2013 10:23 pm

Re: Error in a column

Postby simplypixie » 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 :?
User avatar
simplypixie
php-forum Active User
php-forum Active User
 
Posts: 300
Joined: Sun Dec 11, 2011 12:51 am
Location: Shrewsbury, Shropshire

Re: Error in a column

Postby seandisanti » Thu Feb 14, 2013 2:07 pm

Yes, i think this is not the 3rd iteration of the same thread
seandisanti
php-forum Fan User
php-forum Fan User
 
Posts: 773
Joined: Mon Oct 01, 2012 12:32 pm


Return to PHP coding => General

Who is online

Users browsing this forum: No registered users and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.