Addind some results - Codewalkers

Codewalkers Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

July 11th, 2002, 11:13 AM

D1NGO

Join Date: Apr 2007

Location: Perth, Australia

Posts: 221

Time spent in forums: < 1 sec
Reputation Power: 2

Addind some results

okay, i'm making a football tipping program, and am having some problem with one of my scripts.

php Code:

Original - php Code

 
<?php
.
.
.
.
//find users points.
$resultxx = mysql_query("SELECT * FROM FT_table, members WHERE round = '{$_POST['round']}' AND member_id = ID")
    or die(mysql_error());
$resultx = mysql_query("SELECT * FROM FT_results WHERE round = '{$_POST['round']}'")
    or die(mysql_error());
$rowxx = mysql_fetch_array($resultxx);
$rowx = mysql_fetch_array($resultx);
 
//determine how many tips they got correct
$correct = 0;
if($rowxx['game1'] == $rowx['game1'])
{
    $correct += 1;
}
if($rowxx['game2'] == $rowx['game2'])
{
    $correct += 1;
}
if($rowxx['game3'] == $rowx['game3'])
{
    $correct += 1;
}
if($rowxx['game4'] == $rowx['game4'])
{
    $correct += 1;
}
if($rowxx['game5'] == $rowx['game5'])
{
    $correct += 1;
}
if($rowxx['game6'] == $rowx['game6'])
{
    $correct += 1;
}
if($rowxx['game7'] == $rowx['game7'])
{
    $correct += 1;
}
if($rowxx['game8'] == $rowx['game8'])
{
    $correct += 1;
}
 
//insert the amount of correct answers they got.
mysql_query("UPDATE members SET FT_points = FT_points + '$correct' WHERE ID = '{$rowxx['member_id']}'")
    or die(mysql_error());
?>

it sort of works, it does exactly what i need, but only for the first person in the members list. I need it to look at everyones guesses, and then compare them to the results, not just one person. I know i gotta put a loop in there somewhere, but i'm too tired at the moment to see where :S. Any ideas?

July 11th, 2002, 05:10 PM

notepad

Join Date: Apr 2007

Location: Central, IL USA

Posts: 3,214

Time spent in forums: < 1 sec
Reputation Power: 5

RE: Addind some results

here is one loop that could shorten your code..

php Code:

Original - php Code
<? //determine how many tips they got correct $correct = 0; for($i=1; $i>8; $i++) { $game = "game$i"; if($rowxx['$game'] == $rowx['$game']) { $correct += 1; } } ?>

 
<?
//determine how many tips they got correct
$correct = 0;
for($i=1; $i>8; $i++)
{
    $game = "game$i";
    if($rowxx['$game'] == $rowx['$game'])
    {
        $correct += 1;
    }
}
?>

July 11th, 2002, 06:13 PM

D1NGO

Join Date: Apr 2007

Location: Perth, Australia

Posts: 221

Time spent in forums: < 1 sec
Reputation Power: 2

RE: Addind some results

I fixed the script, well it actually works now, but thanks for the loopy thing notepad

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: