Is this right?

[Adam Black]

ok i have this code but anything after the > next to the 0 gets shown. I took out >0) and then it didn't show anything but like do i need the >0 ????

if (mysql_result($result,0,0)>0) { error ("A user already exists with your chosen userid.\\n".
"Please try another.");

[weirdbeardmt]

That looks like the code in one of the MySQL articles here at Sitepoint. Can you post the code you are using to perform the query to check that is OK?