[SOLVED] php database echo

[dezkit]

i have a table set up

 

id  | league | wins | losses | ties

1  | CAL-O  |   2   |     2    |  0
2  | CEVO-A|   0   |     0    |  0

 

is it possible to echo the table as

CAL-O:   2-2-0
CEVO-A: 0-0-0

 

if yes, can i get the code?

[JasonLewis]

Course it's possible...

 

<table border="0" width="100%" cellpadding="1" cellspacing="0">
<tr>
<td>League</td>
<td>Wins</td>
<td>Losses</td>
<td>Ties</td>
</tr>

<?php
$query = mysql_query("SELECT * FROM `table`");

if(mysql_num_rows($query) == 0){
?>
<tr>
<td colspan="4">There is no data.</td>
</tr>
<?php
}else{
while($r = mysql_fetch_array($query)){
$league = $r['league'];
$wins = $r['wins'];
$losses = $r['losses'];
$ties = $r['ties'];
?>
<tr>
<td><?php echo $league; ?></td>
<td><?php echo $wins; ?></td>
<td><?php echo $losses; ?></td>
<td><?php echo $ties; ?></td>
</tr>
<?php
}
}
?>
</table>

 

Wrote that on the fly so it may have errors.

[dezkit]

hmm thats weird. it doesn't show the data oO

 

edit: the "There is no data." doesn't show, and so doesn't the data.

[JasonLewis]

You didn't copy and paste did you? You should change it around to suit your needs.

[dezkit]

yeah, i changed the `table` part...

[dezkit]

what the...

 

<?php
$result = mysql_query("SELECT * FROM matches") 
or die(mysql_error());  

echo "<table>";
echo "<tr> <th>League</th> <th>Wins</th> <th>Losses</th> <th>Ties</th></tr>";

while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>"; 
echo $row['league'];
echo "</td><td>"; 
echo $row['wins'];
echo "</td><td>"; 
echo $row['losses'];
echo "</td><td>"; 
echo $row['ties'];
echo "</td></tr>"; 
} 

echo "</table>";
?>

 

doesn't work too

 

 

 

[JasonLewis]

Haha. That's good. Well it should work, depending on how you've implemented it.

[dezkit]

Oh wow, im so stupid, i was using the wrong table name, LOL.

 

topic solved

thanks for the code! <3

[JasonLewis]

Haha nice, no worries.