pfoster77

tried above but can;t seem to get it working. plus I have a div that refreshes the order information on a setinterval

Do you have any workable script I can try out

Hi all I need some help, i have a list of orders on the left column and want to click on each order and display related db information in the right column in a div or other method for each record click. screenshot attached.

I put in the above and removed the if statement and changed DESC on both to ASC and it works beautifully. Thank you very much, I have been trying to solve this for days. Thanks again and you have a go at something so long, you miss the obvious thing! lol

the above works but displays the last available record which is 1st Nov 2014 but there is a record for 2nd July 2014 but when I change DESC to ASC, i get nothing returned.

SELECT * FROM events ORDER BY date,time LIMIT 5

As above, it lists about 15 records after todays date but when I put in LIMIT 5 it displays no records. What could be wrong? Am working off the field `date` which is setup as a data type date, is this the problem?

Hi all I want to display 5 records found in query and display by date order to most recent to todays date. Any help most appreciated. The php script below <?php include 'c/config.php'; include 'c/library/opendb.php'; include 'c/library/timeFunctions.php'; include 'c/library/displayFunctions2.php'; $query = "SELECT * FROM events ORDER BY date,time"; $result = mysql_query($query); while($row = mysql_fetch_assoc($result)) { if ($row['date'] >= date('Y-m-d')) { displayEventsCurrent($row); } } include 'c/library/closedb.php'; ?>