Here is the page for the information on this function:
http://www.php.net/manual/en/function.mysql-insert-id.php
mysql_insert_id() being a function, the () after the name are necessary.
HTH
Maureen
Kenn Murrah <[EMAIL PROTECTED]> said:
> I'm sorry to be so obtuse, but I still don't get it ...
>
> I've tried:
>
> $sql = "INSERT INTO orders set products_ordered='$products',
> ordered_by='$username', company='$company', address_1='$address_1',
> address_2='$address_2', city='$city', state='$state', zip='$zip',
> attn='$attn', special_instructions='$special_instructions',
> shipping_instructions='$shipping_instructions', status='$status',
> rush='$rush', date_ordered='$current_time' , month_due='$month_due',
> day_due='$day_due'
> " ;
>
> $result = mysql_query($sql) or die("ERROR -- try again111111 or see Kenn
> Murrah");
>
> $order_number=mysql_insert_id;
>
>
> .... and I'm still not getting a value for $order_number, the
> auto-incremented value.
>
> I'm REALLY sorry to waste the list's time with this ... but I do appreciate
> the help from all of you ...
>
> Kenn
>
>
> ----- Original Message -----
> From: "Brunner, Daniel" <[EMAIL PROTECTED]>
> To: "'Kenn Murrah'" <[EMAIL PROTECTED]>
> Cc: "PHP List (E-mail)" <[EMAIL PROTECTED]>
> Sent: Thursday, August 16, 2001 12:39 PM
> Subject: RE: [PHP-DB] determining the value of an auto-incremented field
> (mysql)
>
>
> | Say...
> |
> |
> | You can us it after you do your insert...then ....do something like.....
> |
> | echo ("<B>Your new Order Number is") . mysql_insert_id . (" Please
> | write this down</B>n");
> |
> | Your whatever you want.....
> |
> |
> | Dan
> |
> |
> |
> | > ----------
> | > From: Kenn Murrah
> | > Sent: Thursday, August 16, 2001 12:29 PM
> | > To: Brunner, Daniel
> | > Subject: Re: [PHP-DB] determining the value of an
> | > auto-incremented field (mysql)
> | >
> | > thanks, Dan ... i'll RTFM now to figure out exactly how to use it ...
> | >
> | > and thanks again for your prompt response ...
> | >
> | > Kenn
> | >
> | >
> | >
> | > ----- Original Message -----
> | > From: "Brunner, Daniel" <[EMAIL PROTECTED]>
> | > To: "'Kenn Murrah'" <[EMAIL PROTECTED]>
> | > Sent: Thursday, August 16, 2001 12:25 PM
> | > Subject: RE: [PHP-DB] determining the value of an auto-incremented
> | > field
> | > (mysql)
> | >
> | >
> | > | Hello!!
> | > |
> | > |
> | > |
> | > | mysql_insert_id()
> | > |
> | > |
> | > | Dan
> | > |
> | > |
> | > |
> | > | > ----------
> | > | > From: Kenn Murrah
> | > | > Sent: Thursday, August 16, 2001 12:17 PM
> | > | > To: [EMAIL PROTECTED]
> | > | > Subject: [PHP-DB] determining the value of an auto-incremented
> | > | > field (mysql)
> | > | >
> | > | > Greetings:
> | > | >
> | > | > A no doubt elementary question, but ....
> | > | >
> | > | > using PHP and MySQL, I'm inserting a record into a table, with a
> | > | > field,
> | > | > order_number, being auto incremented ... something like:
> | > | >
> | > | >
> | > | > $sql = "INSERT INTO orders set products_ordered='$products',
> | > | > ordered_by='$username', company='$company',
> | > address_1='$address_1',
> | > | > address_2='$address_2', city='$city', state='$state', zip='$zip',
> | > | > attn='$attn', special_instructions='$special_instructions',
> | > | > shipping_instructions='$shipping_instructions', status='$status',
> | > | > rush='$rush', date_ordered='$current_time' ,
> | > month_due='$month_due',
> | > | > day_due='$day_due'
> | > | > " ;
> | > | >
> | > | > $result = mysql_query($sql) or die("ERROR -- try again");
> | > | >
> | > | >
> | > | >
> | > | > Having done so, how can I immediately determine the value of
> | > | > order_number
> | > | > for this entry, i.e. the auto-incremented value assigned by MySQL?
> | > | >
> | > | > Thanks in advance for the help.
> | > | >
> | > | > Kenn Murrah
> | > | >
> | > | >
> | > | >
> | > | >
> | > | > --
> | > | > 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]
