Results 1 to 2 of 2

Thread: MySQL Error In Query

  1. #1
    Join Date
    Apr 2006
    Posts
    584
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default MySQL Error In Query

    Can anyone see why this doesn't work? Is it becuase I am joing the . with brackets?

    PHP Code:
    WHERE tblmember.MONTH(DateOfBirth) = '{$theMonth}') AND `member`='J' 

  2. #2
    Join Date
    Sep 2006
    Location
    St. George, UT
    Posts
    2,769
    Thanks
    3
    Thanked 157 Times in 155 Posts

    Default

    You have an extra brace in the statement:

    Code:
    WHERE tblmember.MONTH(DateOfBirth) = '{$theMonth}') AND `member`='J'
    other than that, I don't see anything else.
    Hope this helps.
    "Computer games don't affect kids; I mean if Pac-Man affected us as kids, we'd all be running around in darkened rooms, munching magic pills and listening to repetitive electronic music." - Kristian Wilson, Nintendo, Inc, 1989
    TheUnlimitedHost | The Testing Site | Southern Utah Web Hosting and Design

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
  •