I've been reading books that show code like this to make data input into a database. <?php require_once('connectvars.php'); if (isset($_POST['submit'])) { $ncmrsr = $_POST['ncmrsr']; $ncmrsc = $_POST['ncmrsc']; if (!empty($ncmrsr) && !empty($ncmrsc)) { $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); or die('Error connecting to MySQL server.'); $query = "INSERT INTO ncmr (ncmrsr, ncmrsc) VALUES ('$ncmrsr', '$ncmrsc')"; mysqli_query($dbc, $query) or die ('Data not inserted.'); echo 'Customer added.'; mysqli_close($dbc); } } ?> Code (markup): But I already have this code there in its place. <?php require_once('connectvars.php'); // Connect to the database $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); // Grab the profile data from the database if (!isset($_GET['id'])) { $query = "SELECT * FROM ncmr WHERE id = '$id'"; } else { $query = "SELECT * FROM ncmr WHERE id = '" . $_GET['id'] . "'"; } $data = mysqli_query($dbc, $query); if (mysqli_num_rows($data) == 1) { } ?> Code (markup): How do I merge both to work with this script? Thanks in advance if anyone can figure it out.... I've been stuck on this for over a week and I am running into a deadline. When I attempt to merge the two codes myself I get errors, and I can't seem to find a way to correct them because I don't know how to fix them. The rest of the form as far as I can tell works perfectly, but again I can't test out the posting aspect of it until I get these two parts working together. Here is the link to a working version of the script as it stands below: http://kaboomlabs.com/PDI/1.php?id=2 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>PDI NCMR - View</title> <link rel="stylesheet" type="text/css" href="CSS/view.css" /> </head> <body> <div id="logo"> <img src="images/PDI_Logo_2.1.gif" alt="PDI Logo" /> </div> <?php require_once('connectvars.php'); // Connect to the database $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); // Grab the profile data from the database if (!isset($_GET['id'])) { $query = "SELECT * FROM ncmr WHERE id = '$id'"; } else { $query = "SELECT * FROM ncmr WHERE id = '" . $_GET['id'] . "'"; } $data = mysqli_query($dbc, $query); if (mysqli_num_rows($data) == 1) { // The user row was found so display the user data $row = mysqli_fetch_array($data); echo'<h3 id="NCMR2">Non-Conforming Materials Report (NCMR: ' . $row['NCMR_ID'] . ')</h3>'; echo '<form id="all" method="post">'; echo '<fieldset>'; if (!empty($row['Added_By']) && empty($row['Added_By_Date'])) { echo '<div id="ab"><span class="b">Added By: </span>' . $row['Added_By'] . '</div>'; echo '<div id="abd"><span class="b">On: </span>' . $row['Added_By_Date'] . '</div>'; } echo '<div id="box">'; echo '<div id="box1">'; if (!empty($row['Nexx_Part']) && !empty($row['Nexx_Rev']) && !empty($row['Nexx_Part_Description']) && !empty($row['NCMR_Qty'])) { echo '<div id="np"><span class="b">Nexx Part: </span>' . $row['Nexx_Part'] . '</div>'; echo '<div id="nr"><span class="b">Nexx Rev: </span>' . $row['Nexx_Rev'] . '</div>'; echo '<div id="npd"><span class="b">Nexx Part Description: </span>' . $row['Nexx_Part_Description'] . '</div>'; echo '<div id="ncqt"><span class="b">NCMR Qty: </span>' . $row['NCMR_Qty'] . '</div>'; } echo '<div id ="JSI">'; if (!empty($row['JO']) && !empty($row['SN']) && !empty($row['INV'])) { echo '<div id="JO"><span class="b">JO: </span><br />' . $row['JO'] . '</div>'; echo '<div id="SN"><span class="b">SN: </span><br />' . $row['SN'] . '</div>'; echo '<div id="INV"><span class="b">INV: </span><br />' . $row['INV'] . '</div>'; } echo '</div>'; echo '</div>'; echo '<div id="box4-1">'; // We know both $ncmrsr AND $ncmrsc are blank $row['ncmrsr'] = trim($row['ncmrsr']); $row['ncmrsc'] = trim($row['ncmrsc']); if (empty($row['ncmrsr']) && empty($row['ncmrsc'])) { // add comment. echo '<div id="ncmrsr"><span class="b">NCMR Supplier Response:<br /></span><textarea name="ncmrsr" rows="6" cols="85" ></textarea></div><br />'; echo '<div id="ncmrsc"><span class="b">NCMR Supplier Comment:<br /></span><textarea name="ncmrsr" rows="6" cols="85" ></textarea></div><br />'; } else { // echo the two fields. if (!empty($row['ncmrsr']) && !empty($row['ncmrsc'])) { echo '<div id="ncmrsr"><span class="b">NCMR Supplier Response: </span>' . $row['ncmrsr'] . '</div>'; echo '<div id="ncmrsc"><span class="b">NCMR Supplier Comment: </span>' . $row['ncmrsc'] . '</div>'; } echo '</div>'; echo '</div>'; echo '</div>'; echo '</fieldset>'; echo '</form>'; } } // End of check for a single row of user results else { echo '<p class="error">Please contact the web administrator, there seems to be an error!</p>'; } mysqli_close($dbc); ?> </body> </html> Code (markup):
Ok, now I'm just colored confused....I'm not getting an error at all. The problem is the form isn't showing up at all either. Can someone help me here? I'd rather see an error than nothing... at least I'd have an idea of where to start. Here is my updated code and site: http://kaboomlabs.com/PDI/1-1.php?id=2 <?php require_once('connectvars.php'); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>PDI NCMR - View</title> <link rel="stylesheet" type="text/css" href="CSS/view.css" /> </head> <body> <div id="logo"> <img src="images/PDI_Logo_2.1.gif" alt="PDI Logo" /> </div> <?php // Connect to the database $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); if (isset($_POST['submit'])) { // Grab the profile data from the POST $ncmrsc = mysqli_real_escape_string($dbc, trim($_POST['ncmrsc'])); $ncmrsr = mysqli_real_escape_string($dbc, trim($_POST['ncmrsr'])); } // Update the form in the database if (!empty($ncmrsr) && !empty($ncmrsc)) { $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); $query = "INSERT INTO ncmr (ncmrsr, ncmrsc) VALUES ('$ncmrsr', '$ncmrsc')"; mysqli_query($dbc, $query); // Confirm success with the user echo 'Customer added.'; // Grab the profile data from the database if (!isset($_GET['id'])) { $query = "SELECT * FROM ncmr WHERE id = '$id'"; } else { $query = "SELECT * FROM ncmr WHERE id = '" . $_GET['id'] . "'"; } $data = mysqli_query($dbc, $query); if (mysqli_num_rows($data) == 1) { // The user row was found so display the user data $row = mysqli_fetch_array($data); echo'<h3 id="NCMR2">Non-Conforming Materials Report (NCMR: ' . $row['NCMR_ID'] . ')</h3>'; echo '<form id="all" method="post">'; echo '<fieldset>'; if (!empty($row['Added_By']) && empty($row['Added_By_Date'])) { echo '<div id="ab"><span class="b">Added By: </span>' . $row['Added_By'] . '</div>'; echo '<div id="abd"><span class="b">On: </span>' . $row['Added_By_Date'] . '</div>'; } echo '<div id="box">'; echo '<div id="box1">'; if (!empty($row['Nexx_Part']) && !empty($row['Nexx_Rev']) && !empty($row['Nexx_Part_Description']) && !empty($row['NCMR_Qty'])) { echo '<div id="np"><span class="b">Nexx Part: </span>' . $row['Nexx_Part'] . '</div>'; echo '<div id="nr"><span class="b">Nexx Rev: </span>' . $row['Nexx_Rev'] . '</div>'; echo '<div id="npd"><span class="b">Nexx Part Description: </span>' . $row['Nexx_Part_Description'] . '</div>'; echo '<div id="ncqt"><span class="b">NCMR Qty: </span>' . $row['NCMR_Qty'] . '</div>'; } echo '<div id ="JSI">'; if (!empty($row['JO']) && !empty($row['SN']) && !empty($row['INV'])) { echo '<div id="JO"><span class="b">JO: </span><br />' . $row['JO'] . '</div>'; echo '<div id="SN"><span class="b">SN: </span><br />' . $row['SN'] . '</div>'; echo '<div id="INV"><span class="b">INV: </span><br />' . $row['INV'] . '</div>'; } echo '</div>'; echo '</div>'; echo '<div id="box4-1">'; // We know both $ncmrsr AND $ncmrsc are blank $row['ncmrsr'] = trim($row['ncmrsr']); $row['ncmrsc'] = trim($row['ncmrsc']); if (empty($row['ncmrsr']) && empty($row['ncmrsc'])) { // add comment. echo '<div id="ncmrsr"><span class="b">NCMR Supplier Response:<br /></span><textarea name="ncmrsr" rows="6" cols="85" ></textarea></div><br />'; echo '<div id="ncmrsc"><span class="b">NCMR Supplier Comment:<br /></span><textarea name="ncmrsr" rows="6" cols="85" ></textarea></div><br />'; echo '<div id="button"><input type="submit" name="submit" value="Submit" /></div>'; } else { // echo the two fields. if (!empty($row['ncmrsr']) && !empty($row['ncmrsc'])) { echo '<div id="ncmrsr"><span class="b">NCMR Supplier Response: </span>' . $row['ncmrsr'] . '</div>'; echo '<div id="ncmrsc"><span class="b">NCMR Supplier Comment: </span>' . $row['ncmrsc'] . '</div>'; } echo '</div>'; echo '</div>'; echo '</div>'; echo '</fieldset>'; echo '</form>'; } } // End of check for a single row of user results else { echo '<p class="error">Please contact the web administrator, there seems to be an error!</p>'; } mysqli_close($dbc); } ?> </body> </html> Code (markup):
I do it this way (using your two programs): <?php $mode = isset($_POST['mode']) ? $_POST['mode'] : ''; if($mode == '') {exit;} //or send an error message to the user require_once('connectvars.php'); if ($mode == 'submit']) { $ncmrsr = $_POST['ncmrsr']; $ncmrsc = $_POST['ncmrsc']; if (!empty($ncmrsr) && !empty($ncmrsc)) { $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); or die('Error connecting to MySQL server.'); $query = "INSERT INTO ncmr (ncmrsr, ncmrsc) VALUES ('$ncmrsr', '$ncmrsc')"; mysqli_query($dbc, $query) or die ('Data not inserted.'); echo 'Customer added.'; mysqli_close($dbc); } } else if($mode = 'select') { // Connect to the database $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); // Grab the profile data from the database if (!isset($_GET['id'])) { $query = "SELECT * FROM ncmr WHERE id = '$id'"; } else { $query = "SELECT * FROM ncmr WHERE id = '" . $_GET['id'] . "'"; } $data = mysqli_query($dbc, $query); if (mysqli_num_rows($data) == 1) { } } ?> PHP: Send it the ncmrsr, ncmrsr values, the id, etc., and a mode - submit or select.
Ok, this looks good I'll test it later, but I have a question... why this configuration? Just curious... can you break it down for me?
Ok, I tested it out the script didn't work... http://kaboomlabs.com/PDI/1-1.php?id=2 There is an error I am getting though: Parse error: syntax error, unexpected '[' in /home/pawz/public_html/kaboomlabs.com/PDI/1-1.php on line 26 Here is the code: <?php require_once('connectvars.php'); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>PDI NCMR - View</title> <link rel="stylesheet" type="text/css" href="CSS/view.css" /> </head> <body> <div id="logo"> <img src="images/PDI_Logo_2.1.gif" alt="PDI Logo" /> </div> <?php $mode = isset($_POST['mode']) ? $_POST['mode'] : ''; if($mode == '') {exit;}; //or send an error message to the user require_once('connectvars.php'); if ($mode == ['submit']) { $ncmrsr = $_POST['ncmrsr']; $ncmrsc = $_POST['ncmrsc']; if (!empty($ncmrsr) && !empty($ncmrsc)) { $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); or die('Error connecting to MySQL server.'); $query = "INSERT INTO ncmr (ncmrsr, ncmrsc) VALUES ('$ncmrsr', '$ncmrsc')"; mysqli_query($dbc, $query) or die ('Data not inserted.'); echo 'Customer added.'; mysqli_close($dbc); } } else if($mode = 'select') { // Connect to the database $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); // Grab the profile data from the database if (!isset($_GET['id'])) { $query = "SELECT * FROM ncmr WHERE id = '$id'"; } else { $query = "SELECT * FROM ncmr WHERE id = '" . $_GET['id'] . "'"; } $data = mysqli_query($dbc, $query); if (mysqli_num_rows($data) == 1) { // The user row was found so display the user data $row = mysqli_fetch_array($data); echo'<h3 id="NCMR2">Non-Conforming Materials Report (NCMR: ' . $row['NCMR_ID'] . ')</h3>'; echo '<form id="all" method="post">'; echo '<fieldset>'; if (!empty($row['Added_By']) && empty($row['Added_By_Date'])) { echo '<div id="ab"><span class="b">Added By: </span>' . $row['Added_By'] . '</div>'; echo '<div id="abd"><span class="b">On: </span>' . $row['Added_By_Date'] . '</div>'; } echo '<div id="box">'; echo '<div id="box1">'; if (!empty($row['Nexx_Part']) && !empty($row['Nexx_Rev']) && !empty($row['Nexx_Part_Description']) && !empty($row['NCMR_Qty'])) { echo '<div id="np"><span class="b">Nexx Part: </span>' . $row['Nexx_Part'] . '</div>'; echo '<div id="nr"><span class="b">Nexx Rev: </span>' . $row['Nexx_Rev'] . '</div>'; echo '<div id="npd"><span class="b">Nexx Part Description: </span>' . $row['Nexx_Part_Description'] . '</div>'; echo '<div id="ncqt"><span class="b">NCMR Qty: </span>' . $row['NCMR_Qty'] . '</div>'; } echo '<div id ="JSI">'; if (!empty($row['JO']) && !empty($row['SN']) && !empty($row['INV'])) { echo '<div id="JO"><span class="b">JO: </span><br />' . $row['JO'] . '</div>'; echo '<div id="SN"><span class="b">SN: </span><br />' . $row['SN'] . '</div>'; echo '<div id="INV"><span class="b">INV: </span><br />' . $row['INV'] . '</div>'; } echo '</div>'; echo '</div>'; echo '<div id="box4-1">'; // We know both $ncmrsr AND $ncmrsc are blank $row['ncmrsr'] = trim($row['ncmrsr']); $row['ncmrsc'] = trim($row['ncmrsc']); if (empty($row['ncmrsr']) && empty($row['ncmrsc'])) { // add comments. echo '<div id="ncmrsr"><span class="b">NCMR Supplier Response:<br /></span><textarea name="ncmrsr" rows="6" cols="85" ></textarea></div><br />'; echo '<div id="ncmrsc"><span class="b">NCMR Supplier Comment:<br /></span><textarea name="ncmrsr" rows="6" cols="85" ></textarea></div><br />'; echo '<div id="button"><input type="submit" name="submit" value="Enter Comments" /></div>'; } else { // echo the two fields. if (!empty($row['ncmrsr']) && !empty($row['ncmrsc'])) { echo '<div id="ncmrsr"><span class="b">NCMR Supplier Response: </span>' . $row['ncmrsr'] . '</div>'; echo '<div id="ncmrsc"><span class="b">NCMR Supplier Comment: </span>' . $row['ncmrsc'] . '</div>'; } echo '</div>'; echo '</div>'; echo '</div>'; echo '</fieldset>'; echo '</form>'; } mysqli_close($dbc); } ?> </body> </html> Code (markup):
Ok, I got it working, but its still not posting. <?php require_once('connectvars.php'); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>PDI NCMR - View</title> <link rel="stylesheet" type="text/css" href="CSS/view.css" /> </head> <body> <div id="logo"> <img src="images/PDI_Logo_2.1.gif" alt="PDI Logo" /> </div> <?php $mode == isset($_POST['mode']) ? $_POST['mode'] : ''; if($mode = '') {exit;} //or send an error message to the user require_once('connectvars.php'); if ($mode == 'submit') { $ncmrsr = $_POST['ncmrsr']; $ncmrsc = $_POST['ncmrsc']; if (!empty($ncmrsr) && !empty($ncmrsc)) { $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME) or die('Error connecting to MySQL server.'); $query = "INSERT INTO ncmr (ncmrsr, ncmrsc) VALUES ('$ncmrsr', '$ncmrsc')"; mysqli_query($dbc, $query) or die ('Data not inserted.'); echo 'Customer added.'; mysqli_close($dbc); } } else if($mode = 'select') { // Connect to the database $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); // Grab the profile data from the database if (!isset($_GET['id'])) { $query = "SELECT * FROM ncmr WHERE id = '$id'"; } else { $query = "SELECT * FROM ncmr WHERE id = '" . $_GET['id'] . "'"; } $data = mysqli_query($dbc, $query); if (mysqli_num_rows($data) == 1) { // The user row was found so display the user data $row = mysqli_fetch_array($data); echo'<h3 id="NCMR2">Non-Conforming Materials Report (NCMR: ' . $row['NCMR_ID'] . ')</h3>'; echo '<form id="all" method="post">'; echo '<fieldset>'; if (!empty($row['Added_By']) && empty($row['Added_By_Date'])) { echo '<div id="ab"><span class="b">Added By: </span>' . $row['Added_By'] . '</div>'; echo '<div id="abd"><span class="b">On: </span>' . $row['Added_By_Date'] . '</div>'; } echo '<div id="box">'; echo '<div id="box1">'; if (!empty($row['Nexx_Part']) && !empty($row['Nexx_Rev']) && !empty($row['Nexx_Part_Description']) && !empty($row['NCMR_Qty'])) { echo '<div id="np"><span class="b">Nexx Part: </span>' . $row['Nexx_Part'] . '</div>'; echo '<div id="nr"><span class="b">Nexx Rev: </span>' . $row['Nexx_Rev'] . '</div>'; echo '<div id="npd"><span class="b">Nexx Part Description: </span>' . $row['Nexx_Part_Description'] . '</div>'; echo '<div id="ncqt"><span class="b">NCMR Qty: </span>' . $row['NCMR_Qty'] . '</div>'; } echo '<div id ="JSI">'; if (!empty($row['JO']) && !empty($row['SN']) && !empty($row['INV'])) { echo '<div id="JO"><span class="b">JO: </span><br />' . $row['JO'] . '</div>'; echo '<div id="SN"><span class="b">SN: </span><br />' . $row['SN'] . '</div>'; echo '<div id="INV"><span class="b">INV: </span><br />' . $row['INV'] . '</div>'; } echo '</div>'; echo '</div>'; echo '<div id="box4-1">'; // We know both $ncmrsr AND $ncmrsc are blank $row['ncmrsr'] = trim($row['ncmrsr']); $row['ncmrsc'] = trim($row['ncmrsc']); if (empty($row['ncmrsr']) && empty($row['ncmrsc'])) { // add comments. echo '<div id="ncmrsr"><span class="b">NCMR Supplier Response:<br /></span><textarea name="ncmrsr" rows="6" cols="85" ></textarea></div><br />'; echo '<div id="ncmrsc"><span class="b">NCMR Supplier Comment:<br /></span><textarea name="ncmrsr" rows="6" cols="85" ></textarea></div><br />'; echo '<div id="button"><input type="submit" name="submit" value="Enter Comments" /></div>'; } else { // echo the two fields. if (!empty($row['ncmrsr']) && !empty($row['ncmrsc'])) { echo '<div id="ncmrsr"><span class="b">NCMR Supplier Response: </span>' . $row['ncmrsr'] . '</div>'; echo '<div id="ncmrsc"><span class="b">NCMR Supplier Comment: </span>' . $row['ncmrsc'] . '</div>'; } echo '</div>'; echo '</div>'; echo '</div>'; echo '</fieldset>'; echo '</form>'; mysqli_close($dbc); } } } ?> </body> </html> Code (markup):
Solved it: http://kaboomlabs.com/PDI/1.php?id=2 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>PDI NCMR - View</title> <link rel="stylesheet" type="text/css" href="CSS/view.css" /> </head> <body> <div id="logo"> <img src="images/PDI_Logo_2.1.gif" alt="PDI Logo" /> </div> <?php require_once('connectvars.php'); // Connect to the database $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); // Grab the profile data from the database if (!isset($_GET['id'])) { $query = "SELECT * FROM ncmr WHERE id = '$id'"; } else { $query = "SELECT * FROM ncmr WHERE id = '" . $_GET['id'] . "'"; } $data = mysqli_query($dbc, $query); if (mysqli_num_rows($data) == 1) { // The user row was found so display the user data $row = mysqli_fetch_array($data); echo'<h3 id="NCMR2">Non-Conforming Materials Report (NCMR: ' . $row['NCMR_ID'] . ')</h3>'; echo '<form id="all" method="post">'; echo '<fieldset>'; if (!empty($row['Added_By']) && empty($row['Added_By_Date'])) { echo '<div id="ab"><span class="b">Added By: </span>' . $row['Added_By'] . '</div>'; echo '<div id="abd"><span class="b">On: </span>' . $row['Added_By_Date'] . '</div>'; } echo '<div id="box">'; echo '<div id="box1">'; if (!empty($row['Nexx_Part']) && !empty($row['Nexx_Rev']) && !empty($row['Nexx_Part_Description']) && !empty($row['NCMR_Qty'])) { echo '<div id="np"><span class="b">Nexx Part: </span>' . $row['Nexx_Part'] . '</div>'; echo '<div id="nr"><span class="b">Nexx Rev: </span>' . $row['Nexx_Rev'] . '</div>'; echo '<div id="npd"><span class="b">Nexx Part Description: </span>' . $row['Nexx_Part_Description'] . '</div>'; echo '<div id="ncqt"><span class="b">NCMR Qty: </span>' . $row['NCMR_Qty'] . '</div>'; } echo '<div id ="JSI">'; if (!empty($row['JO']) && !empty($row['SN']) && !empty($row['INV'])) { echo '<div id="JO"><span class="b">JO: </span><br />' . $row['JO'] . '</div>'; echo '<div id="SN"><span class="b">SN: </span><br />' . $row['SN'] . '</div>'; echo '<div id="INV"><span class="b">INV: </span><br />' . $row['INV'] . '</div>'; } echo '</div>'; echo '</div>'; echo '<div id="box4-1">'; // We know both $ncmrsr AND $ncmrsc are blank $row['ncmrsr'] = trim($row['ncmrsr']); $row['ncmrsc'] = trim($row['ncmrsc']); if (empty($row['ncmrsr']) && empty($row['ncmrsc'])) { // add comment. echo '<div id="ncmrsr"><span class="b">NCMR Supplier Response:<br /></span><textarea name="ncmrsr" rows="6" cols="85" ></textarea></div><br />'; echo '<div id="ncmrsc"><span class="b">NCMR Supplier Comment:<br /></span><textarea name="ncmrsr" rows="6" cols="85" ></textarea></div><br />'; echo '<div id="button"><input type="submit" name="submit" value="Submit" /></div>'; } else { // echo the two fields. if (!empty($row['ncmrsr']) && !empty($row['ncmrsc'])) { echo '<div id="ncmrsr"><span class="b">NCMR Supplier Response: </span>' . $row['ncmrsr'] . '</div>'; echo '<div id="ncmrsc"><span class="b">NCMR Supplier Comment: </span>' . $row['ncmrsc'] . '</div>'; } echo '</div>'; echo '</div>'; echo '</div>'; echo '</fieldset>'; echo '</form>'; } } // End of check for a single row of user results else { echo '<p class="error">Please contact the web administrator, there seems to be an error!</p>'; } mysqli_close($dbc); ?> </body> </html> Code (markup):