Update query PHP MySQL

Question

Can anybody help me understand why this update query isn t updating the fields in my database  I have this in my php page to retrieve the current values from the database    lt  php     query   mysql query   SELECT   FROM blogEntry WHERE username    bobjones  ORDER BY id DESC       while   row   mysql fetch array   query               id    row  id            username    row  username           title    row  title           date    row  date           category    row  category           content    row  content            gt    Here i my HTML Form    lt form method  post  action  editblogscript php  gt  ID   lt input type  text  name  id  value   lt  php echo  id    gt     gt  lt br   gt  Username   lt input type  text  name  username  value   lt  php echo   SESSION  username      gt     gt  lt br   gt  Title   lt input type  text  name  udtitle  value   lt  php echo  title    gt    gt  lt br   gt  Date   lt input type  text  name  date  value   lt  php echo  date    gt    gt  lt br   gt  Message   lt textarea name    udcontent  cols  45  rows  5  gt  lt  php echo  content    gt  lt  textarea gt  lt br   gt   lt input type   submit  name    edit  value  Edit   gt   lt  form gt    and here is my  editblogscript     lt  php  mysql connect   localhost    root        mysql select db  blogass     if  isset   POST  edit             id     POST  id         udtitle     POST  udtitle         udcontent     POST  udcontent          mysql query  UPDATE blogEntry SET content    udcontent  title    udtitle WHERE id    id       header   Location  index php             gt    I don t understand why it doesn t work

User · Answer

First  you should define  doesn t work   Second  I assume that your table field  content  is varchar text  so you need to enclose it in quotes  content      content   And last but not least  use echo mysql error   directly after a query to debug

User · Answer

Here i updated two variables and present date and time   id       1    title    phpmyadmin       sql   mysql query  UPDATE table name SET id      id     title       title    now   WHERE id       id          now   function update current date and time   note  For update query we have define the particular id otherwise it update whole table defaulty

User · Answer

Need to add quote for that need to use dot operator   mysql query  UPDATE blogEntry SET content       udcontent     title       udtitle    WHERE id       id

User · Answer

Update a row or column of a table   update    UPDATE daily patients SET queue status    pending  WHERE doctor id    room no and serial number   serial num    if   con- gt query  update      TRUE        echo  Record updated successfully     else       echo  Error updating record       con- gt error

User · Answer

lt  php require  db config php        id      POST  id       post     POST      sql    UPDATE items SET title       post  title            description       post  description            WHERE id       id          result    mysqli- gt query  sql        sql    SELECT   FROM items WHERE id       id           result    mysqli- gt query  sql       data    result- gt fetch assoc      echo json encode  data     gt

User · Answer

You have to have single quotes around any VARCHAR content in your queries  So your update query should be   mysql query  UPDATE blogEntry SET content     udcontent   title     udtitle  WHERE id    id      Also  it is bad form to update your database directly with the content from a POST  You should sanitize your incoming data with the mysql real escape string function

User · Answer

Without knowing what the actual error you are getting is I would guess it is missing quotes  try the following   mysql query  UPDATE blogEntry SET content     udcontent   title     udtitle  WHERE id     id

User · Answer

you must write single quotes then double quotes then dot before name of field and after like that  mysql query  UPDATE blogEntry SET content      udcontent     title       udtitle    WHERE id       id

User · Answer

Try like this in sql query  It will work fine    sql  UPDATE create test set url     POST url   WHERE test name   test name       If you have to update multiple columns  Use like this    sql  UPDATE create test set  url      POST url    platform     POST platform   WHERE test name   test name

[php] Update query PHP MySQL

Examples related to php

Examples related to mysql

Examples related to database

Examples related to phpmyadmin

Examples related to blogs