Motorcycle Video's
|
if(isset($_GET['subkat'])){
$subkat = $_GET['subkat'];
}else{
$subkat='';
}
if(isset($_GET['id'])){
$id = $_GET['id'];
}else{
$id='';
}
$mysql = mysql_connect("localhost","402441_admin","NuvvMJ..");
mysql_select_db( "402441_motorbikenews" );
if($id==''){
$Query = "SELECT * from video where category = '$subkat' limit 1 , 1" ;
}
else {
$Query = "SELECT * from video WHERE Vidname = '$id'";
}
$Result = mysql_query( $Query );
echo' ';
$i=0;
while ( $DOC = mysql_fetch_object( $Result ) and $i < 4 )
{
echo '
Featured Video
| ';
echo ' '.$DOC->Vidname.' ';
echo ' | ';
echo '';
echo '
'.$DOC->comments.' ';
echo ' |
 back to main video page |
| ';
}
echo 'Latest Videos
';
$Query = "SELECT * from video order by dateadded desc ";
$Result = mysql_query( $Query );
$j=0;
$i=0;
$katcount = 0;
while ( $DOC = mysql_fetch_object( $Result ) and $i < 1 )
{
echo '';
echo ''.$DOC->Vidname.' ';
echo ' ';
echo '
';
$i++;
}
$Query = "SELECT * from video where newest=1";
$Result = mysql_query( $Query );
$i=0;
while ( $DOC = mysql_fetch_object( $Result ) and $i < 2 )
{
echo '';
echo ''.$DOC->Vidname.' ';
echo ' ';
echo '
';
$i++;
}
echo ' | ';
echo '
';
echo' ';
$Query = "SELECT * from video WHERE category = '$subkat' order by category";
$Result = mysql_query( $Query );
$lastcat='aaaaa';
$i=0;
while ( $DOC = mysql_fetch_object( $Result ) )
{
$filename = "$DOC->category.gif";
if (file_exists($filename)) {
$filenametuse = "$DOC->category.gif"
;
} else {
$filenametuse = 'moviecam.gif';
}
if ($lastcat <> $DOC->category){
echo '
|  | '.$DOC->category.' |
';
?>
If you wish to add your video just email ian@motorbike-search-engine.co.uk or
upload your file here
| |