SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: query error?

  1. #1
    SitePoint Enthusiast urbanformula's Avatar
    Join Date
    Apr 2004
    Location
    Burlington, VT .. USA
    Posts
    48
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    query error?

    i can't find the issue in this query... any help

    $query = "UPDATE wine_list SET title = '$title', spantitle = '$spantitle', region = '$region', spanregion = '$spanregion', desc = '$desc', spandesc = '$spandesc', price = '$price', year = '$year', image = '$image' WHERE id = '$id'";

  2. #2
    SitePoint Enthusiast jcarouth's Avatar
    Join Date
    Sep 2006
    Location
    College Station, TX
    Posts
    48
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    DESC is a reserved word. you can either change the name of the column to something that is not a reserved word, or enclose the column name in backticks ` (not single quotes). in the future, do not use reserved words as database, table, or column names.

  3. #3
    SitePoint Enthusiast urbanformula's Avatar
    Join Date
    Apr 2004
    Location
    Burlington, VT .. USA
    Posts
    48
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thanks, that was it


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •