Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Jun 2009
    Posts
    121
    Thanks
    22
    Thanked 3 Times in 3 Posts

    script to get ID then continue to page.

    I'm sure i'm making this more complicated than necessary, but If someone could help me with this I would VERY much appreciate it.

    I have a button that says to "add job". It adds jobs under a master TicketID since each TicketID can have multiple jobs attached to it. It also points to a php page that is a form to input job information that then inputs into multiple relational databases with the tie in across all these DBs being the JobID which Auto_Increments in the central table when the new job is created. Sorry if that explanation made your head hurt, mines been hurting for over a week sorting all this out.

    I need to somehow start the Data Insert to get the JobID before I open the page so that I can have that JobID to pass when I do the full form insert into the different tables.

    Any ideas? I found a script that uses PHP's mysql_insert_id however I'm concerned that with having multiple Sales Reps in multiple locations, I runt he risk of having conflicting data if two or more are updating at the same time.
    I'll try again to find, the thing that was my mind...
    The only other sign, it says I've lost my mind.

  • #2
    Regular Coder
    Join Date
    Jun 2009
    Posts
    121
    Thanks
    22
    Thanked 3 Times in 3 Posts
    now that i'm thinking about this, could a MOD please move this to the mySQL forum?
    I'll try again to find, the thing that was my mind...
    The only other sign, it says I've lost my mind.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •