Query, Identify, and layout?

Discussion in 'MySQL' started by Matt Ridge, Sep 29, 2011.

  1. #1
    Ok, I have a noobish question, but as some people here know I have been working on creating a form to enter data into a database, which now works exactly as I want it to due to the people's great help here.

    http://www.kaboomlabs.com/PDI/ncmr.html

    I now have the info required into the database, I am now attempting to write up a query that once run will put a form together with the outputted data. In said format.

    The only way I can think of doing it is if I have a form created originally that shows the ID number, and once you click it, it sends to you to an identical form which instead of allowing input will allow output of said form.

    form # "Test NCMRID" is the ID, and I want the query to push all the info of that query to be published.

    Is it possible?

    So in english:

    Page 1, list of ID numbers with a general description of each, with a link to see the form.
    Page 2, the outputted form, which looked identical to the input form, but no data is imputable.

    I don't want the entire thing written for me, just an example. Sort of like this: $NCMR_ID is the ID field, the only thing in it is Test NCMRID, another field is $Added_By; I just want it to show that the name that correlates with the ID number will push out the right name, after a link is pushed.

    I hope I've made myself clear... any help would be appreciated.
     
    Last edited: Sep 29, 2011
    Matt Ridge, Sep 29, 2011 IP