[SOLVED] Delete MySQL range

[[email protected]]

How to delete a range of table rows where

id=1 to 100

 

  $query = mysql_query("DELETE FROM all (id) VALUES (//range here ??)") or die(mysql_error());

[joel24]

DELETE FROM *table* WHERE id BETWEEN 0 AND 101

[[email protected]]

Thanks Joel..

 

Also I need to pick some accounts between a datetime range of last 5 mins..this is what I got.

 

$timenow = time();
$fiveminsb4 = $timenow - 300;
$query_users = mysql_query("SELECT userid FROM *table* WHERE datetime BETWEEN '".$timenow."' AND '".$fiveminsb4."')");

//is there a better logic??

 

[joel24]

you can do it all in mysql, without PHP. also you don't need between... now is the max time, so use greater than

$query_users = mysql_query("SELECT userid FROM *table* WHERE datetime > NOW() - INTERVAL 5 MINUTE");

 

[[email protected]]

Thanks

 

I also have error which picking user input variable...

 

$Var=$_POST ['Variable']
$query_users = mysql_query("SELECT * FROM users WHERE userid='".$Var."')") or die(mysql_error());

//Why is it not working

[Alex]

You have an extra ) in the query.

[[email protected]]

Thanks