Could not check username error, php & mySQL

[ErraticFox]

Hello, for some reason everytime I register on my website, I get "Could not check username" no matter what I use. I'm sure it might be a spelling mistake(?) but I've looked through everywhere and couldn't find it.

Here's my snippet:

if(isset($_POST['username'])){ }
	
	$username = $_POST['username'];

$username = preg_replace("#[^0-9a-z]#i","",$username);

$user_query=mysql_query("SELECT username FROM members WHERE username='$username'LIMT 1") or die ("Could not check username");

(Again, this is just a snippet of my php)

[Dormilich]

well, obviously your SQL query fails. that’s the only place that can trigger your error message.

[Exequiel]

ON YOUR QUERY IN LINE No. 7 replace it by this code.

$user_query=mysql_query("SELECT username FROM members WHERE username='$username' LIMIT 1") or die ("Could not check username");

the error there IN YOUR CODE is that you don't put space between this - username='$user name'LIMT 1 it must be username='$user name' LIMIT 1 AND ALSO WRONG SPELLING OF LIMIT.