Rsort Error

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
CoolAsCarlito
Forum Contributor
Posts: 192
Joined: Sat May 31, 2008 3:27 pm
Contact:

Rsort Error

Post by CoolAsCarlito »

Half of this script works and the other half doesn't. The part that DOES work is the coding near the bottom where the titles are displayed. The part of the script that DOESN'T work is the part that displays each title. When I load the page it gives me this:

No champions have been crowned yet!
Warning: rsort() expects parameter 1 to be array, null given in /home/content/y/a/n/yankeefaninkc/html/titlehistory.php on line 86

Warning: rsort() expects parameter 1 to be array, null given in /home/content/y/a/n/yankeefaninkc/html/titlehistory.php on line 87

Code: Select all

 
<?php echo "<body bgcolor=\"black\" text=\"white\" link=\"red\" vlink=\"red\">"; ?>
 
<?php
function dateConvert($date)
{
    $eDat = explode("-",$date);
    $year = $eDat[0];
    $nMon = $eDat[1];
    $day  = $eDat[2];
    switch ($nMon)
    {
        case 1:  $mont = "January"; break;
        case 2:  $mont = "February"; break; 
        case 3:  $mont = "March"; break;
        case 4:  $mont = "April"; break;
        case 5:  $mont = "May"; break;
        case 6:  $mont = "June"; break;
        case 7:  $mont = "July"; break;
        case 8:  $mont = "August"; break;
        case 9:  $mont = "September"; break;
        case 10: $mont = "October"; break;
        case 11: $mont = "November"; break;
        case 12: $mont = "December"; break; 
    } 
    $out = $mont . " " . $day . ", " . $year;
    return $out;
}
?>
 
