<div>
Managed to figure it out anyway with a NOW() but your one also works.
</div>


Managed to figure it out anyway with a NOW() but your one also works.

<div>
<div class="content wysiwyg-content">
Hey guys, having a bit of trouble finding out the code i need so that i only display the records after todays date in a mysql statement. I know its a WHERE command but i cant seem to get it to work.<br />
<br />
Basically i have a table for some tour dates and i want the page to only display the dates after &amp;&nbsp;including today only. Then on another page have all the dates that occurred before todays date.<br />
<br />
Anyone know the code for the statement? <br />
<br />
Cheers
</div>
</div>


Hey guys, having a bit of trouble finding out the code i need so that i only display the records after todays date in a mysql statement. I know its a WHERE command but i cant seem to get it to work.

Basically i have a table for some tour dates and i want the page to only display the dates after & including today only. Then on another page have all the dates that occurred before todays date.

Anyone know the code for the statement? 

Cheers

Show only records that occur after todays date

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.