A2xA Posted October 4, 2008 Share Posted October 4, 2008 In my script it gets the users username and does a.. WHERE userUser = "' . $user . '"'; This works fine for every user except ones that have there usernames start with any number. userUser's mysql info is.. Field Type Collation Attributes Null Default Extra userUser varchar(16) latin1_swedish_ci No It's also stored fine. Just verifying the WHERE is not working. Thanks :-\ Quote Link to comment https://forums.phpfreaks.com/topic/127059-solved-problem-with-usernames-that-start-with-numbers-collation-or-what-type/ Share on other sites More sharing options...
PFMaBiSmAd Posted October 5, 2008 Share Posted October 5, 2008 Have you echoed your query string to see what it actually contains? And why have you cross-posted this question? Quote Link to comment https://forums.phpfreaks.com/topic/127059-solved-problem-with-usernames-that-start-with-numbers-collation-or-what-type/#findComment-657296 Share on other sites More sharing options...
A2xA Posted October 5, 2008 Author Share Posted October 5, 2008 I cross-posted because I didn't know if the problem had to do with mysql or php, and after I posted it here I thought it could've been a php problem, which it was. It had to do with .htaccess Thanks though Quote Link to comment https://forums.phpfreaks.com/topic/127059-solved-problem-with-usernames-that-start-with-numbers-collation-or-what-type/#findComment-657305 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.