PHP to MySQL INSERT problem

rr1024

Hello Everyone,

I have a Members System and I just installed a forum, visitors do not have to join the CMS system to post in the forum and Member System Users. However, I want to auto register the Members System Users into the forum without getting things mucked up.

I must keep the passwords, nicknames and email address the same in both data bases and they do have the ability to change all three in the members system.

In the forum the autoincrement SQL ID number is called user_id
In the members system the autoincrement SQL ID is called ID, so what I want to do is this.

Create a constant for my Members system, lets say

DEFINE("FORUMCNSTID",  500000, FALSE );

In my script I'll get the Members System ID Number, lets say he is ID 1

$msID = 1;

and this is the first time he clicked on the link to this interface script so we must register him as new user in the forum script.

I'll have a little function that checks to see if $masterID = $msID + FORUMCNSTID; is in the data base.
The answer is false so I now want to insert him and his email, password, nickname and most import his forum ID i.e. user_id which I want to be $masterID

However, when I do the PHP data base INSERT I get an error on the ID field user_id.

So, Can you incert a number into an auto increment field that is set to be indexed or do I have a probably script error?

FatalError

rr1024 wrote:
So, Can you incert a number into an auto increment field that is set to be indexed or do I have a probably script error?

Yes you can. You probably have an error in the SQL statement. Show me the statement you are using.

rr1024

The issue seems to be if I pull the userid and '$ia_arr[ID]' out it seems to insert everything just fine but as soon as I add the userid field it doesn't insert at all and
$res1 is empty.... $res is doing another insert into another data base is has the same probme with the ID field.

 
$res1 = db_resST( "INSERT INTO `user`   (
                                                           `userid`,
                                                           `username`,
                                                           `password`,
                                                           `zip`,
                                                           `email`,
                                                           `lastvisit`,
                                                           `groupin`

                                                  )
                                            VALUES
                                                  (
                                                       '$ia_arr[ID]',
                                                       '$ia_arr[NickName]',
                                                       '$ia_arr[Password]',
                                                       '$ia_arr[zip]',
                                                       '$ia_arr[Email]',
                                                       '$date_time',
                                                       '2'
                                                  )"
                          );
        if ( $res OR $res1 ) {
             return true;
        }else{
             return false;
        }

The function for $res is my db.inc.php file has been unchanged and worked great for long time but if seeing the function helps...

It seems too weird because when one installes a new db with a php script it will need to insert data including indexed ID fields....mmmm

FUNCTION db_resST( $query, $error_checking = 1 )
{
    GLOBAL $MySQLST;
      $code = 103;

    if ( !DEFINED( 'DB_VERM' ) OR  DB_VERM == 0 )
         $res = @mysql_query( $query, $MySQLST->link );
    else $res = mysql_query( $query, $MySQLST->link );

    if ( $error_checking && !$res ) {
         $sqlerr = $_SERVER["PHP_SELF"]." : ". mysql_error();

         $msg = error_messageST( $code, $query, $sqlerr , "db_resST" );

         if ( !DEFINED( 'DB_VERM' ) OR  DB_VERM == 0 ) {# Only send mail when not in debug mode
              //mail( BUG_REPORT_EMAIL, "Error ". $code, "Error in $_SERVER[PHP_SELF]: " . $sqlerr );
              dbPostOfficeST( $msg, "dBase Error Report" );
              PrintErrST( $msg , "MemberPageDisplay");
         }
         if ( DB_VERM == 1 ) echo PrintErrST( $msg , "VERM");

      EXIT();
    }
    if ( DEFINED('DB_VERM') AND DB_VERM == 2 ) {
         $msg = error_messageST( $code, $query, "DB_VERM_QUERY = TRUE in header.inc.php" , "db_resST" );
         echo PrintErrST( $msg , "VERM");
    }
RETURN $res;
}