Thanks......
So where $n = $rows['name']; thats going to select the first name first time through, then the second name the second time though, etc.....
If I read the $racering["$n"] = $rows; that will tell me how many rows. Correct? or ist putting the name in racering?
Would the query look like:
PHP Code:
$db->query_write("INSERT INTO " . TABLE_PREFIX . "ns_round1_results (race_name,r1_name_rd1,r2_name_rd1,r3_name_rd1,r4_name_rd1,r5_name_rd1,r6_name_rd1,r7_name_rd1,r8_name_rd1,r9_name_rd1,r10_name_rd1,r11_name_rd1,r12_name_rd1,r13_name_rd1,r14_name_rd1,r15_name_rd1,r16_name_rd1, r_id) VALUES ('" . $race . "','" . $racers0. "','" . $racers1. "' etc.)");