Get row with datetime closest to current time?

Register Here Forum Rules

PHP Forum

You are currently viewing our PHP Forum as a guest. Please register to participate.

Freelance Jobs

Reply

Link Back Thread Tools Search this Thread

Get row with datetime closest to current time?

02-07-2008, 02:25 PM	#1 (permalink) Get row with datetime closest to current time?
dansgalaxy Defies a Status Latest Blog Post: .XXX Sunrise is over, Now for Landrush. Posts: 6,521 Name: Dan Location: Swindon Trades: 0 Talkupation:	hi, i have a events thing on the site im doing: http://calmcharity.org/events.php and i want to be able to get the single event closest to the current date so i can have it like NEXT event: This its probably a simple query but im not sure. __________________ Discounted Web Hosting With XDnet! >> Get 25% of hosting~ Promo: Webmaster-talk << Please login or register to view this content. Registration is FREE

Register now for full access!

02-07-2008, 03:19 PM	#2 (permalink) Re: Get row with datetime closest to current time?
dansgalaxy Defies a Status Latest Blog Post: .XXX Sunrise is over, Now for Landrush. Posts: 6,521 Name: Dan Location: Swindon Trades: 0 Talkupation:	Done it, Please delete thread used: "SELECT * FROM events WHERE date > '$cur_datetime' ORDER BY date ASC LIMIT 1" __________________ Discounted Web Hosting With XDnet! >> Get 25% of hosting~ Promo: Webmaster-talk << Please login or register to view this content. Registration is FREE

Reply

« Reply to Get row with datetime closest to current time?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are Off Pingbacks are Off Refbacks are Off Forum Rules

Feeds: RSS JS XML

Feeds for this forum: RSS JS XML

Page generated in 0.09442 seconds with 12 queries