I have this SQL I wish to perform:
Code: Select all
$sql = "SELECT * FROM pos_history WHERE date = '$short_date' ORDER BY id ASC";Obviously they don't match, but the question is, how can I tell it to only match the YEAR-MONTH-DAY part of the entry in the database and ignore the time element?
A toughy! (for me
All suggestions appreciated.
Rob