PHP Direct Evaluation problem

[Colossal31]

I am trying to pull data from my DB and display it as a table in a Forum Side Block. I can not figure out where I am going wrong I have looked at multiple posts on here and Vbulletin.com and none of them seem to help me. When viewing this please keep in mind I am self taught and a novice at this. Here is my code for the side block..... If you see where I screwed up or know a better way to pull this info please let me know.

PHP Code:

$query = "SELECT team_id, win, loss FROM match_results WHERE season_id=12"; 
$result = mysql_query($query);

echo "<table>"; 

while($row = mysql_fetch_array($result)){   
echo "<tr><td>" . $row['Team'] . "</td><td>" . $row['Wins'] . "</td><td>"  .$row['Losses'] . "</td></tr>";
}

echo "</table>"; 


[bridge2heyday]

you should return value not echo

PHP Code:

$query = "SELECT team_id, win, loss FROM match_results WHERE season_id=12";  
$result = mysql_query($query); 

$output = "<table>";  

while($row = mysql_fetch_array($result)){    
$output .= "<tr><td>" . $row['Team'] . "</td><td>" . $row['Wins'] . "</td><td>"  .$row['Losses'] . "</td></tr>"; 
} 

$output .= "</table>";  
return $output; 


you should also avoid using the depreciated MySQL extension , you can use vBulletin database class.
for example

PHP Code:

$myquery =  vB::$db->query_read("SELECT team_id, win, loss FROM match_results WHERE season_id=12"); 


[Colossal31]

alright just so I am understanding right in place of

PHP Code:

$query = "SELECT team_id, win, loss FROM match_results WHERE season_id=12"; 


Use this?

PHP Code:

$myquery =  vB::$db->query_read("SELECT team_id, win, loss FROM match_results WHERE season_id=12"); 


--------------- Added [DATE]1448921015[/DATE] at [TIME]1448921015[/TIME] ---------------

Ok used the new pieces of code you gave me and I no longer get the string error but the data is not being displayed. Is there something else I am missing?

[squidsk]

You'll also need to update the condition of the while loop.

From:

while($row = mysql_fetch_array($result)){

To:

while($row = vB::$db->fetch_array($result)){

[Colossal31]

Originally Posted by squidsk

You'll also need to update the condition of the while loop.

From:

while($row = mysql_fetch_array($result)){

To:

while($row = vB::$db->fetch_array($result)){

Tried this and still no display. Still have no idea what I am doing wrong or if a forum block is even capable of displaying this info. Any more assistance is appreciated.

[bridge2heyday]

This code is tested

PHP Code:

$query        = "SELECT team_id, win, loss FROM match_results WHERE season_id=12";
$result       = vB::$db->query_read($query);
$tableresults = '<table style="width:100%"><tr><th><b>Team</b></th><th><b>Wins</b></th><th><b>Losses</b></th></tr>';
while ($row = vB::$db->fetch_array($result)) {
    $tableresults .= "<tr><td>" . $row['team_id'] . "</td><td>" . $row['win'] . "</td><td>" . $row['loss'] . "</td></tr>";
}
$tableresults .= '</table>';
return $tableresults; 


[Colossal31]

That does work but their are multiple match results for each team Id is there a way to sum up the wins and losses for each team id? SO that it doesnt come out like below.