[lymia]

Hi

Trying to find some help with a custom cms I am using, I need it to make forum accounts aswell for site but finding it really hard

here is some of the code I think needs to be changed

PHP Code:

$query=mysql_query("SELECT displayname FROM forum_accounts WHERE displayname='".$_POST['nick']."'");

            if (mysql_num_rows($query)!=0) {

                $haserrors .="Display Name already exists 

PHP Code:

$queryb=mysql_query("INSERT INTO forum_accounts(id_account,location,showlocation,bday,showbday,signature,enableemail,gmt,webpage,fname,

            lname,passask,passans,city,aim,msn,yahoo,skype,icq,enablepm,template,displayname,lastlogin,activation, gender) VALUES(LAST_INSERT_ID(),'".$_SESSION['CA_lo']."', 

I have tried replacing the forum_accounts to phpbb_users but gettin alot of errors


Any help would be appreciated

[Keith]

You will have to be more specific than gettin alot of errors.

[lymia]

Sorry forgot errors

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in \htdocs\inc\account\account.create.php on line 73

Unknown column 'city' in 'field list'

[UnrealEd]

I'd say it's pretty clear: you're trying to insert a value into a field that doesn't exist in that table

[xEX3CUT1ONx]

In your table 'forum_accounts' your missing a field for City, try adding the field in your Sql and try it again