vb.org Archive - Help Needed......

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Help Needed...... (https://vborg.vbsupport.ru/showthread.php?t=125737)

NitroSimSev

09-03-2006 11:17 PM

Help Needed......

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

09-04-2006 12:03 AM

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

09-04-2006 01:12 AM

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

09-04-2006 01:56 AM

Quote:

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

09-04-2006 02:11 AM

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

09-08-2006 01:44 AM

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.

All times are GMT. The time now is 03:29 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01072 seconds Memory Usage 1,755KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (6)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: