MySQL error #1064

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • amaddox@gmail.com

    MySQL error #1064

    When I run this query from PHPMyAdmin, it works:

    DELETE FROM `tbl_user_link` WHERE ((`ulUserID`!=3 AND `ulConnectID`!
    =1) AND (`ulUserID`!=18 AND `ulConnectID`!= 23)) AND `ulTypeID`=10 AND
    `ulOtherID`=160

    However, when I run it from my application, I get a MySQL error 1064.

    Any ideas?

  • Jerry Stuckle

    #2
    Re: MySQL error #1064

    amaddox@gmail.c om wrote:
    When I run this query from PHPMyAdmin, it works:
    >
    DELETE FROM `tbl_user_link` WHERE ((`ulUserID`!=3 AND `ulConnectID`!
    =1) AND (`ulUserID`!=18 AND `ulConnectID`!= 23)) AND `ulTypeID`=10 AND
    `ulOtherID`=160
    >
    However, when I run it from my application, I get a MySQL error 1064.
    >
    Any ideas?
    >
    >
    Try a MySQL newsgroup - such as comp.databases. mysql. And be sure you
    provide the entire message.

    --
    =============== ===
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    jstucklex@attgl obal.net
    =============== ===

    Comment

    • Betikci Boris

      #3
      Re: MySQL error #1064

      On Oct 29, 10:43 pm, "amad...@gmail. com" <amad...@gmail. comwrote:
      When I run this query from PHPMyAdmin, it works:
      >
      DELETE FROM `tbl_user_link` WHERE ((`ulUserID`!=3 AND `ulConnectID`!
      =1) AND (`ulUserID`!=18 AND `ulConnectID`!= 23)) AND `ulTypeID`=10AN D
      `ulOtherID`=160
      >
      However, when I run it from my application, I get a MySQL error 1064.
      >
      Any ideas?
      Error No.1064 is a syntax error, watch your code quotation marks etc...

      Comment

      Working...