Jump to content

How Can I Print-Echo Data Between Dates Only


just me and php

Recommended Posts

Ok I Found This In Your Forums And I Think Its What Im Looking For But I Dont Under Stand How It Knows What Is The Start Or End Date.[url=http://www.phpfreaks.com/forums/index.php/topic,106961.0.html]http://www.phpfreaks.com/forums/index.php/topic,106961.0.html[/url]
Well I Tryed A Few Different Way Bet Get Error, How Can I Use This In My Code?
[code]$query = "SELECT * FROM NatHotLap  BETWEEN date '12/10/06 22:46:16' AND date '12/17/06 22:46:16'";
=================
And I Tryed This Way

$query = "SELECT recno,disp,track,Username,date,online,hacked, MIN(HL_MS) AS HL_MS,reshack FROM NatHotLap  BETWEEN date '12/10/06 22:46:16' AND date '12/17/06 22:46:16'  ORDER BY 'HL_MS' ASC  ";
=================
This Is My Code

$p_id = $_GET['id'];
$query = "SELECT recno,disp,track,Username,date,online,hacked, MIN(HL_MS) AS HL_MS,reshack FROM NatHotLap WHERE track = '$p_id' GROUP BY 'disp','online','Username','track'  ORDER BY 'HL_MS' ASC  ";[/code]

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.