register page error message

GeorgeInFlorida

I hope I am posting this in the correct place. (this is my first post) and I know very little about PHP. I am trying to build a community based website, and allow people to register as members. I have the registration page complete, and I believe it is working, as I had to fix a few things in the form, but now I am getting this error message, and I don't understand. Any help would be greatly appreciated. The error points to line 162 in the code which is: mkdir("members/$id",0777); adn this is the error. The lines of code pertaining to sending the user a verification email are also indicating errors, but I suspect they are a result of this one.

Parse error: syntax error, unexpected T_STRING in /home/content/91/9543591/html/thecentralfloridascene/register.php on line 146

Any help would be greatly appreciated, as I am stuck in the water at this point until I can resolve this.

GeorgeInFlorida

Sorry, I should have said points to line 146. I guess I hit the wrong numbers on the keyboard, sorry

bradgrafelman

The error is not on line 146. The error is probably somewhere in the preceding statement.

GeorgeInFlorida

Thanks Brad, you were exactly right. I left out a quotation mark, and end parentheses. Now I only have one error, and I hope it is the last. Any help with this?

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/content/91/9543591/html/thecentralfloridascene/register.php on line 64
Column count doesn't match value count at row 1

bradgrafelman

You're executing a SQL query somewhere (I'm guessing it's an INSERT) where the number of values given doesn't match the number of columns specified.

GeorgeInFlorida

forgot to put the code in
$sql_email_check = mysql_query("SELECT email FROM scenemembers WHERE email='$emailCHecker'");
This is row 64 $email_check = mysql_num_rows($sql_email_check);

Weedpacket

[man]mysql_error[/man] will give the reason why MySQL rejected the statement.

GeorgeInFlorida

Ok, it's the idiot again, I fixed the above mentioned error, only to get this one now. I don't have a clue what it means. Can anyone point me in a direction?

Column count doesn't match value count at row 1

bradgrafelman

See my previous reply:

bradgrafelman;11016535 wrote:
You're executing a SQL query somewhere (I'm guessing it's an INSERT) where the number of values given doesn't match the number of columns specified.

GeorgeInFlorida

Ok, fixed all the issues associated with this request. Thank you to everyone that helped me. Now on to more errors. LOL