<?php
// Connects to your Database
$link = mysql_connect("?", "?"?") or die(mysql_error());
mysql_select_db("?",$link) or die(mysql_error());
 
if (isset($_GET['id']))
{   
    // First, we need to get the champs, so do some mysql stuffs.
    $qry0 = "SELECT * FROM `titlechamps` WHERE `title` = '".addslashes($_GET['id'])."';";
    $res0 = mysql_query($qry0) or die('Qry zero error!');
    if(!mysql_num_rows($res0)) echo "No champions have been crowned yet!";
    else
    {
        while($list0 = mysql_fetch_assoc($res0))
        {
            // We have at least one champ.
            // First, we have to do a little math. We need to determine 
            // how many days have elapsed between the date won and today.
            $today = explode("-",date("Y-m-d", time()));
            $yesterday = explode("-",$list0['date']);
            $hi = gregoriantojd($today[1],$today[2],$today[0]);
            $lo = gregoriantojd($yesterday[1],$yesterday[2],$yesterday[0]);
            $days = round($hi - $lo);
            
            // We will add the days and name to an array for the header.
            $longestR[] = $days . " - " . $list0['name'];
            // We also add the most successful defences to another array.
            $sucessfulD[] = $list0['defenses'] . " - " . $list0['name'];
            
            if($list0['news'] != null)
            $body .= "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"2\" border=\"0\"><tbody><tr><td colspan=\"2\" bgcolor=\"#e0e0e0\" valign=\"top\" width=\"100%\"><i>".$list0['news']."</i></td></tr></tbody></table>\n";
            
            $body .= 
            "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"2\" border=\"0\"><tbody>\n".
                "<tr>\n".
                "<td width=\"115\" valign=\"top\" align=\"center\"><img src=\"".$list0['pic']."\" /></td>".
                "<td>".
                "<table width=\"100%\" cellspacing=\"1\" cellpadding=\"2\" border=\"0\"><tbody><tr>".
                    "<td width=\"25\" bgcolor=\"#e0e0e0\" align=\"center\"><b>".$list0['num']."</b></td>".
                    "<td bgcolor=\"#e0e0e0\"><font color=\"#ff0000\">".$list0['name']."</font></td>".
                "</tr></tbody></table>".
                "<table width=\"100%\" cellspacing=\"1\" cellpadding=\"2\" border=\"0\"><tbody>".
                    "<tr><td align=\"center\" bgcolor=\"#e0e0e0\" width=\"50%\"><b>Successful Defenses</b></td><td align=\"center\" bgcolor=\"#e0e0e0\"><b>Event</b></td></tr>".
                    "<tr><td align=\"center\">".$list0['defenses']."</td><td align=\"center\">".$list0['event']."</td></tr>".
                    "<tr><td align=\"center\" bgcolor=\"#e0e0e0\"><b>Reign</b></td><td align=\"center\" bgcolor=\"#e0e0e0\"><b>Date Won</b></td></tr>".
                    "<tr><td align=\"center\">$days</td><td align=\"center\">".dateConvert($list0['date'])."</td></tr>".
                    "<tr><td colspan=\"2\"><i>".$list0['blurb']."</i></td></tr>".
                "</tbody></table>".
                "</td></tr>".
            "</tbody></table>\n";
            
        }
        
    }
    
    // Now, determine the longest reign and most defenses
    rsort($longestR);
    rsort($sucessfulD);
 
 
//next, we need to assemble the header of the page.
    $query = "SELECT *, DATE_FORMAT(`datecreated`, '%M %e, %Y') AS datecreated FROM titlehistory WHERE id='".addslashes($_GET['id'])."';";
 
    if ($r = mysql_query ($query)){ // Run the query. 
        while ($row = mysql_fetch_array ($r)){
 
 
            $head .= '<table border=0 cellspacing="0" cellpadding=3 width=575>';
            $head .='<tr><td background="images/bg_bar4.gif" height=35>&nbsp;<font color="white">Title Histories</font></td></tr>';
            $head .='<tr><td></td></tr>';
            $head .='</table>';
            $head .='<table border=0 cellspacing="0" cellpadding=3 width=575>';
            $head .='<tr><td background="images/bg_bar3.gif" height=35 colspan=2>&nbsp;<font color=black>KOW '.$row['titlename'].'</font></td></tr>';
            $head .='<tr><td width=200><img src="/images/' . $row['titleimage'] . '" width=208px height=156px border=0 alt="View KOW '.$row['titlename'].' History"></td><td valign=top>';
            $head .='<table cellpadding="2" cellspacing="0" border="0" width=100%>';
            $head .='<tr><td align=center bgcolor=#E0E0E0><b><font color="#000000">Date Created</font></b></td></tr><tr><td align=center>'.$row['datecreated'].'</td></tr>';
            $head .='<tr><td bgcolor=#E0E0E0 align=center><b><font color="#000000">Status</font></b></td></tr>';
            $head .='<tr><td align=center>'.$row['status'].'</td></tr>';
            $head .='<tr><td bgcolor=#E0E0E0 align=center><b><font color="#000000">Longest Reign</font></b></td></tr>';
            $head .='<tr><td align=center>'.$longestR[0].'</td></tr>';
            $head .='<tr><td bgcolor=#E0E0E0 align=center><b><font color="#000000">Most Successful Defenses</font></b></td></tr>';
            $head .='<tr><td align=center>'.$sucessfulD[0].'</td></tr>';
            $head .='</table>';
        }
    }
}
    else
    {
        print '<table border=0 cellspacing="0" cellpadding=3 width=575>';
        print '<tr><td background="images/bg_bar4.gif" height=35>&nbsp;<font color="white">Title Histories</font></td></tr>';
        print '</table>';
        print '<table border=0 cellspacing="0" cellpadding=3 width=575>';
        print '<tr><td background="images/bg_bar3.gif" height=35 colspan=4>&nbsp;<font color="#000000">Active Titles</font></td></tr>';
        print '<tr>';
 
        //Define the query
        $query = "SELECT * FROM titles WHERE status = 'Active'"; // Active rows
 
        if ($r = mysql_query ($query)){ // Run the query. 
 
            while ($row = mysql_fetch_array ($r)){
    
                print '<td><a href="titlehistory.php?id=' . $row['id'] . '" title="View KOW '.$row['titlename'].' History">';
                print '<img src="/images/' . $row['titleimage'] . '" border=0 alt="View KOW '.$row['titlename'].' History" height="115px" width="115px"></a></td>';
            }
 
        } 
        else {
            die ('<p>Could not retrieve the data because <b>' . mysql_error() . '</b>. The query was $query.</p>');
        }//End of query IF 
 
        print '</tr>';
        print '</table>';
        print '<img src=images/spacer.gif><br>';
        print '<table border=0 cellspacing=0 cellpadding=3 width=575><tr><td background="images/bg_bar3.gif" height=35 colspan=2>&nbsp;<font color="#000000">Inactive Titles</font></td></tr>';
        print '<tr>';
 
        //Define the query
        $query = "SELECT * FROM titles WHERE status = 'Inactive'"; // Inactive Rows
 
        if ($r = mysql_query ($query)){ // Run the query. 
 
            while ($row = mysql_fetch_array ($r)){
    
                print '<td><a href="titlehistory.php?id=' . $row['id'] . '" title="View KOW '.$row['titlename'].' History">';
                print '<img src="/images/' . $row['titleimage'] . '" border=0 alt="View KOW '.$row['titlename'].' History" height="115px" width="115px"></a></td>';
    
            }
 
        } 
        else {
            die ('<p>Could not retrieve the data because <b>' . mysql_error() . '</b>. The query was $query.</p>');
        } //End of query IF 
    }
print '</tr>';
print '</table>'; 
 
?>
 
 
Post Reply