calmchess Posted May 29, 2013 Share Posted May 29, 2013 (edited) I'm stuck on this mysql condtional delete statment. I want it to delete the row where _roomid='$roomid00:::$roomid00:::$roomid00:::$roomid00' which works fine but I want it to exclude the row that contains _roomid!=roomx:::roomx:::roomx:::roomx I can't use the two statments togeather not sure why. How do I use AND in my sql statement? $q5=mysqli_query($conn5,"DELETE FROM logged_in_users WHERE _roomid='$roomid00:::$roomid00:::$roomid00:::$roomid00'AND _roomid!=roomx:::roomx:::roomx:::roomx")or die(mysqli_error($conn5)); Edited May 29, 2013 by calmchess Quote Link to comment Share on other sites More sharing options...
DaveyK Posted May 29, 2013 Share Posted May 29, 2013 use quotes around the second variable as well? How in the world are you storing thing 0_0 Quote Link to comment Share on other sites More sharing options...
Solution calmchess Posted May 29, 2013 Author Solution Share Posted May 29, 2013 yeah that worked I thought because it was already a string it didn't need quotes....guiss I was wrong.....thanks for your help. --calmchess 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.