mysql_select_db('ecosmar_friendly', $dbcnx);
$listem = @mysql_query("SELECT ID,Project_Name FROM task WHERE ID='$PID'");
if (!$listem) {
echo("Problem getting Project ID. Error: ". mysql_error());
}else{
$numrows = mysql_num_rows($listem);
if($numrows < 1){
$ASSID = "";
$ASSys = " ";
}else{
$ASSpj = mysql_fetch_row($listem);
$ASSID = $ASSpj['ID'];
$ASSays = $ASSpj['Project_Name'];
$ASSys = substr($ASSays, 0, 30);
}
}
$listemb = @mysql_query("SELECT ID,Project_Name FROM task WHERE usrn='$usrn' ORDER BY Project_Name");
if (!$listemb) {
echo("Problem getting Project List. Error: ". mysql_error());
}else{
$numrows = mysql_num_rows($listemb);
if($numrows < 1){
echo("No Projects");
}else{
echo("");
}
}
?>
|