Problems with SQL query

    Date: 07/04/05 (PHP Community)    Keywords: php, database, sql

    Hi,

    I am having problems with an SQL query not returning any rows. My table in my database is set up like:

    ns_event_month INTEGER
    ns_event_day INTEGER
    ns_event_year INTEGER

    (i'm leaving many fields out)


    
    



    And here is part of my code. It returns zero rows, however there are 2 records in my database that are 5/6/2005 and 5/7/2005 (m/d/y). So there are 2 archived "events" already, but this query returns nothing.

    http://www.welcometothenuclearage.com/shows.php (a link to the page that isn't working correctly)

    I am currently displaying all the current shows my band has booked, but I want to show all the past shows. This was working fine until one day, and then it just stopped working. So I'm lost...

    Any help is greatly appreciated.

    Source: http://www.livejournal.com/community/php/314881.html

« PHP/MySQL Import || SQL Server Connection »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home