quick database syntax query

[k4pil]

The below is not working

SELECT *
FROM activity
WHERE userID = 2 AND WHERE time
BETWEEN 19700101020000
AND 20060606000000

Im am trying to get all rows where userID is 2 and time is between those two numbers.

Any help?


ive somehow solved it by rearranging -

SELECT *
FROM activity
WHERE WHERE time
BETWEEN 19700101020000
AND 20060606000000
AND userID = 2

[kenrbnsn]

Remove the second "where":
[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] * [color=green]FROM[/color] [color=orange]activity[/color] [color=green]WHERE[/color] userID [color=orange]=[/color] 2 [color=blue]AND[/color] time BETWEEN 19700101020000 [color=blue]AND[/color] 20060606000000 [!--sql2--][/div][!--sql3--]

Ken