Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: what does # do in mysql string ?
11-12-2013, 09:17 AM #1
- Join Date
- Oct 2009
- Thanked 3 Times in 3 Posts
what does # do in mysql string ?
I am trying to find the next entry in one of the fields in my table after an entry with '#3' (without quotes) in it. But it keeps returning some other entry in the table and not the one after '#3'
I feel it is something to do with the # but can not find anything on it.
This is the sort of query i am using..
SELECT * FROM `mytable` WHERE `myfield` > '" . $mysqli->real_escape_string($string) . "' ORDER BY `myfield` ASC LIMIT 1
11-12-2013, 08:44 PM #2
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.