PHP and Ajax Form Field Validation

I'm running into a problem with the field validation, maybe someone can point me in the right direction on what i'm doing wrong.http://rafb.net/p/7DFk2h52.html is my registration pagehttp://rafb.net/p/SZVUAN80.html is the username check php page.
When I run it, it returns a sql error.

Second page is wrong:
PHP Code:



include("config.php"); ÂÂ*ÂÂ*ÂÂ*$q= mysql_escape_string($_GET["q"]);ÂÂ*ÂÂ*ÂÂ*ÂÂ*$sql = mysql_num_rows(mysql_query("SELECT username FROM 'users' WHERE `username` = '$q'")) or die (mysql_error()); // mySQL QueryÂÂ*ÂÂ*ÂÂ*ÂÂ*if ($sql > 0) {ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*echo("<font-color=\"red\">Username Taken</font>");ÂÂ*ÂÂ*ÂÂ*ÂÂ*} else {ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*echo("<font-color=\"Green\">Username Available</font>");ÂÂ*ÂÂ*ÂÂ*ÂÂ*}mysql_close($db_connect);




Take this as an example and see if you can use it:http://awesomephp.com/?Membership-2
Peace,





__________________NEW: What Is Their IP - Anyone's IP a click away.
URL Tracker, Shortener, Blocker, Unblocker, Whois and More.

why are you putting '' around table users either remove them or use ``
PHP Code:



$sql = mysql_num_rows(mysql_query("SELECT username FROM `users` WHERE `username` = '$q'"))











__________________Hicham MallahWeb Developer