hey guys,
i am starting to learn this sql stuff and i have few problems.
One, who can i see if the user with that name already exsists. Like someone submits his info to me and I have to check if that nickname is available. So how do i check it in mysql? lets say in prticular column 'nickname'.
Two, is there any restriction on the lenght of a string? can I have several thousand characters?
three, what is the difference between VARCHAR(??) and TEXT?
four, when I submit something through <input> field, it get slash followed by any special or reserved symbol. eg "i can\'t do it" how can I get rid of it?
thankey for your time and help,
cheers
------------------------------------------
What is difficult takes time, what is impossible takes a little longer
i am starting to learn this sql stuff and i have few problems.
One, who can i see if the user with that name already exsists. Like someone submits his info to me and I have to check if that nickname is available. So how do i check it in mysql? lets say in prticular column 'nickname'.
Two, is there any restriction on the lenght of a string? can I have several thousand characters?
three, what is the difference between VARCHAR(??) and TEXT?
four, when I submit something through <input> field, it get slash followed by any special or reserved symbol. eg "i can\'t do it" how can I get rid of it?
thankey for your time and help,
cheers
------------------------------------------
What is difficult takes time, what is impossible takes a little longer