show by date

I have a MySQL database that is a list of events happening in the area. On the full list of events page, everything comes up fine.

What I am trying to do is show a few events on another page that start with todays date and go forward.

I have the mySQL "sort_date" field set as date. I found an old post on here that I edited the table fields:
SELECT * FROM events WHERE sort_date => NOW()

Seems like: NOW() is an old method.

Appreciate any assistance.

Here is the link to the page: http://www.conejo365.com/default2.php

1) For the comparison, => is not valid, it should be >= (Greater Than or Equal To, not Equal To or Greater Than)

2) you need to use Date_Format to format the date in the database and NOW() so they are in the same format:

WHERE DATE_FORMAT(sort_date, "%Y-%m-%d") >= Date_Format(Now(), "%Y-%m-%d")

Jason,

When I format the sort_date field as "date", the content in the fields come up as: 0000-00-00. I had to wipe the table and reimport the csv file.

This is what I put in the SQL section of the recordset:
SELECT * FROM events WHERE sort_date >= NOW()
WHERE DATE_FORMAT(sort_date, "%Y-%m-%d") >= Date_Format(Now(), "%Y-%m-%d")

I also don't understand what you meant with the NOW(). Where do I format that?

When I put this code in the SQL section, I get the error in the attachment. Here is line 1:
<?php require_once('Connections/connConejo.php'); ?>

Thanks
Paul

your query now has 2 WHERE statements:

WHERE sort_date >= NOW()
WHERE DATE_FORMAT(sort_date, "%Y-%m-%d") >= Date_Format(Now(), "%Y-%m-%d")


only use the one where statement:

SELECT * FROM events
WHERE DATE_FORMAT(sort_date, "%Y-%m-%d") >= Date_Format(Now(), "%Y-%m-%d")

  I also don't understand what you meant with the NOW(). Where do I format that?  

that is what this part of the WHERE statement is doing:
Date_Format(Now(), "%Y-%m-%d")

Jason,

I went into the recordset rsEvents and pasted in what you wrote:
SELECT * FROM events
WHERE DATE_FORMAT(sort_date, "%Y-%m-%d") >= Date_Format(Now(), "%Y-%m-%d")

It tested with no records showing and when I uploaded the page, it was entirely blank. Nothing on the page at all.

Was I supposed to also format the sort_date field in phpmyadmin as date? But when I do that, it turns all the dates to zeros.

Thanks

I'll need to troubleshoot directly, see the private message section.

See PM

your sort date is in the wrong format in the Database. the datatype needs to be set to date, and the format should be:

yyyy-mm-dd


you are storing the dates in the wrong format:
7/30/2014


this means the column must a text column like varchar, MySQL can't do math operations like greater than or less than on text.

Jason,

I fixed the sort_date field to be yyyy-mm-dd and re-uploaded and replaced the entire database.

I then put in your code to the SQL statement of the recordset rsEvents:
SELECT * FROM events
WHERE DATE_FORMAT(sort_date, "%Y-%m-%d") >= Date_Format(Now(), "%Y-%m-%d")

When I click test, it shows it correctly. When I upload the page, it is completely blank.

Thoughts?

a blank page means that a php error is occurring but error reporting is turned off.

to turn error reporting on, add the following code at line 1:

<?php
error_reporting(E_ALL);
ini_set('display_errors','on');
?>

once we know what the error is, we will be able to troubleshoot the cause.