mysql_num_rows?

[lonebyrd]

I'm trying to make this code so that if certain fields were not filled in, it would return a message. But my login screen that I am making keeps coming up with an error message: 'Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/lonebyrd/public_html/registration.php on line 83'. I'm thinking it has to do with the mysql_num_rows because that is in every line the errors are in, but I don't know how to fix it.

$nameq = "SELECT name FROM registration WHERE username = '$name' LIMIT 1";
$emailq = "SELECT email FROM registration WHERE email = '$email' LIMIT 1";
//put errors into an array I need to change these if I change the db
$errors = array();
if(empty($name)) {
$errors[] = "The name field was blank! <br />";
}
if(mysql_num_rows(mysql_query($nameq)) > 0) {
$errors[] = "The name given is already in use! Please try another one! <br />";
}

if(empty($email)) {
$errors[] = "The email field was blank! <br />";
}
if(mysql_num_rows(mysql_query($emailq)) > 0) {
$errors[] = "The email given is already in use! Please try another one! <br />";
}

if(mysql_num_rows(mysql_query($nickname))>0) {
$error[] = "That nickname is already taken. Please try another one.<br />";
}

if(empty($password)) {
$errors[] = "The password field was blank! <br />";
}
if(count($errors) > 0) {
foreach($errors as $err) {
echo $err;

[laserlight]

What is $nickname?

[lonebyrd]

umm... Well, I wanted in my registration/login a place for people to put up a nickname, so thats what I thought I needed to put in the script. Does it have to specifically be called something, like username or something, because i really wanted it to be nickname to be more friendly-like.

[Blulagoon]

I think what LaserLight means is you aren't defining an SQL query as $nickname as you do with $nameq and $emailq at the top of the script.

Blu

[lonebyrd]

Ahh, ok. I fixed that problem. But now I am getting this error message: 'Parse error: parse error, unexpected '\"' in /home/lonebyrd/public_html/registration.php on line 82' I don't understand it. I dont have a \ in that line, which is the first line from above.

[laserlight]

There must be some other error then, perhaps on a line before that.

[Houdini]

Show line 80 and 81, line 82 is where there error showed up, in the preceeding line you might have missed a semicolon or other error that you have overlooked..