Results 1 to 3 of 3

Thread: MySQL Bug

  1. #1
    Join Date
    Oct 2004
    Posts
    23

    Default MySQL Bug

    For some reason I can't compare a Date entry to the curDate() function in an SQL statement off of the mySQL server on bizhat.

    On my installation I can use:
    "SELECT * FROM Events WHERE date > curdate() ORDER BY Events.Date ASC LIMIT 0,3"
    as a query to select the next 3 events in a calendar to display on the front page.

    When I port this across to the bizhat server i just get a query returning nothing (not even an error) - has anyone got any ideas?

  2. #2
    Join Date
    Jan 2005
    Posts
    23

    Default

    phpMyAdmin didnt wowk?????????/
    why ??????????????

  3. #3
    Join Date
    Oct 2004
    Posts
    23

    Default

    phpMyAdmin was fine, the query returning from mySQL was the problem - it just returned nothing...

    Deleted the whole table and reinserted the data - that made it happy at least

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
  •