if timestamp is one of my table fields how do i select all the data for the current week
Check out the Date/calc.php script in PEAR (installed with php) for some functions that will help you out.
