k4pil Posted March 8, 2006 Share Posted March 8, 2006 The below is not workingSELECT * FROM activityWHERE userID = 2 AND WHERE timeBETWEEN 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 activityWHERE WHERE timeBETWEEN 19700101020000 AND 20060606000000AND userID = 2 Quote Link to comment Share on other sites More sharing options...
kenrbnsn Posted March 8, 2006 Share Posted March 8, 2006 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.