Value of MySql Database Field

Hello:
I have a MySql table with a field called MeetingNumber. It is the unique identifier (key) for the table so it adds the next number in sequence each time a record is added. I'm trying to print that value out in a confirmation email that gets sent and have used $MeetingNumber in the email. The email comes up blank though with that value. Any clues what I am doing wrong? The MeetingNumber value shows up in the database when I check it but does not show up in the email. Thanks for any help you can lend.

cdr6800

php? or some other language?

because you need to use php's mysql_insert_id() function to get the value of the auto_increment number that was assigned by the INSERT statement

Hmmm..not sure I understand. Can you be more specific. Thanks for the reply.

Oh..sorry..by the way it is php.

Note that these sorts of queries are actively discouraged now, in favour of their mysqli or PDO alternatives.

Maybe this will illustrate more clearly. I have this statement:

$query = "INSERT INTO AVorder VALUES ('$MeetingNumber','$Date','etc, etc, etc)

$MeetingNumber is the auto increment field. It is showingup in database, but not email. So could you explain how I would use the function you are referring to? Thanks.

cdr6800

You shouldn't be sending a value to an auto increment field when performing an insert.

You need to show the php code where you are generating the email. Your question would also be better targeted at the php forum.

thread moved to php forum