" /> "/> " /> reset
'') { $search_string = " AND (costom_fname LIKE '%".mysql_real_escape_string($_REQUEST["string"])."%' OR costom_Lname LIKE '%".mysql_real_escape_string($_REQUEST["string"])."%' OR phone LIKE '%".mysql_real_escape_string($_REQUEST["string"])."%')"; } if ($_REQUEST["Name"]<>'') { $search_city = " AND user_id='".mysql_real_escape_string($_REQUEST["Name"])."'"; } if ($_REQUEST["from"]<>'' and $_REQUEST["to"]<>'') { $sql = "SELECT * FROM ".$events." WHERE start_date >= '".mysql_real_escape_string($_REQUEST["from"])."' AND end_date <= '".mysql_real_escape_string($_REQUEST["to"])."'".$search_string.$search_city."ORDER BY `events_ms`.`start_date` ASC" ; } else if ($_REQUEST["from"]<>'') { $sql = "SELECT * FROM ".$events." WHERE start_date >= '".mysql_real_escape_string($_REQUEST["from"])."'".$search_string.$search_city."ORDER BY `events_ms`.`start_date` ASC" ; } else if ($_REQUEST["to"]<>'') { $sql = "SELECT * FROM ".$events." WHERE end_date <= '".mysql_real_escape_string($_REQUEST["to"])."'".$search_string.$search_city."ORDER BY `events_ms`.`start_date` ASC" ; } else { $sql = "SELECT * FROM ".$events." WHERE YEARWEEK( start_date- INTERVAL 1 DAY) = YEARWEEK(NOW())-1 ORDER BY `events_ms`.`start_date` ASC "; } $sql_result = mysql_query ($sql, $connection ) or die ('request "Could not execute SQL query" '.$sql); // echo "

"; echo "
Print | Close Window
"; //echo ""; //echo "

Period

 "; echo "

From:

 "; echo $data= date("D, d M Y",strtotime(mysql_real_escape_string($_REQUEST["from"]))); echo " to "; echo $data= date("D, d M Y",strtotime(mysql_real_escape_string($_REQUEST["to"]))); echo ""; echo ""; } $curDay=$d; //echo '
  • ',$row['costom_fname'],"
  • "; echo ""; echo ""; }}} echo ""; echo ""; echo ""; echo ""; echo "

    $d

    StartCustomerPhoneServiceNotes
    $data".($row ['costom_fname'])." ".($row ['costom_Lname'])."".($row ['phone'])."".($row1 ['fruit_name'])."Memo: ".($row ['details'])."
     
    Appointments as of $d• = Customer booked online
    "; ?>