Creating master-detail page using PHP

[micmola]

I want to create a master-detail page using PHP. Rather than getting data from a MYSQL database, I want to get the data from an associative array. Is this possible? Please someone show me the way forward. Please help.

 

[Maq]

I want to create a master-detail page using PHP. Rather than getting data from a MYSQL database, I want to get the data from an associative array. Is this possible? Please someone show me the way forward. Please help.

 

Sure it's possible, but why would you want to do that?  If you want help, then provide an example and some relevant code.

[micmola]

Alright, thanks for your reply. Your question led me to review other options I had. I noticed that I can create VIEWS in mysql, rather than creating an associative array.

 

My new challenging question is this:-

 

I have a master-detail page in php linked with a mysql database. Each time a user searches for something, a VIEW is created in mysql. The VIEW in mysql will be further processed using a query, and the results of this query will now be displayed in the master-detail page.

 

There will be many users using the system hence many VIEWS will be created. When is it best to drop the VIEW from mysql. If I drop the VIEW immediately after performing my query, will the master-detail page still show information required?