esnet_code_daily

here's the php class that grabz the newest row out of the dump database tables. when a function is called the row is amalgamated together with some html in an output variable then returned.

then it's as simple as calling new leftDump then echo'ing.

<?php



class leftDump{

    function __construct() {

            //this is the constructor. db connections

            global $server;


            global $dbuser;

            global $dbpass;

            $link = mysql_connect($server,$dbuser,$dbpass)

                   or die('Could not connect: ' . mysql_error());


                mysql_select_db('edwardsh_db') or die('Could not select database');

    }

    function dailydump(){

            $query = 'SELECT * FROM `dump` ORDER BY `id` DESC LIMIT 1 ';


            $result = mysql_query($query) or die('Query failed: ' . mysql_error());

            $row = mysql_fetch_array($result, MYSQL_ASSOC);


            $output = '<p class="dumptitle">daily_dump ';

            $output .= nl2br($row[date]);

            $output .= ":</p>\n";


            $output .= '<p class="dump">';

            $output .= nl2br($row[data]);

            $output .= "</p>\n";


            return $output;

            mysql_free_result($result);

    }

    function reading(){

            $query = 'SELECT * FROM `books` ORDER BY `id` DESC LIMIT 1';


            $result = mysql_query($query) or die('Query failed: ' . mysql_error());

            $row = mysql_fetch_array($result, MYSQL_NUM);


            $output = '<p class="dumptitle"><a href="http://www.google.com/search?q=';

            $output .= urlencode($row[2]."+".$row[1]);


            $output .= '" rel="external">currently reading</a>:</p>';

            $output .= "<p class=\"dump\"><i>$row[1]</i><br />";


            $output .= "<span>by:</span> <b>$row[2]</b></p>";

            return $output;

            mysql_free_result($result);


    }

    function watching(){

            $query = 'SELECT * FROM `movies` ORDER BY `id` DESC LIMIT 1';


            $result = mysql_query($query) or die('Query failed: ' . mysql_error());

            $row = mysql_fetch_array($result, MYSQL_NUM);


            $output = "<p class=\"dumptitle\"><a href=\"http://www.google.com/search?q=";

            $output .= urlencode($row[2]."+".$row[1]);


            $output .= "\" rel=\"external\">currently watching</a>:</p>";

            $output .= "<p class=\"dump\"><i>$row[1]</i><br />";


            $output .= "<span>by:</span> <b>$row[2]</b></p>";

            return $output;

            mysql_free_result($result);


    }

    function hearing(){

            $query = 'SELECT * FROM `music` ORDER BY `id` DESC LIMIT 1';


            $result = mysql_query($query) or die('Query failed: ' . mysql_error());

            $row = mysql_fetch_array($result, MYSQL_NUM);


            $output = "<p class=\"dumptitle\"><a href=\"http://www.google.com/search?q=";

            $output .= urlencode($row[1]."+".$row[2]);


            $output .= "\" rel=\"external\">currently hearing</a>:</p>";

            $output .= "<p class=\"dump\"><i>$row[2]</i><br />";


            $output .="<span>by:</span> <b>$row[1]</b></p>";

            return $output;

            mysql_free_result($result);


    }

}

?>