chris666uk1 Posted October 17, 2011 Share Posted October 17, 2011 please can you help me i am trying to get my graph to only show last 5 days of data and only the dates and not times thanks for looking <?php /* Connect to the MySQL database */ $db = mysql_connect("localhost", "8conv", "dangun"); mysql_select_db("tempmonitor",$db); /* Build the query that will returns the data to graph */ $Requete = "SELECT * FROM `8conv`"; $Requete = $Result = mysql_query($Requete,$db); ?> Link to comment https://forums.phpfreaks.com/topic/249269-only-use-last-5-days-of-data-help/ Share on other sites More sharing options...
fenway Posted October 18, 2011 Share Posted October 18, 2011 I've edited your post -- all we need to see is the query. You need something along the lines of "WHERE yourDateTimeField >= NOW() - INTERVAL 5 DAY". If you only want the dates, and not the times, you can use DATE() on the datetime field. Link to comment https://forums.phpfreaks.com/topic/249269-only-use-last-5-days-of-data-help/#findComment-1280186 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.