Search the Community
Showing results for tags 'php sql arrays loops'.
Found 1 result
-
I'm wondering how to populate array(s) with data retrieved from an SQL database and outputting this into a HTML table. I'm using the following table structure CREATE TABLE PROJECT_RECORDS ( RECORDS_ROWID number(3) not null, RECORDS_LISTCOLUMNID number (3) not null, RECORDS_RECORDVALUE varchar2 (25), constraint PROJECT_RECORDS primary key(RECORDS_ROWID, RECORDS_LISTCOLUMNID)); Sample Data RECORDS_ROWID RECORDS_LISTCOLUMNID RECORDS_RECORDVALUE ------------- -------------------- -------------------- 1 1 Sample 1 2 Sample description 2 1 Data 2 2 Data Description From this I want to populate a html table e.g. |Sample | Sample description | |Data | Data Description | I have currently only been able to select the data and place into a single array with all of the RECORDS_RECORDVALUE into a single table column which isn't what I want. I believe you would populate an array using a loop for each RECORDS_ROWID and then echo this into a table. Any help would be greatly appreciated.