Hi all i have a D/B search querying two UNIX time stamps. like this
this works appart from the result i get is not correct!
$query="SELECT event,eventyear,eventstart,totalnt,totalg,ticketsleft,tadult,tchild FROM admin
WHERE stamp <= $date2 AND stamp >= $date AND stamp AND event LIKE '%$superp%'";
the result is -3 dates from $date2 i beleve i need some thing like this
but i cant figure out the correct syntax ive tryed using a BETWEEN query to but obviously that searchs between lol.
<= $date2 AND stamp >= <= $date AND stamp >
thanks for any help