Jump to content

Using variables in a hyperlink to specify a query


Recommended Posts

Hi all.I'm creating this database manager, used for adding billing info to a database and asign components to them. It's became quite the dynamic page with frames, forms, loops (also used to create a dropdown box) and nested IF's. Now I'm writing a script to display all that info.So I have tables called bills, components and suppliers. My new page shows all billing info using a loop (even rows in blue, odd colors in yelow) but now I'd like to turn the bill reference number into a link to display all components asigned to that bill.The components table also contains the billing number, along with the component details, so I guess I have to create a hyperlink that contains the variable's value, linking to a script that fetches the info and makes a query to the components table in order to retrieve the component details.So let's see... the query to the billing table is something like this:

$query="SELECT * from BILLS";

The billing number is defined as $bnin (internal billing code) and printed using a familiar loop.The new script, which I need to link to, will have to make a query to components:

$query="SELECT * from COMPONENTS where BNIN=(output for $bnin)";

Any ideas anyone? This would be a great help.

Link to comment
Share on other sites

Never mind, I found a tutorial on propagating and retrieving variables. Well, actually it is a tutorial on sessions but it also shows how 'tiresome' it would be to propagate everything.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...