loop query

helz

i have a page that loads data from sql db,
as each user adds a record, their name is entered into the db with their record,
my problem is how can i get the data from the db, but only show their name once, as their name is a link to the same page which loads the records for that user..

at the moment its looping so that their are multiple displays of the same person. just want to know how to make it so that if the user has more than 1 record that its only displayed once. and not for the number of records that the person has.

==edit==
ok then if you need more info then look at this:
http://bowling.hellrazer.net/index.php?module=Bowling_Scores
ignore the numbers. see how the same name is displayed twice cos they have 2 records, where the other one only has one

Pig

Use DISTINCT in your query. check out hte mysql manual.

helz

heres the code that gets the info:

  $bowler = mysql_query(" SELECT DISTINCT(bowlername), noofgame FROM ".$score." ");
		if (mysql_num_rows($bowler)>0) {
				while ($row = mysql_fetch_array($bowler)) {
					$noofgame = $row["noofgame"];
					$bowlername = $row["bowlername"];
	/*
				$totalgames = mysql_query(" SELECT noofgame FROM ".$score." WHERE bowlername = '".$bowlername."' ");
					$totalnog = mysql_fetch_array($totalgames);
						$totalnogg = array_sum($totalnog);
					$totalgmrows = mysql_num_rows($totalgames);
					$totgame = $totalnogg * totalgmrows;
			//	$totgame = ($totalgm * $totalgmrows);
				echo $totalnogg.'<br>'.$totalgmrows.'<br>';
*/
    echo "<tr><td><a href='index.php?module=Bowling_Scores&bowlername=".$bowlername."'>".$bowlername."</a></td><td>".$totgame."</td></tr>";

as you can see i added the distinct clause but its still giving the name twice.

LordShryku

This may work...I'm a bowler myself, so I GOTTA say something 🙂

$bowler = mysql_query("SELECT bowlername, noofgame FROM ".$score." GROUP BY bowlername"); 
if (mysql_num_rows($bowler)>0) { 
    while ($row = mysql_fetch_array($bowler)) { 
         $noofgame = $row['noofgame']; 
         if($row['bowlername'] != $bowlername) {
             $display = 1;
             $bowlername = $row['bowlername']; 
         }
         else {
             $display = 0;
         }
         echo "<tr><td>";
         if($display == 1) {
             echo "<a href=\"index.php?module=Bowling_Scores&bowlername=".$bowlername."\">".$bowlername."</a>";
         }
         else {
             echo "&nbsp;";
         }
         echo "</td><td>".$totgame."</td></tr>";
    }
}

helz

yep that worked, it displays teh names correctly, now onto the next thing 🙂
in the db, everytime the user adds some scores, the number of games that they have chosen gets put into the db along with their scores. so what i need now is to get a total of the column called noofgame, but only for the bowler of the list,

so i think it would go into the:
if ($display == 1) {

}
and echo the <td>$totgame</td></tr>
after the bowler has been been displayed...

for example the bowler called test might have two records one where the noofgame is 4 and another where the noofgame is 6, therefore i want the $totgame to display 10.

ive tried multiple things but they only seem to get the first noofgame and then display that same number for all the bowlers....

any help would be greatly appreciated 🙂

LordShryku

Give this a shot

$bowler = mysql_query("SELECT bowlername, noofgame FROM ".$score." GROUP BY bowlername");  

if(mysql_num_rows($bowler)>0) {
    while ($row = mysql_fetch_array($bowler)) {  

        if($row['bowlername'] != $bowlername) {
            $display = 1; 
            $bowlername = $row['bowlername'];
            $noofgame = $row['noofgame'];
            $totgame = $noofgame;
        } 
        else { 
            $display = 0;
            $noofgame = $row['noofgame'];
            $totgame = $totgame + $noofgame;
        } 
        echo "<tr><td>"; 
        if($display == 1) { 
            echo "<a href=\"index.php?module=Bowling_Scores&bowlername=".$bowlername."\">".$bowlername."</a>"; 
        } 
        else { 
            echo "&nbsp;"; 
        } 
        echo "</td><td>".$totgame."</td></tr>"; 
    } 
}

helz

that works great in the meaning that it loads the first record(row) for that user but it doesnt total up all the rows for that user, do we need to add a loop so that it gets all the rows for that user?