some help needed with MySQL Plugin

[drummernath]

hi, i have finally managed to connect to my users database and also send a query to retreive;

username, password, name, email

users = MySQL.QueryToTable("SELECT id, username, password, name, email FROM userbase_users");

but how on earth do i search for a username in the table, then find the password that belongs to that username then check if it matches the ones entered in username and password textboxes and if it does jump to the next page where the name is required to greet the user, i am using MySQL Plugin

any ideas, thanks

[jassing]

Using your query 'as is' you'd need to scan thru the resulting table...
the 'right' way would be to use SQL to find it.

SELECT id, username, password, name, email FROM userbase_users where username="josh"

[drummernath]

thanks, i was up all last night and got it to work now, thanks

[rexzooly]

Sorry i was not around to help lol whoms plugin are you using?
I am back online now so i see you on msn and i help on whatever i can lol
GOD i messed been on here lol i hate BT lol.

[drummernath]

hi, i got it working but still need help with other problem im new to custom mysql so i have yet to learn but so far im liking it.