URGENT HELP NEEDED VERY SIMPLE BUT I AM STUCK :(

[cobracommander]

Hello Everyone,

 

I am trying to accomplished this first. I have php file.. where visitors comes and i track there ip and current visit time... and push that into database mysql

 

under  logs table -- > time and ip coloumn also with this. I place counters = 2. in counters table in there..

 

$sql="DELETE FROM logs WHERE counters='2'&& (. (time() - 60) . ' >= `time`')";
$result=mysql_query($sql);

if successfully deleted
if($result){
echo "Deleted Successfully";
echo "<BR>";

 

In above code. I want to match two conditions  if counters =2 met  and if current time subtract 60 seconds  and if that is equal or greater then the time in database. it should delete other wise not...

 

well if i remove  after && (. (time() - 60) . ' >= `time`') then it works only matching counters or if i delete counters it works. so where i am stuck..

 

can any1 really help me

[Maq]

Do you get any errors?  Add this:

$result=mysql_query($sql) or die(mysql_error());

 

Echo out your query.

[awjudd]

You are mixing PHP and your query without actually swapping.

 

$sql="DELETE FROM logs WHERE counters=2 AND " . (time() - 60) . " >= `time`";

 

~awjudd