Hi All, I have this php code: <style type="text/css"> .Headin_1 { text-align: center; } </style> <div> <p class="Headin_1">XXXXXXXXX </p> <p> </p> <p> </p> </div> <p> </p> <div> <p> </p> <p> </p> <form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1"> <table align="center"> <tr valign="baseline"> <td nowrap="nowrap" align="right">Sunetid:</td> <td><input type="text" name="sunetid" value="" size="32" /></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right">First_name:</td> <td><input type="text" name="first_name" value="" size="32" /></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right">Last_name:</td> <td><input type="text" name="last_name" value="" size="32" /></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right">Email:</td> <td><input type="text" name="email" value="" size="32" /></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right">Phone:</td> <td><input type="text" name="phone" value="" size="32" /></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right" valign="top">Reported_issue:</td> <td><textarea name="Reported_issue" cols="50" rows="5"></textarea></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right">Status:</td> <td><input type="text" name="Status" value="New" size="32" /></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right">Operating_system:</td> <td><input type="text" name="Operating_system" value="" size="32" /></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right">Date_created:</td> <td><input type="text" name="date_created" value="" size="32" /></td> </tr> <tr valign="baseline"> <td nowrap="nowrap" align="right"> </td> <td><input type="submit" value="Insert record" /></td> </tr> </table> <input type="hidden" name="MM_insert" value="form1" /> </form> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> </div> <p> </p> <?php require_once('Connections/mysqlebi.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; } $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? doubleval($theValue) : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']); } if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) { $insertSQL = sprintf("INSERT INTO helpu (sunetid, first_name, last_name, email, phone, Reported_issue, Status, Operating_system, date_created) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)", GetSQLValueString($_POST['sunetid'], "text"), GetSQLValueString($_POST['first_name'], "text"), GetSQLValueString($_POST['last_name'], "text"), GetSQLValueString($_POST['email'], "text"), GetSQLValueString($_POST['phone'], "text"), GetSQLValueString($_POST['Reported_issue'], "text"), GetSQLValueString($_POST['Status'], "text"), GetSQLValueString($_POST['Operating_system'], "text"), GetSQLValueString($_POST['date_created'], "date")); mysql_select_db($database_mysqlebi, $mysqlebi); $Result1 = mysql_query($insertSQL, $mysqlebi) or die(mysql_error()); $insertGoTo = "thanks.html"; if (isset($_SERVER['QUERY_STRING'])) { $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?"; $insertGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $insertGoTo)); } mysql_select_db($database_mysqlebi, $mysqlebi); $query_Recordset1 = "SELECT * FROM employee"; $Recordset1 = mysql_query($query_Recordset1, $mysqlebi) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysql_num_rows($Recordset1); /*set varibles from form */ $searchterm = $_POST['searchterm']; trim ($searchterm); /*check if search term was entered*/ if (!$searchterm){ echo 'Please enter a search term.'; } /*add slashes to search term*/ if (!get_magic_quotes_gpc()) { $searchterm = addslashes($searchterm); } ////////////////////database mysql connection/////////// $con = mysql_connect("localhost","abk","*****"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("psycdb", $con); $result = mysql_query("select * from employee where sunetid like '%".$searchterm."%'"); /////////////////form format/////////////// echo "<table border='5' > <tr> <th>Sunetid</th> <th>First_name</th> <th>Last_name</th> <th>Phone_Number</th> <th>Email</th> </tr>"; // * database Tables fields name here *//// while($row = mysql_fetch_array($result)) { //you need to type the exact field name coresponding to table's fields// echo "<tr>"; echo "<td>" . $row['sunetid'] . "</td>"; echo "<td>" . $row['first_name'] . "</td>"; echo "<td>" . $row['last_name'] . "</td>"; echo "<td>" . $row['phone_number'] . "</td>"; echo "<td>" . $row['email'] . "</td>"; echo "</tr>"; } echo "</table>"; mysql_close($con); mysql_free_result($Recordset1); ?> Code (markup): I'm trying to redirect the report output into the following fields: if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) { $insertSQL = sprintf("INSERT INTO helpu (sunetid, first_name, last_name, email, phone, Reported_issue, Status, Operating_system, date_created) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)", GetSQLValueString($_POST['sunetid'], "text"), GetSQLValueString($_POST['first_name'], "text"), GetSQLValueString($_POST['last_name'], "text"), GetSQLValueString($_POST['email'], "text"), GetSQLValueString($_POST['phone'], "text"), Code (markup): Thanks for any help,