[micheal332001]

Hi there m8

I used this code in my lotto script to display the lotto thats has passed you might be able to use this to show the days and time left till a item finishes.

PHP Code:

$result_lastlottowinners = $db->query_first("SELECT *, DATE_FORMAT(winningdate,'%d-%m-%Y: %l:%i:%s') AS winningdate FROM " . TABLE_PREFIX . "mmlotto_lotto_winners WHERE id=$id"); 


then you would put a output like

PHP Code:

$result_lastlottowinners[winningdate]; 


As you might have 2 dates in the database for the item being sold like date added and end date you would do some thing like this

$itemenddate = $date_started-$date_end;


Hope this helps you out