[SOLVED] Date times....

[phpSensei]

I have a little question...

 

Can I use the SELECT statement, and Display all my data from a certain table depending on the date?

 

If the date is newer then it will show that id, within the table?

 

Any of this possible?

 

I was thinking of this

 

<?php

$sql="SELECT * FROM table_1 ORDER BY date ASC";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);
?>

[AndyB]

SELECT .... WHERE date [some operator] [some date]  for example date>'2006-07-14'

[phpSensei]

Edit: I know what you mean but...

 

I dont know which function will calculate the most current date.

[AndyB]

Exactly how you resolve it depends on what format you've used for 'date' in your database. The date() function along with the strtotime() or mktime() functions ought to be able to handle most of what you need.

 

list($y,$m,$d) = explode("-",date("Y-m-d"));// today
$month_ago = date("Y-m-d", mktime(0,0,0,$m-1,$d,$y));

[phpSensei]

Exactly how you resolve it depends on what format you've used for 'date' in your database. The date() function along with the strtotime() or mktime() functions ought to be able to handle most of what you need.

 

list($y,$m,$d) = explode("-",date("Y-m-d"));// today
$month_ago = date("Y-m-d", mktime(0,0,0,$m-1,$d,$y));

 

Thankyou so much, My forum is done with everything.

 

This was the only thing left.