Design Video Viewer

<?php

if($_GET['id'])
{
    // Connect to the MySQL Server, and select the database the video data is stored in. This is the DATABASE name and NOT the TABLE name :)
    mysql_connect("localhost", "username", "password");
    mysql_select_db("database-name");

    // Assign the ID provided in the URL a variable inside the script
    $id = $_GET['id'];

    // This ID is a number, so if the ID isn't a number, tell them off
    if(!is_numeric($id)) { $msg[] =  "Video ID is invalid !"; }
    else
    {
        // Query the MySQL Server for that id (title, description, url = Field Names / videos = Table Name)
        $query = mysql_query("SELECT title, description, url FROM videos WHERE id='$id'");

        // Does that ID exist in the Database ? Get the result count from the previous query
        if(mysql_num_rows($query) == 0) { $msg[] = "Video ID doesn't exist"; }
        else
        {
            // Ok, the video ID exists, now lets fetch the related data
            list($title, $description, $url) = mysql_fetch_row($query);

            // Now The video title is stored in the variable $title, the description is stored in $description and the Video URL is stored in $url
            // You can then echo these out later in the script, like in your flash video player script
            // Thats it :D
        }
    }
}
else
{
    $msg[] = "No Video ID provided !";
}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
    <head>
        <title>Xenano - Videos</title>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <meta http-equiv="content-language" content="en" />
        <link rel="stylesheet" type="text/css" href="css/global.css" />
        <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/swfobject/2.2/swfobject.js"></script>
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-gb" lang="en-gb" dir="ltr" >
  <link href="/templates/yoo_planet/favicon.ico" rel="shortcut icon" type="image/x-icon" />
  <link rel="stylesheet" href="http://xenano.net/plugins/system/yoo_effects/lightbox/shadowbox.css" type="text/css" />
  <link rel="stylesheet" href="/templates/yoo_planet/css/template2.css" type="text/css" />
  <link rel="stylesheet" href="/templates/yoo_planet/css/variations/blackblue.css" type="text/css" />
  <link rel="stylesheet" href="/templates/yoo_planet/css/custom.css" type="text/css" />
  <link rel="stylesheet" href="http://xenano.net/modules/mod_yoo_search/mod_yoo_search.css.php" type="text/css" />
  <style type="text/css">
    <!--
.wrapper { width: 900px; }
#menu .dropdown { width: 250px; }
#menu .columns2 { width: 500px; }
#menu .columns3 { width: 750px; }
#menu .columns4 { width: 1000px; }

    -->
  </style>
  <script type="text/javascript" src="/templates/yoo_planet/lib/js/mootools.js"></script>
  <script type="text/javascript" src="/media/system/js/caption.js"></script>
  <script type="text/javascript" src="/templates/yoo_planet/lib/js/addons/base.js"></script>
  <script type="text/javascript" src="/templates/yoo_planet/lib/js/addons/accordionmenu.js"></script>
  <script type="text/javascript" src="/templates/yoo_planet/lib/js/addons/fancymenu.js"></script>
  <script type="text/javascript" src="/templates/yoo_planet/lib/js/addons/dropdownmenu.js"></script>
  <script type="text/javascript" src="/templates/yoo_planet/lib/js/template.js"></script>
  <script type="text/javascript" src="http://xenano.net/modules/mod_yoo_search/mod_yoo_search.js"></script>
  <script type="text/javascript">
var YtSettings = { tplurl: '/templates/yoo_planet', color: 'blackblue' };
  </script>
  <script type="text/javascript">var YOOeffects = { url: 'http://xenano.net/plugins/system/yoo_effects/lightbox/' };</script>

<script type="text/javascript" src="http://xenano.net/plugins/system/yoo_effects/yoo_effects.js.php?lb=1&amp;re=1&amp;sl=1"></script>
 <style type="text/css">

.newsbar {

    background: #171717;

        padding: 5px;

        width: 98.5%;

    border: 1px solid #1d1d1d;

        text-align: center;

    color: #808080;

    font-size: 11px;

    font-weight: bold;

}

</style>
<link rel="apple-touch-icon" href="/templates/yoo_planet/apple_touch_icon.png" />
</head>

<body id="page" class="yoopage   ">

    <div id="page-body">
        <div class="wrapper">

            <div id="header">

                <div id="toolbar">


                                        <div class="left">
                        <div class="module mod-blank   first last">


    <ul class="menu menu-" />


</div>
                    </div>


                </div>

                <div class="header-bg">

                    <div class="header-img"></div>

                    <div class="header-t1">
                        <div class="header-t2">
                            <div class="header-t3"></div>
                        </div>
                    </div>

                    <div class="header-1">
                        <div class="header-2">
                            <div class="header-3">

                                <div id="headerbar">


                                </div>

                            </div>
                        </div>
                    </div>

                    <div class="header-b1">
                        <div class="header-b2">
                            <div class="header-b3"></div>
                        </div>
                    </div>

                </div>


                <div id="logo">
                    <a class="logo-icon correct-png" href="/index.php" title="Home"></a>
                </div>

                                <div id="menu">
                    <ul class="menu menu-dropdown"><li class="level1 item1 first"><a href="http://xenano.net/" class="level1 item1"><span class="bg ">Home</span></a></li><li class="level1 item2 active current"><a href="http://xenano.net/videos" class="level1 item2"><span class="bg ">Videos</span></a></li><li class="level1 item3"><a href="/index.php?option=com_content&view=category&layout=blog&id=36&Itemid=171" class="level1 item3"><span class="bg ">News</span></a></li><li class="level1 item5 last"><a href="/forum" class="level1 item5 last"><span class="bg ">Forum</span></a></li></ul>
                </div>

                                <div id="search">
                    <div class="default">

    <div id="yoo-search-1" class="yoo-search">


        <form action="index.php" method="post">

            <div class="searchbox">

                <button class="search-magnifier" type="submit" value="Search"></button>

                <input class="searchfield" type="text" onfocus="if(this.value=='search...') this.value='';" onblur="if(this.value=='') this.value='search...';" value="search..." size="20" alt="search..." maxlength="20" name="searchword" />

                <button class="search-close" type="reset" value="Reset"></button>

            </div>

            <input type="hidden" name="task"   value="search" />

            <input type="hidden" name="option" value="com_search" />

        </form>


        <div class="resultbox" style="width: 400px;"></div>


    </div>

</div><script type="text/javascript">
// <!--
window.addEvent('domready', function(){ new YOOsearch('yoo-search-1', { 'url': 'http://xenano.net/index.php?option=com_search&tmpl=raw&type=json&ordering=&searchphrase=all&Itemid=167', 'fieldText': 'search...', 'msgResults': 'Search results', 'msgCategories': 'Search categories', 'msgNoResults': 'No results found', 'msgMoreResults': 'More results' }); });
// -->
</script>

                </div>


            </div>
            <!-- header end -->

            <div class="inner-wrapper">


                <div id="middle">
                    <div id="middle-expand">

                        <div id="main">
                            <div id="main-shift">


                                <div id="mainmiddle">
                                    <div id="mainmiddle-expand">

                                        <div id="content">
                                            <div id="content-shift">


                                                <div class="wrapper-t1">
                                                    <div class="wrapper-t2">
                                                        <div class="wrapper-t3"></div>
                                                    </div>
                                                </div>

                                                <div class="wrapper-1">

                                                                                                        <div id="breadcrumbs">
                                                        <span class="breadcrumbs">
                                                    </div>

                                                    <div class="floatbox">


    <body scroll="yes">

        <center>
        <?php if(count($msg) == 0)
        { ?>
        <br /><br />
        Flash Video Player will load video from : <?php echo $url; ?>
        </center>
        <br /><br />
        <p class="newsbar"><br /><font size="4"><?php echo $title; ?></font>
        <br /><br /><?php echo $description; ?><br /><br /></p>
        <?php } else { ?>
        <br /><br />
        <p class="newsbar"><br /><font size="4">Error</font>
        <br /><br /><?php foreach($msg as $mssg) { echo "$mssg<br/>"; } ?><br /><br /></p><?php } ?>
    </body>

</html>