Echo table numbers

[CEinNYC]

Hey all -

 

What is the appropriate syntax to echo out each character name (vanity_name), and their total number of "ties" "wins" and "losses"

 

Thanks for your help!

	$q1 = "SELECT Wins, Ties, Losses from game_char WHERE vanity_name='mario'";
	$mario_sql = mysql_query($q1);

<?php echo "Mario: " . $mario_sql; ?>

 

 

[attachment deleted by admin]

[Rifts]

$q1 = "SELECT Wins, Ties, Losses from game_char WHERE vanity_name='mario'";
while($row = mysql_fetch_assoc($q1)) 
{
  echo $row['wins'];
}

[BlueSkyIS]

^ forgot to execute $q1 before using mysql_fetch_assoc() on the result...

 

$q1 = "SELECT Wins, Ties, Losses from game_char WHERE vanity_name='mario'";
$result = mysql_query($q1) or die(mysql_error());
while($row = mysql_fetch_assoc($result)) 
{
  echo $row['wins'];
}

[CEinNYC]

Thanks!!

[Rifts]

yeah my bad im use to doing it this way

 

$q1 = mysql_query("SELECT Wins, Ties, Losses from game_char WHERE vanity_name='mario'");
while($row = mysql_fetch_assoc($q1)) 
{
  echo $row['wins'];
}

[CEinNYC]

If I wanted all the character names, and all wins, losses, and ties, would I repeat this for each character, or is there a more efficient way?

Mario

Wins:

Ties:

Losses:

 

Link

Wins:

Ties:

Losses:

[Andy-H]

$query  = "SELECT vanity_name, Wins, Ties, Losses FROM game_char ORDER BY Wins DESC";
$result = mysql_query($query)or trigger_error("MySQL: " . mysql_error());

while($row = mysql_fetch_row($result))
{
echo <<<STATS
<pre>
<span style="font-weight:bold;">$row[0]</span>
Wins:    $row[1]
Ties:    $row[2]
Losses:    $row[3]
</pre>
STATS;
}

 

[CEinNYC]

Thank you!