Contact: ");
mysql_select_db('ecosmar_contacts', $dbcnx);
$listem = @mysql_query("SELECT ID,first_Name,Name FROM con_main WHERE usrn='$usrn' AND ID='$ProjCon'");
if (!$listem) {
echo(' Error retrieving contact data. ' . 'Error: '. mysql_error(). ' ');
}else{
$row = mysql_fetch_array($listem);
$CID = $row['ID'];
$first_Name = $row['first_Name'];
$Name = $row['Name'];
$all = $CID.' '.$first_Name.' '.$Name;
echo("$first_Name $Name");
}
}else{
echo("Contact: ");
mysql_select_db('ecosmar_contacts', $dbcnx);
$listem = @mysql_query("SELECT ID,first_Name,Name FROM con_main WHERE usrn='$usrn' ORDER BY Name");
if (!$listem) {
echo('Error retrieving contact data. ' . 'Error: '. mysql_error(). ' ');
}else{
$lcount = mysql_num_rows($listem);
if($lcount < 1){
echo(" You must enter a contact before beginning a project.");
}else{
echo("");
}
?>
|
Status:
|