Posted by: Mike on Nov 25th, 2008

Leave a Comment »

// set your infomation.
$dbhost='mysql5.websitesource.net';
$dbusername='mikejan1_moviesn';
$dbuserpass='PgMf43l8Zd16';
$dbname = 'mikejan1_snobs';

// connect to the mysql database server.
mysql_connect ($dbhost, $dbusername, $dbuserpass);
//select the database
mysql_select_db($dbname) or die('Cannot select database');
if(isset($_GET['search']))
{
$search = $_GET['search'];
}

$keywords = explode(" ", $search);

$query = "SELECT * FROM dvd_releases WHERE week='2008-11-25'" ;

$result = mysql_query($query) or die(mysql_error());
?>
while($row = mysql_fetch_array($result))
{
echo(".$row["releases"].");
echo ";
}
?>