I thought I had the answer to this one.
On my 'register your details' page I have a login name. When submitting a new users details to mysql, I find that you can use the same username with different caps. ie: Toby or toby.
I have this code to check if the user ids match and it is not throwing an error when different caps are used:
Code: Select all
$query = "SELECT * FROM members WHERE loginid = '".$loginid."'";
$result = mysql_query($query);
if (mysql_num_rows($result) > 0) {
echo "<h1>Sorry</h1><br>That login name has been taken.";
exit;Are there any wildcards or other mysql querys I can use?
Thanks for helping.