Displaying data

[bcart]

Hi there

 

I have a simple form where I submit notes attached to a customer. The code I am using is below.

 

$q_notes = "SELECT notes, entryDate FROM emp_notes WHERE employer='$employer' ORDER BY id DESC";

$r_notes = mysqli_query($dbc, $q_notes);

$row_notes = mysqli_fetch_array($r_notes);

 

echo '

<div id="right">

 

<h2>Past Activity</h2>

 

<br />';

 

echo '

<div id="notes">';

 

if ($row_notes) {

 

do {

 

//1. Remove time from Timestamp

$date = substr($row_notes['entryDate'], 0, 10);

 

//2. Convert the date to time

$time = strtotime($date);

 

echo '

<p><strong>Date added - ' . date("d, F Y", $time) . '</strong></p>

 

<p>' . $row_notes['notes'] . '</p><br /><br />';

 

} while ($row_notes = mysqli_fetch_array($r_notes));

 

} else {

 

echo '<p>No activity has taken place to date.</p>';

 

}

 

echo '

</div><!--end of notes -->';

 

echo '<p>' . $sic_code_list . '</p>';

 

if (isset($_POST['submitted2'])) {

 

// Initialize an error array.

$errors = array();

 

$employer = $_GET['id'];

 

if (empty($_POST['add_note'])) {

$errors[] = 'You forgot to enter a new note.';

} else {

$notes = mysqli_real_escape_string($dbc, trim($_POST['add_note']));

}

 

$notes = "INSERT INTO emp_notes (id, employer, notes, entryDate) VALUES (NULL, '$employer', '$notes', CURRENT_TIMESTAMP) ";

$run_notes = mysqli_query($dbc, $notes);

 

}//end of main if statement

 

echo '

<br /><br />

 

<form name="form2" method="post" action="update.php?id=' . $_GET['id'] . '" >

<table border="0" cellspacing="0" cellpadding="5">

<tr>

<td><textarea name="add_note" cols="50" rows="5"></textarea></td>

</tr>

<tr>

<td> </td>

</tr>

<tr>

<td><input type="submit" value="Add New Activity" /><input type="hidden" name="submitted2" value="TRUE" /></td>

</tr>

</table>

</form>

 

</div><!--end of right -->';

 

The problem is that when I submit the form the data I have just entered does not show on the page. It writes to the database but does not display. If I post another 'note' the previous one then shows.

 

How can I amend the code to make sure that it posts then displays straight away?

 

Thanks

[sasa]

first write to database and after thet show data

move this part to begin

cho '<p>' . $sic_code_list . '</p>';

if (isset($_POST['submitted2'])) {

// Initialize an error array.
$errors = array();

$employer = $_GET['id'];

if (empty($_POST['add_note'])) {
$errors[] = 'You forgot to enter a new note.';
} else {
$notes = mysqli_real_escape_string($dbc, trim($_POST['add_note']));
}

$notes = "INSERT INTO emp_notes (id, employer, notes, entryDate) VALUES (NULL, '$employer', '$notes', CURRENT_TIMESTAMP) ";
$run_notes = mysqli_query($dbc, $notes);

}//end of main if statement