Re: [Phphelpdesk-help] Ticket # in receipts

[Matt G. <ma...@ma...>]

I think I found out how it works here.  The mysql command includes 
LAST_INSERT_ID() as what is to be placed into the t_id field of the 
event.  This is interpreted by mysql as a command to just replace 
LAST_INSERT_ID() with whatever was the last id of the last record added.  I 
don't believe this is a good idea, but I could be wrong.  Under heavy 
volume, two tickets could be entered near-simultaneously.  Unless the 
LAST_INSERT_ID() function is only for the user that is logged into mysql at 
that time for that session only.  So the code never knows what the ticket 
id is.  It just tells mysql to look up the last ticket id that mysql just 
created, and use that.  However I believe there is a way to find it.

Matt

At 09:25 AM 11/8/2001 -0500, you wrote:
>Has anyone been able to get the Ticket# to come through in the email
>receipts to the client?
>I have tried adding the $t_id variable in several places to no avail.
>
>
>
>Mitchell K. Smith
>Service and Information Systems Manager
>ePlus Technology of PA
>130 Futura Drive
>Pottstown, PA  19464
>610-495-7800 ext. 264
>mk...@pa...
>
>
>
>_______________________________________________
>Phphelpdesk-help mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help