Only logged in members can reply and interact with the post.
Join SimilarWorlds for FREE »

Do you have experience with MySQL? I'm stuck!

This page is a permanent link to the reply below and its nested replies. See all post replies »
Invisible · 26-30, M
Yes, what's up?
Magnolia · 31-35, F
@Invisible: I have to write some "simple" procedures & functions for a game but I just don't get it, Invisible. Let me try to formulate a precise question... one sec
Invisible · 26-30, M
Sure, go ahead
Magnolia · 31-35, F
I can't leave anything to be done at the GUI level, it all needs to be done in MySQL, even the exception handling.
A user enters their new (or existing) username into the GUI, the system needs to check whether the name already exists within the system or not. If the username exists then they need to enter their password to gain access. If the username doesn't exist then they need to be asked whether or not they want to create a new account.
I understand the logic but just don't know the syntax.
Invisible · 26-30, M
It's been a while for me, so I may be rusty, but I can give it a crack if you give me your schema
Magnolia · 31-35, F
PM'd you