Logical Operation in Where Clause

[greenbman]

Ok so I was needing to know if I can do this:

 

SELECT * FROM `accounts` ORDER BY `ctime` WHERE `ctime` >='$time' ASC

 

can I do a WHERE `ctime` >= '$time' ?

 

And how do it? Because when I run this nothing happens.

 

 

Thanks,

greenbman

[Barand]

Check out the syntax of SELECT statements and look at the order of the various clauses. In this case

 

SELECT * FROM `accounts` WHERE `ctime` >='$time' ORDER BY `ctime` ASC

[greenbman]

Thank you works perfectly!