" . mysql_error()); if (mysql_num_rows($result) == 0){ $client_graphic = ""; } else{ $client_graphic = $path . mysql_result($result, 0); } //echo "client_graphic is $client_graphic
"; //now make pull-down list of graphic files from database $sql = "SELECT DISTINCT graphic_file from tbl_jobs ORDER BY graphic_file"; $result = mysql_query($sql, $connection) or die("could not get graphic list
" . mysql_error()); while ($row = mysql_fetch_array($result)){ $graphic_file = $row['graphic_file']; $option_block .= ""; } ?>

Survey Publishing Tools

 

Client Graphic



Activate/Deactivate



Notify Respondents




 


Past Notifications For This Job



"; if ('Y' == $active){ echo "This survey is Active";} else{ echo "This survey is Inactive";} ?>    Deactivate"; } else{ echo "Activate"; } echo "

"; echo" "; } function client_graphic_section(){ global $client_graphic; global $option_block; ?>
"; ?>
Use this file from my local computer:
File should be less than 20k in size, and in jpg or gif formats

 

Or select existing graphic from a previous job $option_block "; ?>

"; echo" Cc:

"; // need to deal w/ this in the case of going back echo" From:

"; ?> Subject:

$email_intro
"; // load_email_section(); echo" "; echo "
$email_closer
"; echo" "; ?> " . mysql_error()); if (mysql_num_rows($result)){ $initial_or_reminder = "REMINDER"; } else{ $initial_or_reminder = "INITIAL"; } echo"
"; if ($initial_or_reminder == 'INITIAL'){ echo "This will be the INITIAL email."; } else{ echo "This will be a REMINDER email."; } echo"
"; } function load_email_section(){ global $connection; ?> You can compose your own message, or use an existing one by selecting here
"; echo " "; // get the default messages and add them to html option block $sql = "SELECT * FROM tbl_notifications WHERE job_id=0"; $result = mysql_query($sql, $connection) or die ("could not select default emails
" .mysql_error()); while($row = mysql_fetch_array($result)){ $initial_or_reminder = $row['initial_or_reminder']; $notification_id = $row['notification_id']; echo " "; } // now get all other messages and add them to html option block $sql = "SELECT tc.client_name, tn.initial_or_reminder, tn.notification_id, tj.job_name FROM tbl_clients as tc, tbl_notifications as tn, tbl_jobs as tj WHERE tc.client_id = tj.client_id AND tn.job_id = tj.job_id ORDER BY tn.date_time"; //echo "sql is $sql
"; $result = mysql_query($sql, $connection) or die("could not do really complicated select
" . mysql_error()); while ($row = mysql_fetch_array($result)){ $client_name = $row['client_name']; //echo "client_name is $client_name
"; $initial_or_reminder = $row['initial_or_reminder']; $job_name = $row['job_name']; $notification_id = $row['notification_id']; echo " "; } echo ""; /* */ ?>   
"; $result = mysql_query($sql, $connection) or die("could not select past emails
" . mysql_error()); $num_rows = mysql_num_rows($result); //echo "num_rows is $num_rows
"; echo"
"; echo ""; echo ""; while ($row = mysql_fetch_array($result)){ echo ""; $initial_or_reminder = $row['initial_or_reminder']; $timestamp = $row['date_time']; $date = date("n/j/y"); $subject = $row['subject']; $notification_id = $row['notification_id']; echo " "; echo ""; //echo "

"; } echo "
Notification Type Date Sent Subject
$initial_or_reminder
$date
$subject
"; echo"
"; } ?>