[SOLVED] Need Help With This One

[refiking]

I am trying to echo all of the winners from the db.  How can I show all of them.  Right now, it only shows the last entry in the table.  Here is my code as is:

 

include 'header.php';
include 'cont.php';
$sql = mysql_query("SELECT * FROM scores");
while ($row = mysql_fetch_assoc($sql)) {
$hscore = $row['homescore'];
$ascore = $row['awayscore'];
$home = $row['home'];
$away = $row['away'];
$timestamp = $row['timestamp'];
$round = $row['roundname']; 
}
IF ($hscore >= $ascore) {
$winner = $home;
}
IF ($ascore >= $hscore) {
$winner = $away;
}
Echo $winner;

[pocobueno1388]

Try

 

<?php

include 'header.php';
include 'cont.php';

$sql = mysql_query("SELECT * FROM scores");

while ($row = mysql_fetch_assoc($sql)) {

   $hscore = $row['homescore'];
   $ascore = $row['awayscore'];
   $home = $row['home'];
   $away = $row['away'];
   $timestamp = $row['timestamp'];
   $round = $row['roundname'];
    
   if ($hscore >= $ascore) {
       $winner = $home;
   }
   if ($ascore >= $hscore) {
       $winner = $away;
   }

   echo $winner.'<br>';

}

?>

[refiking]

No dice.

[rhodesa]

So the new code produces the same output?

[refiking]

yes. It only shows the last record in the table

[rhodesa]

Well, then there is only one record in the table. Run this code, and copy/paste the output.

 

<?php
  include 'header.php';
  include 'cont.php';

  $sql = mysql_query("SELECT * FROM scores");
  print "Row Count: ".mysql_num_rows($sql)."<br>";

  while ($row = mysql_fetch_assoc($sql)) {
    $hscore = $row['homescore'];
    $ascore = $row['awayscore'];
    $home = $row['home'];
    $away = $row['away'];
    $timestamp = $row['timestamp'];
    $round = $row['roundname'];
    
    if($hscore > $ascore){
      $winner = $home;
    }elseif($ascore > $hscore){
      $winner = $away;
    }else{
      $winner = "TIE";
    }
    echo "Winner: $winner<br>";
  }
?>

[refiking]

That worked.  Here is the output:

 

Row Count: 5

Winner: HittFaktory

Winner: bidness

Winner: win

Winner: bidness

Winner: win

 

Now, how can I store these into another db table?

[rhodesa]

Have you created the table yet?

[refiking]

yes, it's based on a tournament.  The table it needs to go to is 'tourney'.  It's based on a tid(tournament id), which is also retrieved from the same table (scores) where I queried the scores in the script.

[rhodesa]

Can you try and describe in more detail what you are looking to do with the script? Like so:

 

Every time the script runs, I want to .....

[refiking]

Here's what I have so far:

 

mysql_query("INSERT into tourney (tid, home,away,homescore,awayscore,winner) VALUES ('$tid','$home','$away','$hscore','$ascore','$winner')");

 

Right now, it only inputs the last record.

[rhodesa]

Did you put it inside the loop?

[refiking]

That's what it was.  It was outside of the loop.