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); ?> Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.