Jump to content

Archived

This topic is now archived and is closed to further replies.

darkcarnival

werid problem with mysql query.

Recommended Posts

hello,

a script of mine that has a login area doesnt seem to like usernames that have or in the name.

like if a user uses toro or coreuser will not let a user log in correctly displaying errors evetywhere.

now my query is simple, the anti-injection function im using i disabled but still seems to cause problems.

if you want to see anything that could help you help me, just let me know and I'll provide it for you.

thanks.

Share this post


Link to post
Share on other sites
try to include the username in the '' quotes like 'toro'

Share this post


Link to post
Share on other sites
here is the query:

[code]"SELECT * FROM ebb_users WHERE Username='$logged_user'"[/code]

$logged_user is either $_COOKIE or $_SESSION(depends on what type of login the user chooses).

the anti_injection script can be found on the code library from this site ;)

Share this post


Link to post
Share on other sites
found the problem, its the anti-injection function i found on this site, if i see the author's email on their profile i might let them know about this problem.

for now I plan to do some research on a replacement to this injection function

any suggestions are fully welcomed :)

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.