''){
$_SESSION['sv'] = $send_sv ;
} ELSE { }
$sv = $_SESSION['sv'] ;
IF($send_notes > ''){
$_SESSION['notes'] = $send_notes ;
} ELSE { }
$notes = $_SESSION['notes'] ;
IF($send_key1 > ''){
$_SESSION['key1'] = $send_key1 ;
} ELSE { }
$key1 = $_SESSION['key1'] ;
IF($send_handle > ''){
$_SESSION['handle'] = $send_handle ;
} ELSE { }
$handle = $_SESSION['handle'] ;
IF($send_employee > ''){
$_SESSION['employee'] = $send_employee ;
} ELSE { }
$employee = $_SESSION['employee'] ;
IF($send_link > ''){
$_SESSION['clientlink'] = $send_link ;
} ELSE { }
$clientlink = $_SESSION['clientlink'] ;
IF($send_status > ''){
$_SESSION['status'] = $send_status ;
} ELSE { }
$status = $_SESSION['status'] ;
IF($send_option01 > ''){
$_SESSION['option01'] = $send_option01 ;
} ELSE { }
$option01 = $_SESSION['option01'] ;
IF($send_option03 > ''){
$_SESSION['option03'] = $send_option03 ;
} ELSE { }
$option03 = $_SESSION['option03'] ;
IF($send_sf > ''){
$_SESSION['sf'] = $send_sf ;
} ELSE { }
$sf = $_SESSION['sf'] ;
IF($sv == ''){ $sv = 1 ;} ELSE { }
IF($sf == ''){ $sf = no ;} ELSE { }
IF($status == ''){ $status = '%' ;} ELSE { }
IF($option01 == ''){ $option01 = 2 ;} ELSE { }
IF($option03 == ''){ $option03 = '%' ;} ELSE { }
IF($notes > ''){ $notes = '%'.$notes.'%' ;} ELSE { $notes = '%' ; }
IF($key1 > ''){$key1 = '%'.$key1.'%' ;} ELSE { $key1 = '%' ; }
if ($handle == "5" OR $handle == "") {$h1="1";$h2="1";} Else {$h1="handle";$h2="$handle";}
if ($employee == "5" OR $employee == "") {$h3="1";$h4="1";} Else {$h3="employee";$h4="$employee";}
if ($clientlink == "8") {$h5="1";$h6="1";} Else {$h5="link";$h6="$clientlink";}
?>
1- $employee 2 - $handle 3 - $clientlink No entries in the database match the entered criteria!";
?>
Back
0) :
WHILE ($i < $number):
$itemprev = $item ;
$item = mysql_result($result,$i,"item");
IF($itemprev == ''){$itemprev = $item ;} ELSE {}
$linkn = mysql_result($result,$i,"link");
$itemlink = mysql_result($result,$i,"itemlink");
$notesn = mysql_result($result,$i,"notes");
$handlen = mysql_result($result,$i,"handle");
$dateenteredn = mysql_result($result,$i,"dateentered");
$employeen = mysql_result($result,$i,"employee");
$statusn = mysql_result($result,$i,"status");
$timen = mysql_result($result,$i,"time");
$key1n = mysql_result($result,$i,"key1");
$option03a = mysql_result($result,$i,"option03");
$attachn = mysql_result($result,$i,"attach");
$querys2 = "SELECT * FROM client WHERE link='$employeen'";
$results2 = MYSQL_QUERY($querys2);
$numbers2 = MYSQL_NUMROWS($results2);
$is2 = 0;
IF ($numbers2 == 0) :
ELSEIF ($numbers2 > 0) :
WHILE ($is2 < $numbers2):
$employeep = mysql_result($results2,$is2,"name");
$is2++;
ENDWHILE; ENDIF;
$querys2 = "SELECT * FROM client WHERE link='$handlen'";
$results2 = MYSQL_QUERY($querys2);
$numbers2 = MYSQL_NUMROWS($results2);
$is2 = 0;
IF ($numbers2 == 0) :
ELSEIF ($numbers2 > 0) :
WHILE ($is2 < $numbers2):
$handlep = mysql_result($results2,$is2,"name");
$is2++;
ENDWHILE; ENDIF;
$querys2 = "SELECT * FROM client WHERE link='$linkn'";
$results2 = MYSQL_QUERY($querys2);
$numbers2 = MYSQL_NUMROWS($results2);
$is2 = 0;
IF ($numbers2 == 0) :
ELSEIF ($numbers2 > 0) :
WHILE ($is2 < $numbers2):
$emailp = mysql_result($results2,$is2,"email");
$companyp = mysql_result($results2,$is2,"company");
$is2++;
ENDWHILE; ENDIF;
?>
|
";
$dash = " - ";
$dashar = " --> ";
$pstart = " ";
$pend = " ";
$content1 = $pstart.$dateenteredn.$dash.$employeep.$dashar.$handlep.$dash.$statusn.$dash.$companyp.$dash.$openn.$dash.$pend ;
$content2 = $notesn ;
//$content = $pstart.$dateenteredn.$dash.$employeep.$dash.$handlep.$dash.$statusn.$dash.$companyp.$dash.$openn.$dash.$pend.$notesn ;
?>
- Ticket #
- 
- 
- 
-  -
- Info
|
|
0) :
WHILE ($i_sub < $number_sub):
$linkn_sub = mysql_result($result_sub,$i_sub,"link");
$item_sub = mysql_result($result_sub,$i_sub,"item");
$itemlink_sub = mysql_result($result_sub,$i_sub,"itemlink");
$notesn_sub = mysql_result($result_sub,$i_sub,"notes");
$handlen_sub = mysql_result($result_sub,$i_sub,"handle");
$dateenteredn_sub = mysql_result($result_sub,$i_sub,"dateentered");
$employeen_sub = mysql_result($result_sub,$i_sub,"employee");
$statusn_sub = mysql_result($result_sub,$i_sub,"status");
$timen_sub = mysql_result($result_sub,$i_sub,"time");
$key1n_sub = mysql_result($result_sub,$i_sub,"key1");
$option03a_sub = mysql_result($result_sub,$i_sub,"option03");
$attachn_sub = mysql_result($result_sub,$i_sub,"attach");
$querys2_sub = "SELECT * FROM client WHERE link='$employeen_sub'";
$results2_sub = MYSQL_QUERY($querys2_sub);
$numbers2_sub = MYSQL_NUMROWS($results2_sub);
$is2_sub = 0;
IF ($numbers2_sub == 0) :
ELSEIF ($numbers2_sub > 0) :
WHILE ($is2_sub < $numbers2_sub):
$employeep_sub = mysql_result($results2_sub,$is2_sub,"name");
$is2_sub++;
ENDWHILE; ENDIF;
$querys2_sub = "SELECT * FROM client WHERE link='$handlen_sub'";
$results2_sub = MYSQL_QUERY($querys2_sub);
$numbers2_sub = MYSQL_NUMROWS($results2_sub);
$is2_sub = 0;
IF ($numbers2_sub == 0) :
ELSEIF ($numbers2_sub > 0) :
WHILE ($is2_sub < $numbers2_sub):
$handlep_sub = mysql_result($results2_sub,$is2_sub,"name");
$is2_sub++;
ENDWHILE; ENDIF;
$querys2_sub = "SELECT * FROM client WHERE link='$linkn_sub'";
$results2_sub = MYSQL_QUERY($querys2_sub);
$numbers2_sub = MYSQL_NUMROWS($results2_sub);
$is2_sub = 0;
IF ($numbers2_sub == 0) :
ELSEIF ($numbers2_sub > 0) :
WHILE ($is2_sub < $numbers2_sub):
$companyp_sub = mysql_result($results2_sub,$is2_sub,"company");
$emailp_sub = mysql_result($results2_sub,$is2_sub,"email");
$is2_sub++;
ENDWHILE; ENDIF;
?>
|
|
|
|
|
