i talked to alex, he said i need to connect to the database in the else statement. I'll try both when the cpanel works again for me, I just need to know about the leader thing though. Like the user who registers the clan, gets their username put into the database, without filling out a line for it: how can I do that?

The problem with MySQL in your script is that you close the MySQL connection before you even do anything to access or modify the database. On, i would assume, line 11, you close the MySQL connection, but on line 18 you try to access the MySQL database with the mysql_query() function—this won't work. Although in PHP you don't have to use mysql_close(), but if you're going to use it, make sure it's at the end—after all other MySQL queries.


I don't think that's possible, unless you want to do the work for them.