session_start ();
include '../../conchshell/config.php' ; //open the database
if ($dont_read = '' ) { require('../../conchshell/encryption.php'); }
// Define post fields into simple variables
$submission_code = $_REQUEST['submission_code'];
$article_code = $_REQUEST['article_code'];
$mediator_id = $_REQUEST['mediator_id'];
if ($submission_code == '') {
$article_stack = array();
$submission_stack = array();
// find out if there is another unanswered submission so that this person can give more advice
$i = 1;
while ($i <= 25) {
$cur= mysql_query("select * FROM submission WHERE article_code = $i AND visible = '1' AND advice_total = '' " ) or die(mysql_error());
// fetch the succesive result rows
while( $row=mysql_fetch_row( $cur ) ) {
$nbrow++;
$ID = $row[0];
$submission_code = $row[4];
$submissions_total ++ ;
array_push($article_stack, $article_code);
array_push($submission_stack, $submission_code);
}
$i++;
}
//print_r($article_stack);
//print_r($submission_stack);
$random_submission = rand(1, $submissions_total);
$next_article = $article_stack[$random_submission] ;
$next_submission = $submission_stack[$random_submission] ;
$show_mediator_form = "
" ;
include 'post_advice_thankyou.php' ;
exit() ;
}
$emailerr = "";
$passerr = "" ;
$usererr= "" ;
$submission_code = stripslashes($submission_code);
$article_code = stripslashes($article_code);
$submission_code = htmlentities($submission_code, ENT_QUOTES);
$article_code = htmlentities($article_code, ENT_QUOTES);
$cur = mysql_query("SELECT * FROM submission WHERE article_code = '$article_code' AND submission_code = '$submission_code' AND visible = '1' ");
while( $row=mysql_fetch_row( $cur ) ) {
$nbrow++;
$submission_long = $row[6]; //get the field employee priority
// show the paragraphs
$submission_long = preg_replace('/(?)\n/', "
\n", $submission_long);
}
?>
Please suggest advice to for this user.
| include '../top_nav.php' ; echo "$top_nav" ; ?> |
| include "../left_nav.php" ; echo "$left_nav" ; ?> |
How can this person improve their situation?
| |
This is the problem the employee is having: |
|
| |
|
|
| |
echo "$submission_long" ; ?>
|
|
|
echo "$submissionerr" ; ?>
|
include "../right_nav.php" ; echo $right_nav ; ?> |
$pagepath_current = "advi." ;
include '../../conchshell/config.php';
include '../../conchshell/sessidvar.php';
?>