[SOLVED] Multiple WHERE clause

[[email protected]]

I need to select data from table which has multiple WHERE condition... is it correct

$query_users = mysql_query("SELECT * FROM users WHERE userid NOT IN (SELECT * FROM *table2*) AND datetime > NOW() - INTERVAL 5 MINUTE") or die(mysql_error());

//is my condition correct ?? checking for two WHERE conditions?

[Alex]

I don't see anything immediately wrong with it (Besides the fact that you have * around your table sub-query? Or did you just put that there for the post?); why don't you try it?

[[email protected]]

Thanks Alex, I know what you mean...the reason I wanted to double check is I am working with real data...

 

Also could my LIMIT be user defined??

 

$Var=$_POST['limit'];
$query_users = mysql_query("SELECT * FROM test  LIMIT '".$Var."'") or die(mysql_error());

//its not working...says wrong suntax

[redarrow]

yes LIMIT can be user defined it fine.

[Mchl]

the reason I wanted to double check is I am working with real data...

 

1. There's not much harm you can do with SELECT

2. You should NEVER do any development in production environment! You WILL make a mistake sooner or later. No matter how careful you are, it's just a matter of statistics.

[Alex]

There are no quotes around the limit. I also suggest you at least preform mysql_real_escape_string() on that variable before passing it directly into the query.

 

$Var = mysql_real_escape_string($_POST['limit']);
$query_users = mysql_query("SELECT * FROM test  LIMIT $Var") or die(mysql_error());

 

It's also a bad idea to develop code on a live environment..

[[email protected]]

Thanks Alex & MCHL