how to do update query statement in mysql

Question

Please Correct me here, i am trying to update or insert values in existing row in my database, but not able to this, all the variables is working but its not getting into database also checked in phpmyadmin sql query but it was not working there also, there it shows success but not a single data getting into mysql columns..

include("connect.php");

$sql = "UPDATE tblapps SET applsex='$applsex', placbrth='$placbrth', countrybrth='$countrybrth', religionxx='$religionxx', visualmark='$visualmark', edu_id='$edu_id', nationality_by='$nationality_by', prev_nationality='$prev_nationality', issueplace='$issueplace', expirydate='$expirydate', othpassport='$otherpassport', oth_passportno='$oth_pass_no', oth_pptissueplc='$oth_ppt_issue_place', oth_pptissuentl='$oth_ppt_nationality', country_issue='$country_issue', previssuedate='$previssuedate' WHERE app_id=$appid";
if(mysqli_query($link, $sql)){
    echo "Records were updated successfully.";
} else {
    echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}

?>

this is the error, I am getting.

ERROR: Could not able to execute UPDATE tblapps SET applsex='', placbrth='delhi', countrybrth='United States', religionxx='CHRISTIAN', visualmark='', edu_id='GRADUATE', nationality_by='By Birth', prev_nationality='', issueplace='delhi', expirydate='2018-11-01', othpassport='on', oth_passportno='9876546789', oth_pptissueplc='delhi', oth_pptissuentl='United States', country_issue='', previssuedate='2018-01-02' WHERE app_id='1515130357782247085'. Unknown column 'othpassport' in 'field list'

May be it's question duplicate : https://stackoverflow.com/questions/8893551/update-query-php-mysql — Nims Patel, Jan 05 '18 at 05:24
You sure the table you're trying to update contains `othpassport` and is spelled correctly in your sql statement? — Yusuf Hassan, Jan 05 '18 at 05:48
@YusufHassan : yes now its working. there were some field missspelled.. — Gaurav Singh, Jan 05 '18 at 05:50

score 2 · Answer 1 · answered Jan 05 '18 at 05:51

2

Unknown column 'othpassport' in 'field list'

This meant to say that othpassport coloumn is not available in your database table. Kindly check table or rename it.

i hope it helps.

answered Jan 05 '18 at 05:51

TarangP

2,711
5
20
41

Chetan Singh Samant · Answer 2 · 2018-01-05T06:09:59.130

1

You are getting error : Unknown column 'othpassport' in 'field list'

This meant to say that othpassport coloumn is not available in your database table or you typed it wrong. And according to your coding style I think the column name may be otherpassport . Hope you find it helpful , Thanks!!

edited Jan 05 '18 at 06:09

answered Jan 05 '18 at 05:38

Chetan Singh Samant

40
9

@Gaurav Singh edited that question after I posted my answer – Chetan Singh Samant Jan 05 '18 at 05:57
At that time how would anyone know what is the error he getting @TarangP – Chetan Singh Samant Jan 05 '18 at 05:58
Also I dont have that much point to ask query in comment @TarangP – Chetan Singh Samant Jan 05 '18 at 06:00

how to do update query statement in mysql

2 Answers2