$dnum = date(Ymd)*4;
$usrn = $_GET['usrn'];
$ID = $_GET['ID'];
$Project_Name = $_GET['Project_Name'];
if($usrn == "" or $ID == ""){
die("Sorry, there is a problem with your username. You must Log in to view this page.
");
}
$dbcnx = @mysql_connect('mysql.plainhost.com','ecosmar_ecosmart','ecoman1');
mysql_select_db('ecosmar_friendly', $dbcnx);
$listem = @mysql_query("SELECT product FROM task WHERE ID='$ID' AND Project_Name='$Project_Name'");
if (!$listem) {
echo("Problem retrieving Product List.
Error: ". mysql_error());
}else{
$num_rows = mysql_num_rows($listem);
if($num_rows < 1){
$messy = "No Products Listed";
}else{
$prod = mysql_fetch_array($listem);
$product = $prod['product'];
}
}
?>