CSS Codes
CSS Layouts
Results 1 to 2 of 2

Thread: MySQL Error In Query

  1. 04-17-2007, 02:04 AM #1
    tomyknoker
    tomyknoker is offline Senior Coders
    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' 
    Reply With Quote Reply With Quote
  2. 04-17-2007, 02:12 AM #2
    thetestingsite's Avatar
    thetestingsite
    thetestingsite is offline The Guy That Moderates
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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
  •  

Forum Rules