Hi,
I have a php script that creates a table with multiple rows, then populates the cells with data from a query to a MySQL database in a while loop. I can set this up no problem, however, I don't want ALL the data from the DB to be displayed initially; instead i want a link created, that when clicked, another window pops-up with the relevent information. So basically, every row created, will have a "click here" link as well other database information.
Someone suggested making this "click here" link into a Submit Button...so when it is pressed it queries the database for the needed info.
Now the hard part...How do I nest that query within my while-looped query? And how do I make sure that the nested query is getting the information that is relevant to the initial query.
God I hope that makes sense!
Any suggestions?
Thanx
I have a php script that creates a table with multiple rows, then populates the cells with data from a query to a MySQL database in a while loop. I can set this up no problem, however, I don't want ALL the data from the DB to be displayed initially; instead i want a link created, that when clicked, another window pops-up with the relevent information. So basically, every row created, will have a "click here" link as well other database information.
Someone suggested making this "click here" link into a Submit Button...so when it is pressed it queries the database for the needed info.
Now the hard part...How do I nest that query within my while-looped query? And how do I make sure that the nested query is getting the information that is relevant to the initial query.
God I hope that makes sense!
Any suggestions?
Thanx