Pro/Forums - View Single Post - I need some SQL/PHP/vB Help!!! Programmers!

Joe · 08-21-2003, 05:05 PM

NM ! I fixed it.

The revised code is as such:

Code:

$events = $DB_site->query ("SELECT UNIX_TIMESTAMP() AS dateline, dateline_from, eventid, title 
                           FROM event
                           WHERE dateline_from > dateline
                           ORDER BY dateline_from LIMIT 4");

Doh, but now it works great and with all unix time code (so I can manipulate it later in the script to the formats I want)

08-21-2003, 05:05 PM	#2
Joe The Pro/Life Support System Join Date: Dec 1999 Location: Denver, CO Posts: 4,041	NM ! I fixed it. The revised code is as such: Code: $events = $DB_site->query ("SELECT UNIX_TIMESTAMP() AS dateline, dateline_from, eventid, title FROM event WHERE dateline_from > dateline ORDER BY dateline_from LIMIT 4"); Doh, but now it works great and with all unix time code (so I can manipulate it later in the script to the formats I want) __________________ Joe - I only take this hat off for one thing... ProCooling archive curator and dusty skeleton.