search by datetime

[jagguy]

hi,

 

I want to use php to display  a table with  data fields added over the past 4 weeks .

This table has a field 'added' of type datetime( eg 2007-22-03 12:32:14) . How do i do this in php?

 

select *  from categories  where  products_date_added > (todays date - 4 weeks)

 

 

[onlyican]

First you want to get what today - 4 weeks is

 

<?php
$LinuxToday = strtotime("now");
$ADay = 1*60 *60 *24;

$Linux4WeeksAgo = $LinuxToday - 28 * $ADay;

$DB4WeeksAgo = date("Y-m-d H:i:s", $Linux4WeeksAgo;
$Today = date("Y-m-d H:i:s");
$query = "SELECT * FROM Categories WHERE ProductsDateAdded BETWEEN '".$DB4WeeksAgo."' AND '".$Today."'";

?>

[jagguy]

thanks for the answer, i appreciate it.

 

Do you happen to know how zenlink works in php?