Not Sorting my db

[RobbieG1977]

My display is not being sorted as you can see on
this page. What am I doing wrong?

PHP Code:

<?php
$sql = mysql_query("SELECT * FROM `nyyschedule` ORDER BY `gameid` ASC");

while( $row = mysql_fetch_assoc($sql) ) { 
    echo '<tr class="info" align="center">
    <td>' . $row['date'] . '</td> 
    <td>' . $row['opponent'] . '</td>
    <td>' . $row['time'] . '</td> 
    <td>' . $row['HP'] . '</td> 
    <td>' . $row['AP'] . '</td>'; 
}
?>

[Force Flow]

There are a few additional mistakes, on top of what your edit comment suggests.

First, you're not closing any of your statements. The only statements closed properly are the $sql = and the last $['AP'] statements.

Second, what column are you attempting to sort by? What does your database look like? When you specify "ORDER BY" in your SQL statement, it will sort your results by that column.

[RobbieG1977]

Updated my errors

PHP Code:

<?php
$sql = mysql_query("SELECT * FROM `nyyschedule` ORDER BY `gameid` ASC");

while( $row = mysql_fetch_assoc($sql) ) { echo '<tr class="info" align="center">;
    <td>' . $row['date'] . '</td>;
    <td>' . $row['opponent'] . '</td>;
    <td>' . $row['time'] . '</td>;
    <td>' . $row['HP'] . '</td>;
    <td>' . $row['AP'] . '</td>'; 
}
?>

Are they all correct?

I am sorting it by the 'gameid.'

[Force Flow]

Your syntax is correct.

However, I can't determine anything beyond that since your link is dead and I know nothing about your particular database. You'll have to provide some more information.