www.webdeveloper.com
Results 1 to 3 of 3

Thread: MYSQL Query issues

  1. #1
    Join Date
    Oct 2009
    Posts
    34

    MYSQL Query issues

    I'm having issues getting my query to return any data. I'm trying to find a way to query between two dates (dynamically entered into the query, one being today, the other being either end of month of one month from now) while still having the query sort the data for me. Previously I had PHP do this work for me, but I'm looking to essentially streamline my code. I had my script print the query prior to the query being run and I pasted it below.

    Here is my query, does anyone see any issues.
    Code:
    SELECT * FROM events WHERE date BETWEEN '2010-12-09' AND '2011-01-09' ORDER BY date ASC, starttime ASC, endtime ASC

  2. #2
    Join Date
    Oct 2009
    Posts
    34
    I also get this error if it helps at all:
    Code:
    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

  3. #3
    Join Date
    Oct 2009
    Posts
    34
    If anyone could just delete this thread, that would be fine. I fixed the problem already.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles