I don't know about SQL server 7.  However, when using MySQL (as indicated by
your code), it will work.
For instance, if your table is:

CREATE TABLE mytable (
myID int unsigned auto_increment,
value2 int unsigned,
value3 char(50)
)

Then this will automatically increment myID:
INSERT INTO mystable VALUES(NULL,123,"A text string");
INSERT INTO mystable VALUES(NULL,456,"A text string");
INSERT INTO mystable VALUES(NULL,789,"A text string");

-----Original Message-----
From: Ricky Theil [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 29, 2001 3:12 PM
To: 'Rick Emery'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] HELP PLEASE!! Get query error when inserting into
My Sql


I was never able to assign a null value to get a row to automatically insert
into SQL server 7.  It would always give me an error that said something
like "you cannot assign the value NULL to an identity field."

-----Original Message-----
From: Rick Emery [mailto:[EMAIL PROTECTED]] 
Sent: Monday, October 29, 2001 10:46 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] HELP PLEASE!! Get query error when inserting into My
Sql


This also works:
INSERT INTO vcstats VALUES( NULL,column2,column3,column4,column5)

The NULL value will be replaced with theauto-incremented value in the table
-----Original Message-----
From: Ricky Theil [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 29, 2001 10:26 AM
To: '[EMAIL PROTECTED]'; Robby Whiteside; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] HELP PLEASE!! Get query error when inserting into My
Sql


If your first field is an auto insert field, then you have to do it like
this:

insert into tablename (column2,column3,column4,column5) values
(value2,value3,value4,value5)

The auto incremented field will be automatically be filled in with the next
available value.

Ricky

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Monday, October 29, 2001 9:24 AM
To: Robby Whiteside; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] HELP PLEASE!! Get query error when inserting into
MySql


If any of the values you are trying to insert are not integers, you need to 
put single quotes around the variables, ie. $SCRIPT_NAME, $date, $BName, etc

in the insert statement.


Robby Whiteside <[EMAIL PROTECTED]> said:

> Hi There,
> 
> I have a query whenever I try to insert something into a mysql table.
> This
is 
> the code I am using:
> <?
> 
> $host1 = gethostbyaddr("$REMOTE_ADDR");
> $date = date("Y-m-d h:i:s");
> $link = mysql_connect("$host", "$user", "$passwd");
> mysql_select_db("$database", $link); $sql = "INSERT INTO vcstats 
> VALUES('', $SCRIPT_NAME, $date,
$HTTP_USER_AGENT, 
> $BName, $BVersion, $BPlatform, $REMOTE_ADDR, $host1)"; $result =
> mysql_query($sql) or die("query error<Br>" . mysql_error()); 
> mysql_close();
> 
> ?>
> 
> Thanks,
> Robby
> 
> ---------------------------------------------
> This message was sent using Endymion MailMan.
> http://www.endymion.com/products/mailman/
> 
> 
> 
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: 
> [EMAIL PROTECTED]
> 



-- 




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to