![]() ![]() This will slice up a database request into even or variable row counts. Here is the rough–working–cut of the code for this project. It would be helpful if anyone recognizes this and can suggest changes before I proceed to attempting the code. An edit field allows the column variables to be changed and SAVE button or some such device reloads the page displaying the new record count for each column). Note: Fieldnames returned from this function are case-sensitive. Use ‘some kind of conditional statement’ to adjust number of records assigned to each column with variable #3 at location #4 when the variable is changed and the page is reloaded (EG, page is displayed with 25 records each column. The fetchassoc () / mysqlifetchassoc () function fetches a result row as an associative array. Loop–Assign one record at a time to ASSOC arry with mysql_fetch_array($n_array_1) = $a_array_1 Ħ.1) Print each record’s contents in a table using $a_array_1 for how many bits of data in each record Some kind of loop divides $dbq_record_set (100) into four arrays using column variables ($col_A_records, $col_B_records, etc). $col_A_records, $col_B_records, $col_C_records, $col_D_records) 100 total records) ĭivide: (total number of records) 100/4 (number of columns) equals (default number of records per column) 25 Ĭreate four variables for each column using #2 base value. Start with MYSQL query and single $dbq_record_set (ex. Here is my strategy to divide one MYSQL query into four separate arrays (1-4) ![]() My little franken project is to display one MYSQL query accross 4 columns (A,B,C,D). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |