Powered by:
FutureQuest Hosting


"...Remember being a youngster, mom or dad telling you "close the door"? Well the same applies to HTML ...."

Web Hosting
Shared       
Reseller     
VPS             
Dedicated 
Price:   $(US)
Space:     (MB)
Transfer:(GB)
Platform:


Advertise
Advertising Opportunities
Rate Card

Sponsor
Go Back   Webmaster Forums > Code Forum > PHP Forum


Reply
 
Thread Tools Rate this Webmaster Discussion
  #1  
Old 11-07-2009, 11:41 AM
deliriousthunder deliriousthunder is offline
Member
 
Join Date: Feb 2009
Webmaster Discussions: 28
Rep Power: 5
deliriousthunder is on a distinguished road
MySQL query

Hi,

I have a database table which contains records of a list of events, obviously there are several properties related to each event, one of which is the "Start Date".

For a page on my site I need to query that table, and display a list of the events which haven't yet started, (i.e. upcoming events).

In the table, the field type in the database table is date, so I figure there must be an easy way to query it so that it only returns events which haven't started yet.

Just looking for a hint really, haven't tried it or researched it yet.

Thanks,
Thomas


Reply With Quote
Reply
Sponsor

Bookmarks

Tags
mysql , query

Thread Tools
Rate This Thread
Rate This Thread:

 

Similar Webmaster Discussions
Thread Webmaster Discussion Starter Forum Replies Last Post
mysql query / function problem.... pegboy Databases 7 08-29-2006 02:53 PM
How to insert IF statement into MySQL query displaying results in 2 columns? petewalton PHP Forum 4 06-20-2006 09:20 AM
Downgrade to non-sub query, but how to change this mysql statement?? raffiq_eddy PHP Forum 0 04-26-2005 11:43 PM
My sql query javier_ccs PHP Forum 0 04-20-2005 03:13 PM


All times are GMT -5. The time now is 04:45 PM.

Copyright © 1999 - 2009 Advanced HTML For Beginners and AHFB2000. All rights reserved.
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.