Help Needed......

[NitroSimSev]

I am close to finishing a project I am working on. Here is the issue, I have a table that holds r_id,race_name, name, et, and mph. I have the sort down:

PHP Code:

$result = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "ns_qualifying_results where r_id='$r_id' ORDER BY et, mph DESC LIMIT 16"); 


from there I need to just pull the names then enter it in a new table called ns_round1_results. This table holds the top 16 qualifiers. The query would look like the following:

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 . "','" . $name0. "','" . $name1. "','" . $name2. "','" . $name3. "','" . $name4. "','" . $name5. "','" . $name6. "','" . $name7. "','" . $name8. "','" . $name9. "','" . $name10. "','" . $name11. "','" . $name12. "','" . $name13. "','" . $name14. "','" . $name15. "','".$r_id."')"); 


my question is how do I sanitize the $db->mysql_read so I can enter the name in the proper qualifying position? Any ideas?

[Wild-Wing]

well if im reading this correctly it would be easier to do a while and a for loop i would change your results table to have this race name and driver as the primary keys and have another field called position. that would do it in my opinion.

[NitroSimSev]

Well the results table is setup with race_name, name but no position with race name as primarary key. The qualifying table has race name and name.

question is how would the while and for loop look. I am bit new to PHP. I can set up the while loop it would be :

PHP Code:

$result = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "ns_qualifying_results where race_name='$race' ORDER BY et, mph DESC LIMIT 16");  
    while ($rows = $db->fetch_array($query)) 
    {
    $name = $rows['name'];
             for ($rows = $db->fetch_array($query)) 
                  {
         This is where I am lost!!!!
                  }
    } 


Since race_name is in all tables I can make that primary

[Wild-Wing]

Originally Posted by NitroSimSev

PHP Code:

$result = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "ns_qualifying_results where race_name='$race' ORDER BY et, mph DESC LIMIT 16");  
    while ($rows = $db->fetch_array($query)) 
    {
    $name = $rows['name'];
             for ($rows = $db->fetch_array($query)) 
                  {
         This is where I am lost!!!!
                  }
    } 


its

PHP Code:

$result = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "ns_qualifying_results where race_name='$race' ORDER BY et, mph DESC LIMIT 16");  
    while ($rows = $db->fetch_array($query)) 
    {
    $n = $rows['name'];
        what ever else make sure you add it below
            $racering["$n"] = $rows;
    }
 for ($racers = $racering) 
                  {
    do the insert query here
                  } 


[NitroSimSev]

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.)"); 


[NitroSimSev]

Help.......This doesn't seem to work....

Here's what I trying to do.

I have a table called qualifying and it's set up as follows:
r_id
name
et
mph

I am trying to move the top 16 names into a table called round1 which is set up as follows
r_id
r1_name_rd1
r3_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

I am having the hardest time that will get a query to work on this one. This is the very last thing to do before the mod is finished. Can one of the GURU's please help.