How to pass data from one SQL to another

  • I am trying to pass a piece of data that I extract from one SQL script to another. I will explain the concept in pseduo code as the PHP script is rather convoluted. If this doesn’t work I’ll add the script. I know SQL, but am not a good PHP coder.

    First SQL:
    Select date, month from schedule where …

    A FORM that other data is entered in

    Second SQL, needs to use the month from the first SQL and the data from the form to build an INSERT statement to update the database.

    I can do everything, issue the form, collect the data, build the insert statement and update the database. What I can not figure out is how to pass the month from the first SQL to the second. I suspect it has to do with bouncing back and forth between PHP and HTML but I hope there is a way.

    Thanks for your help.

    Rick

Viewing 1 replies (of 1 total)
  • Thread Starter rjmman

    (@rjmman)

    I’ve tries $_SESSION, POST, GET, but can not figure out how to capture the month from the first SQL and save it to be passed and used in the second SQL.

Viewing 1 replies (of 1 total)
  • The topic ‘How to pass data from one SQL to another’ is closed to new replies.