Date Search Problem

[annimal]

Hi all i have a D/B search querying two UNIX time stamps. like this

$date=1150498800;
$date2=1153782000; 
$query="SELECT event,eventyear,eventstart,totalnt,totalg,ticketsleft,tadult,tchild FROM admin 
WHERE stamp <= $date2 AND stamp >= $date AND stamp AND event LIKE '%$superp%'"; 

this works appart from the result i get is not correct!
the result is -3 dates from $date2 i beleve i need some thing like this

<= $date2 AND stamp >= <= $date AND stamp > 

but i cant figure out the correct syntax ive tryed using a BETWEEN query to but obviously that searchs between lol.
thanks for any help

[phpster]

WHERE stamp between $date and $date2 AND ...

[annimal]

Thanks for the reply I cant use BETWEEN becouse it dose not include the equel to value
I need
stamp >$date AND stamp <$date2 but the format is not correct.

$query="SELECT event,eventyear,eventstart,totalnt,totalg,ticketsleft,tadult,tchild FROM admin 
WHERE stamp > $date AND stamp < $date2 AND event LIKE '%$superp%'"; 

That looks ok but it dosnt seem to work even if i use =

stamp => $date AND stamp <= $date2 

[phpster]

between does ue the equal value

add quotes, and may format the datestamp into something usable

WHERE date_format(stamp,'%Y-%m-%d') between date_format('$date','%Y-%m-%d') and date_format('$date2','%Y-%m-%d') AND ...

[annimal]

HMM ok im not quite getting this
I have the date being submited to the database as
Saturday June 17 2006

I then format it like so

$Date="Saturday June 17 2006";
$stamp =strtotime("$Date"); 

are you saying that i have to format the date like this

$date =date('Y-%m-%d',$stamp); 

before i can use a query to search the dates?

[annimal]

im still having no luck with this date search i get no errors but no data echoed ether
ive change my script around but still i have no results

$superp="Nativity Play";
$month = "Monday June 12 2003";
$month2 = " Thursday May 24 2007";
$stamp1 = strtotime("$month");
$stamp2 = strtotime("$month2"); 
$date= date('Y-m-d', $stamp1);
$date2 = date('Y-m-d', $stamp2);
include "Co.php";    
$conn = mysql_connect("$location","$username","$password");     
if (!$conn) die ("Could not connect MySQL");     
mysql_select_db($database,$conn) or die ("Could not open database");    
$query="SELECT eventyear,eventstart FROM session WHERE stamp BETWEEN $date AND $date2 AND event LIKE '%$superp%'"; 
$res2 = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); 
$row = mysql_fetch_array($res2); 
while( $row = mysql_fetch_assoc( $res2 )){
echo"Events between dates: $row[event]";} 

thanks for any help