calmchess Posted May 29, 2013 Share Posted May 29, 2013 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)); Link to comment https://forums.phpfreaks.com/topic/278568-mysql/ 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 Link to comment https://forums.phpfreaks.com/topic/278568-mysql/#findComment-1433045 Share on other sites More sharing options...
calmchess Posted May 29, 2013 Author 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 Link to comment https://forums.phpfreaks.com/topic/278568-mysql/#findComment-1433049 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.