how can i store random values of a table in an array

chrianne29

I just want to seek advice from you guys. I just want to store the random values of a table and then store it in an array. Then I will use the array to generate another table again. please reply thanks.

dagon

db table? you may not need to put the results into an array, you can read from one table and write to another in a single query. Assuming mysql -

12.2.5.1. INSERT ... SELECT Syntax

chrianne29

dagon;10959084 wrote:
db table? you may not need to put the results into an array, you can read from one table and write to another in a single query. Assuming mysql -

12.2.5.1. INSERT ... SELECT Syntax

thanks, but it is a html table but i used mysql query to select the random records and output it in a html table. My table will have company id and company name as table header and then the user will input on how many records he/she wants to see. The records will have a random arrangement base on how many records the user will input. I just want to use the random company id that the program will output in a html table and then use it again to output a new html table. is there anyway I can do this??

dagon

sorry, i don't follow what you need help with or what your trying to achieve.

chrianne29

dagon;10959152 wrote:
sorry, i don't follow what you need help with or what your trying to achieve.

Ok.. Here what I want to do.. I'm creating a online reports generating system. The system will have 3 input fields( 2 select and 1 textbox) and a random button. The user will input the required fields and then press the random button. After pressing the random button, it will output a html table. It will display the random company id and company name. I just want to know if there is anyway I could store the company id in a variable or an array because I will use it again to generate another table again.

dagon

well you have the id your outputting retuned from the db?