Jump to content

Submit via drop down to re query


danoli

Recommended Posts

Hope the subject made a little sense...

I am trying to build a page that uses a drop down to select a student from a table.
When the student is selected, I want the students username to be resubmitted to the same page to start another query that then builds the table of data to be displayed. Then selecting a different student will display the different data set.

I have it working without the dropdown. A student visits the page and a session variable $USERNAME is used to query the database building the table for the signed in student.  I just need to get my had round the submit in the dropdown.

This is how I see it working schematically

[code]Top
Is a 'dropdown' variable set
If yes,
  use it to query database and build table
  clear dropdown variable
Display dropdown (which uses another query to get list), wait for a selection, set 'dropdown' variable and resubmit the page
Goto top.[/code]

If only scripting/programming was that easy :)

Any tips or pointers to simillar code appreciated
Link to comment
Share on other sites

  • 3 weeks later...
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.