A quick Profile Add-on Modification

[SJC]

Quick question. Do you have to add another ,'' at the end of :
mysql_query("INSERT INTO ".$prefix."users VALUES ('', '$username', '$pass1', '$email', '3', '1', '$date', '0', '')");
if you wanted to insert another profile field?

[Bloodrun]

Originally Posted by rainbelly

Cool!

However, I am getting an error on the MySQL:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`aboutme` VARCHAR(5000) NOT NULL,' at line 2

That has to do with how you put it in your database. Each new line has to end with a comma.

Originally Posted by SJC

Quick question. Do you have to add another ,'' at the end of :
mysql_query("INSERT INTO ".$prefix."users VALUES ('', '$username', '$pass1', '$email', '3', '1', '$date', '0', '')");
if you wanted to insert another profile field?

Yes you do, lol don't forget that. It will frustrate you beyond belief. ;)