Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: Another MySql error (simple)  (Read 3269 times)

0 Members and 1 Guest are viewing this topic.

Bannana97

    Topic Starter


    Intermediate
  • Owner of HerbertsWorld Corporation
    Another MySql error (simple)
    « on: August 15, 2009, 11:53:41 AM »
    Errm.

    Code: [Select]
    UPDATE `inbox` SET `read` = 'true' WHERE `id` = `26`
    Error:

    Code: [Select]
    SQL query:

    UPDATE `inbox` SET `read` = 'true' WHERE `id` = `26`

    MySQL said: 

    #1054 - Unknown column '26' in 'where clause'
    Thanks
    Bannana97

    kpac

    • Web moderator
    • Moderator


    • Hacker

    • kpac®
    • Thanked: 184
      • Yes
      • Yes
      • Yes
    • Certifications: List
    • Computer: Specs
    • Experience: Expert
    • OS: Windows 7
    Re: Another MySql error (simple)
    « Reply #1 on: August 15, 2009, 12:33:23 PM »
    http://www.w3schools.com/php/php_mysql_update.asp

    Table names and fields do not need apostrophies.