cmaclennan

Yep all the tables im using are on the same database and its the only one the site connects too and there is only the one table with that name and it enters the parts (2nd part of query) but not the first.

Sorry one other thing i have just noticed the form submits to 2 tables and the data is going into the second table ok but not the first, below is the query. // Make the query. $query = "INSERT INTO rma (rma_id, date, store_company, address, address2, city, state_prov, zip_postal, country, phone, ext, contact) VALUES ('$ri', '$dt', '$co', '$ad' , '$ad2', '$ct', '$sp', '$zp', '$cou', '$ph', '$ex', '$cn')"; $result = @mysql_query ($query); // Run the query. $rma_id = mysql_insert_id(); $result = @mysql_query ($query); // Run the query. foreach($_POST as $key => $value) { //looping through all posted fields if(strpos($key, 'item_') !== false) { //found a part field, need to find out the _x number, then insert the entire row $suffix = substr($key, -1); //this gets the _x number $item = $_POST['item_' . $suffix]; $description = $_POST['description_' . $suffix]; $qty = $_POST['qty_' . $suffix]; $serial = $_POST['serial_' . $suffix]; $mfg = $_POST['mfg_' . $suffix]; $tariff = $_POST['tariff_' . $suffix]; $value = $_POST['value_' . $suffix]; $query = "INSERT INTO rma_parts (item, description, qty, serial, mfg, tariff, value, rma_id) VALUES ('$item', '$description', '$qty', '$serial', '$mfg', '$tariff', '$value', '$rma_id')"; $result = mysql_query($query); } } if ($result) { // If it ran OK. // Send an email, if desired. // Print a message. echo '<h1 id="mainhead">Thank you!</h1> <p>Your entry has now been registered.</p><p><br /></p>'; // Include the footer and quit the script (to not show the form). exit(); } else { // If it did not run OK. echo '<h1 id="mainhead">System Error</h1> <p class="error">Your entry could not be registered due to a system error. We apologize for any inconvenience.</p>'; // Public message. echo '<p>' . mysql_error() . '<br /><br />Query: ' . $query . '</p>'; // Debugging message. exit(); } mysql_close(); // Close the database connection. } else { // Report the errors. echo '<h1>Error!</h1> <p class="error">The following error(s) occurred:<br />'; foreach ($errors as $msg) { // Print each error. echo " - $msg<br />\n"; } echo '</p><p>Please try again.</p><p><br /></p>'; } // End of if (empty($errors)) IF. } // End of the main Submit conditional.

Hey Guys, I have a form that at one time was submitting to a database as it should and for some reason it is submitting ok and not giving any kind of errors yet the data isnt ending up in the table?? What could i be missing? when I echo out the statement to see if the data is being posted by the script everything shows up normal but it's not getting entered. Thanks for your help

Hi Guys, I have a form i'm trying to use to submit data to 2 seperate tables and i keep getting errors and i have no idea why as i have only slightly modified the query from another one i have used succesfully, if someone can take a look at it for me and let me know what im missing it would be a huge help. // Make the query. $query = "INSERT INTO rma (rma_id, date, store_company, city, address, address2, state_prov, zip_postal, country, phone, ext, contact) VALUES ('$ri', '$dt', '$co', '$ct' , '$ad', '$ad2', '$sp', '$zp', '$cou', '$ph', '$ex', '$cn')"; $result = @mysql_query ($query); // Run the query. $rma_id = mysql_insert_id(); $result = @mysql_query ($query); // Run the query. foreach($_POST as $key => $value) { //looping through all posted fields if(strpos($key, 'item_') !== false) { //found a part field, need to find out the _x number, then insert the entire row $suffix = substr($key, -1); //this gets the _x number $item = $_POST['item_' . $suffix]; $description = $_POST['description_' . $suffix]; $qty = $_POST['qty_' . $suffix]; $serial = $_POST['serial_' . $suffix]; $mfg = $_POST['mfg_' . $suffix]; $tariff = $_POST['tariff_' . $suffix]; $value = $_POST['value_' . $suffix]; $query = "INSERT INTO rma_parts (id, item, description, qty, serial, mfg, tariff, value, rma_id) VALUES ('', '$item', '$description', '$qty', '$serial', '$mfg', '$tariff', 'value', '$rma_id')"; $result = mysql_query($query); } } if ($result) { // If it ran OK.

Thanks a lot

Hi Guys, I'm looking for some assistance in pulling data from 2 seperate tables and im not sure how to go about it, whether i can run multiple select queries or if i need to do something else. Your help is appreciated. Thanks

Ok so when I hit submit to update the record it seems to be running the SELECT query?

sorry having some difficulty getting it to show the query

Hi Guys, Sorry for posting all of the code right off the bat wasnt to sure what part was relevant or may have been causing the issue, and the select statement is pulling directly from the ticket_id selected on the search page, essentially the search page gives a list of entries and next to each is an edit link which then comes to the page i posted all of the data populates as it should i am just unable to submit it as it says the id is already registered. Thanks again.

I have a page that I'm trying to use to edit a ticket from a mysql database entry but for some reason I keep getting my generated error that i cannot update it due to the ticket number already being registered? Can anyone tell me what i'm missing here? Thanks $page_title = 'Edit a Ticket'; include ('style.html'); // Check for a valid Ticket ID, through GET or POST. if ( (isset($_GET['id'])) ) { // Accessed through parts_search.php $id = $_GET['id']; } elseif ( (isset($_POST['id'])) ) { // Form has been submitted. $id = $_POST['id']; } else { // No valid ID, kill the script. echo '<div id="title">Page Error</div> <p class="error">This page has been accessed in error.</p><p><br /><br /></p>'; exit(); } require_once ('mysql_connect.php'); // Connect to the db. // Check if the form has been submitted. if (isset($_POST['submitted'])) { $errors = array(); // Initialize error array. // Trim Name { $nm = trim($_POST['name']); } // Trim Email { $em = trim($_POST['email']); } // Trim Contact { $cn = trim($_POST['contact']); } // Trim Contact Email { $ce = trim($_POST['c_email']); } // Trim Phone { $ph = trim($_POST['phone']); } // Trim Ext { $ex = trim($_POST['ext']); } // Trim Store ID { $si = trim($_POST['store_id']); } // Trim Address { $ad = trim($_POST['address']); } // Trim Status { $st = trim($_POST['status']); } // Trim Priority { $pi = trim($_POST['priority']); } // Trim Serial { $se = trim($_POST['serial']); } // Trim Issue { $is = trim($_POST['issue']); } // Trim Original Date { $od = trim($_POST['o_date']); } // Trim Notes { $nt = trim($_POST['notes']); } if (empty($errors)) { // If everything's OK. // Test for unique cart serial. $query = "SELECT ticket_id FROM tickets WHERE ticket_id='$id'"; $result = mysql_query($query); if (mysql_num_rows($result) == 0) { // Make the query. $query = "UPDATE tickets SET name='$nm', email='$em', contact='$cn', c_email='$ce', phone='$ph', ext='$ex', store_id='$si', address='$ad', status='$st', priority='$pi', serial='$se', issue='$is', o_date='$od', notes='$nt' WHERE ticket_id='$id'"; $result = @mysql_query ($query); // Run the query. if (mysql_affected_rows() == 1) { // If it ran OK. // Print a message. echo '<div id="title">Success!</div> <p>The Ticket has been edited.</p><p><br /><br /></p>'; } else { // If it did not run OK. echo '<div id="title">System Error</div> <p class="error">The ticket could not be edited due to a system error. We apologize for any inconvenience.</p>'; // Public message. echo '<p>' . mysql_error() . '<br /><br />Query: ' . $query . '</p>'; // Debugging message. exit(); } } else { // Already registered. echo '<div id="title">Error!</div> <p class="error">The ticket has already been registered.</p>'; } } else { // Report the errors. echo '<div id="title">Error!</div> <p class="error">The following error(s) occurred:<br />'; foreach ($errors as $msg) { // Print each error. echo " - $msg<br />\n"; } echo '</p><p>Please try again.</p><p><br /></p>'; } // End of if (empty($errors)) IF. } // End of submit conditional. // Always show the form. // Retrieve the user's information. $query = "SELECT name, email, contact, c_email, phone, ext, address, store_id, status, priority, serial, issue, o_date, notes FROM tickets WHERE ticket_id='$id'"; $result = @mysql_query ($query); // Run the query. if (mysql_num_rows($result) == 1) { // Valid Ticket ID, show the form. // Get the user's information. $row = mysql_fetch_array ($result, MYSQL_NUM); // Create the form. echo '<div id="title">Edit Ticket: ' . $id . '</div> <form action="ticket_edit.php" method="post"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td>Name:</td><td><input type="text" name="name" size="15" maxlength="30" value="' . $row[0] . '" /></td> </tr> <tr> <td>Email:</td><td><input type="text" name="email" size="20" maxlength="100" value="' . $row[1] . '" /> </td> </tr> <tr> <td>Contact:</td><td><input type="text" name="contact" size="20" maxlength="40" value="' . $row[2] . '" /> </td> </tr> <tr> <td>Contact Email:</td><td><input type="text" name="c_email" size="20" maxlength="40" value="' . $row[3] . '" /> </td> </tr> <tr> <td>Phone:</td><td><input type="text" name="phone" size="20" maxlength="40" value="' . $row[4] . '" /> </td> </tr> <tr> <td>Ext:</td><td><input type="state_prov" name="ext" size="15" maxlength="15" value="' . $row[5] . '" /></td> </tr> <tr> <td>Address:</td><td><input type="text" name="address" size="15" maxlength="15" value="' . $row[6] . '" /></td> </tr> <tr> <td>Store ID:</td><td><input type="text" name="store_id" size="15" maxlength="15" value="' . $row[7] . '" /></td> </tr> <tr> <td>Status:</td><td><label> <select name="status" id="status"> <option selected="selected">Open</option> <option>Closed</option> </select> </label></td> </tr> <tr> <td>Priority:</td><td><label> <select name="priority" id="priority"> <option>1. Critical</option> <option>2. High</option> <option selected="selected">3. Normal</option> <option>4. Low</option> </select> </label></td> </tr> <tr> <td>Issues:</td><td><label> <select name="issue" id="issue"> <option selected="selected">General Support</option> <option>Spare Parts</option> <option>ABC Issues</option> <option>Charger Issues</option> <option>Inverter Issues</option> <option>Battery Issues</option> <option>Other</option> </select> </label></td> </tr> <tr> <td>Serial:</td><td><input type="text" name="serial" size="15" maxlength="15" value="' . $row[10] . '" /></td> </tr> <tr> <td>Original Date:</td><td><input type="text" name="o_date" size="15" maxlength="15" value="' . $row[12] . '" /></td> </tr> <tr> <td>Notes:</td><td><label> <textarea name="notes" id="notes" cols="60" rows="5">' . $row[13] . '</textarea> </label></td> </tr> <tr> <td><input type="submit" name="submit" value="Submit" /><input type="hidden" name="submitted" value="TRUE" /></td> <td><input type="hidden" name="id" value="' . $id . '" /></td></tr> </form>'; } else { // Not a valid Customer ID. echo '<div id="title">Page Error</div> <p class="error">This page has been accessed in error.</p><p><br /><br /></p>'; } mysql_close(); // Close the database connection. ?>

Thanks that worked, much appreciated as always.

Hi Guys, Hoping someone can shed some light on this for me I have a page to search for open tickets in a database but I get the warning when i load the page: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\open_search.php on line 25 here is the portion of code I am working with around line 25. // Count the number of records $query = "SELECT COUNT(*) FROM tickets WHERE status='Open' ORDER BY category ASC"; $result = @mysql_query ($query); $row = mysql_fetch_array ($result, MYSQL_NUM); $num_records = $row[0]; Thanks in advance for your help.

Ok Well as I understand it I need to have a customer_id field in the customer table, a shipping_id field in the shipping table and a order_id field in the order table all as primary keys, now in order for me to bring up when searching all the parts associated with an order i need the order_id to be inserted into the parts table and the customer and shipping id's to be inserted into the order table so that all the info comes up when searched for, so if on the first insert query the customer_id is generated how do i insert that into the order table? hope that all makes sense.

how do i insert the id's from the previous table to the next to link them?

Hi Guys, Hoping you can help me out here I have a large form that is acting as an order log there are 4 parts to the form, customer details, shipping details, order details and then the parts section I need to insert all the data into their respective tables with the ID's linking all of them together for searching? I have the form done I'm just stuck on the inserting portion at the moment. Any help is greatly appreciated. Thanks in Advance.

Thanks for your help, just a couple of things, when setting up or designing the form I know I have seen instances on forms where a button or link can trigger the addition of a row for example to add more parts do you know how this is done? (Ajax or something?) also when setting up with multiple tables this way and creating the relationships between the ID's how do you set the form to submit to the right table and in the instances where there is more than one row for the products is it just handled as if submitting multiple forms to the table? Hope that made sense. Thanks Again

Hey Guys, First off I just want to say I love this forum, and everyone thats out there offering there expertise to those of us that need it. The problem I'm having is that I am trying to create a form that submits to a MySQL Database the form is to log all of the orders that my company processes, currently they are using a large and very ugly excel sheet. The main part i'm having difficulty wrapping my head around is how to incorporate all the necessary fields it has to have all the necessary customer details & invoice numbers and then be able to store the part number & quantity the only thing is that it could be anywhere from 1 part to 40. Any help or suggestions on how to build this would be greatly appreciated. Thanks in Advance. C

Hey there, Ok so I went through and mad sure there were no short tags and have now come up with a new error: Warning: Call-time pass-by-reference has been deprecated in C:\wamp\www\service\lib\site.php on line 143 Warning: Call-time pass-by-reference has been deprecated in C:\wamp\www\service\lib\common.php on line 732 Fatal error: Cannot redeclare fputcsv() in C:\wamp\www\service\lib\common.php on line 948

Thanks Again for all your help, I'll net you know if I run into any issues.

Attached is the site.php file and if I found all of the fputcsv tags and replaced them with an alternate name that would get around the version issue? [attachment deleted by admin]

Ok here is the Index.php file exactly as it is: <?php //define("PB_CRYPT_LINKS" , 1); define("_LIBPATH","./lib/"); require_once _LIBPATH . "site.php"; $site = new CSite("./site.xml",true); $site->Run(); ?> And this is the error I got on the our hosted site. Fatal error: Cannot redeclare fputcsv() in /homepages/24/d264498493/htdocs/service1/lib/common.php on line 948

Ok so I have been looking around at a number of different open source solutions to a web based service management/ticketing system and came across one that i wanted to give a go. There is next to no information whatsoever available on it and when I installed based in the readme file both on my local WAMP test site and on our hosted site both times I have come up with errors and am unable to get anywhere with it, I'm wondering if I post the screen I'm getting someone here may know what the problem is or if perhaps I have something turned of on my local installation that I should have on? ] * @since PHPbase 0.0.1 */ $_SITE_IDENTITY_CODE = "L1SMPBOD"; session_start(); //error_reporting(0); require_once _LIBPATH . "common.php"; require_once _LIBPATH . "xml.php"; require_once _LIBPATH . "template.php"; require_once _LIBPATH . "config.php"; require_once _LIBPATH . "html.php"; require_once _LIBPATH . "database.php"; require_once _LIBPATH . "vars.php"; require_once _LIBPATH . "library.php"; require_once _LIBPATH . "sqladmin.php"; require_once _LIBPATH . "forms.php"; class CBase { /** * description * * @var type * * @access type */ var $html; } class CSite { /** * description * * @var type * * @access type */ var $admin; /** * description * * @var type * * @access type */ var $html; /** * description * * @param * * @return * * @access */ function CSite($xml , $admin = false) { global $_CONF , $base; $this->admin = $admin; //loading the config $tmp_config = new CConfig($xml); $_CONF = $tmp_config->vars["config"]; //loading the templates if ($this->admin) { if (is_array($_CONF["templates"]["admin"])) { foreach ($_CONF["templates"]["admin"] as $key => $val) { if ($key != "path") $this->templates[$key] = new CTemplate($_CONF["templates"]["admin"]["path"] . $_CONF["templates"]["admin"][$key]); } } } else { if (is_array($_CONF["templates"])) { foreach ($_CONF["templates"] as $key => $val) { if (($key != "path" ) && ($key != "admin")) $this->templates[$key] = new CTemplate($_CONF["templates"]["path"] . $_CONF["templates"][$key]); } } } $base = new CBase(); $base->html = new CHtml(); $this->html = &$base->html; //make a connection to db if (is_array($_CONF["database"])) { $this->db = new CDatabase($_CONF["database"]); //vars only if needed if ($_CONF["tables"]["vars"]) { $this->vars = new CVars($this->db , $_CONF["tables"]["vars"]); $base->vars = &$this->vars; } $this->tables = &$_CONF["tables"]; } } function TableFiller($item) { if (file_exists("pb_tf.php")) { include("pb_tf.php"); } } /** * description * * @param * * @return * * @access */ function Run() { global $_TSM , $_SITE_IDENTITY_CODE ; if (file_exists("pb_events.php")) { include("pb_events.php"); $_TSM["PB_EVENTS"] = @DoEvents(&$this); } if (is_object($this->templates["layout"])) { echo $this->templates["layout"]->Replace($_TSM) . $_SITE_IDENTITY_CODE ; } } } ?> Fatal error: Class 'CSite' not found in C:\wamp\www\service\index.php on line 7 You guys have been a great help in the past so once again thanks in advance and anythign you can tell me is appreciated. ( I have tried to contact the guy who made it but am not having much luck in that dept either.) Thanks C

Thank you, your a life saver I figured it had to be something i was missing.

Hi Guys, I'm new here and am really hoping someone can offer me a bit of assistance as I'm not sure what I'm missing. I am/have created a page for my company to log serial numbers of our products before they are sent out, I have thus far been able to create the form have it submit to the database and when the values contain only numbers I am able to search them and edit them as necessary, however when the values contain a letter and number combination I can search but am not able to edit anything. The error I believe or would assume is on the edit page?? Below is the code from the edit page, really hoping someone can help I'm kind of running out of time/patience at this point. <?php $page_title = 'Edit a node'; include ('style.html'); // Check for a valid Node ID, through GET or POST. if ( (isset($_GET['id'])) ) { // Accessed through active_search.php $id = $_GET['id']; } elseif ( (isset($_POST['id'])) ) { // Form has been submitted. $id = $_POST['id']; } else { // No valid ID, kill the script. echo '<div id="title">Page Error</div> <p class="error">This page has been accessed in error.</p><p><br /><br /></p>'; exit(); } require_once ('mysql_connect.php'); // Connect to the db. // Check if the form has been submitted. if (isset($_POST['submitted'])) { $errors = array(); // Initialize error array. // Check for a Master Serial. if (empty($_POST['master_serial'])) { $errors[] = 'You forgot to enter the Master Serial.'; } else { $ms = trim($_POST['master_serial']); } // Check for a Charger Serial. if (empty($_POST['charger'])) { $errors[] = 'You forgot to enter the Charger Serial.'; } else { $ch = trim($_POST['charger']); } // Check for a Battery Serial. if (empty($_POST['battery'])) { $errors[] = 'You forgot to enter the Battery Serial.'; } else { $bt = trim($_POST['battery']); } // Trim address2 #{ # $ad2 = trim($_POST['address2']); #} // Check for a ABC Serial. if (empty($_POST['abc'])) { $errors[] = 'You forgot to enter the ABC Serial.'; } else { $abc = trim($_POST['abc']); } // Check for a DC Serial. if (empty($_POST['dc1'])) { $errors[] = 'You forgot to enter the 1st DC Serial.'; } else { $dc1 = trim($_POST['dc1']); } // Check for a 2nd DC Serial. if (empty($_POST['dc2'])) { $errors[] = 'You forgot to enter the 2nd DC Serial.'; } else { $dc2 = trim($_POST['dc2']); } // Check for a Radio Serial. if (empty($_POST['radio'])) { $errors[] = 'You forgot to enter a Radio Serial.'; } else { $rd = trim($_POST['radio']); } // Check for a Network Serial. if (empty($_POST['network'])) { $errors[] = 'You forgot to enter the Network Serial.'; } else { $nt = trim($_POST['network']); } // Check for a SR2-1. if (empty($_POST['sr2_1'])) { $errors[] = 'You forgot to enter the SR2-1 Serial.'; } else { $sr2 = trim($_POST['sr2_1']); } // Check for a SR2-2. if (empty($_POST['sr2_2'])) { $errors[] = 'You forgot to enter the SR2-2 Serial.'; } else { $sr21 = trim($_POST['sr2_2']); } // Check for a SR5-1. if (empty($_POST['sr5_1'])) { $errors[] = 'You forgot to enter the SR5-1 Serial.'; } else { $sr5 = trim($_POST['sr5_1']); } // Check for a SR5-2. if (empty($_POST['sr5_2'])) { $errors[] = 'You forgot to enter the SR5-2 Serial.'; } else { $sr51 = trim($_POST['sr5_2']); } // Check for a Ethernet. if (empty($_POST['ethernet'])) { $errors[] = 'You forgot to enter the Ethernet Serial.'; } else { $et = trim($_POST['ethernet']); } if (empty($errors)) { // If everything's OK. // Test for unique master serial. $query = "SELECT master_serial FROM activecontrol WHERE master_serial=$id"; $result = mysql_query($query); if (mysql_num_rows($result) == 0) { // Make the query. $query = "UPDATE activecontrol SET master_serial='$ms', charger='$ch', battery='$bt', abc='$abc', dc1='$dc1', dc2='$dc2', radio='$rd', network='$nt', sr2_1='$sr2', sr2_2='$sr21', sr5_1='$sr5', sr5_2='$sr51', ethernet='$et' WHERE master_serial=$id"; $result = @mysql_query ($query); // Run the query. if (mysql_affected_rows() == 1) { // If it ran OK. // Print a message. echo '<div id="title">Success!</div> <p>The node has been edited.</p><p><br /><br /></p>'; } else { // If it did not run OK. echo '<div id="title">System Error</div> <p class="error">The node could not be edited due to a system error. We apologize for any inconvenience.</p>'; // Public message. echo '<p>' . mysql_error() . '<br /><br />Query: ' . $query . '</p>'; // Debugging message. exit(); } } else { // Already registered. echo '<div id="title">Error!</div> <p class="error">The Serial has already been registered.</p>'; } } else { // Report the errors. echo '<div id="title">Error!</div> <p class="error">The following error(s) occurred:<br />'; foreach ($errors as $msg) { // Print each error. echo " - $msg<br />\n"; } echo '</p><p>Please try again.</p><p><br /></p>'; } // End of if (empty($errors)) IF. } // End of submit conditional. // Always show the form. // Retrieve the node's information. $query = "SELECT master_serial, charger, battery, abc, dc1, dc2, radio, network, sr2_1, sr2_2, sr5_1, sr5_2, ethernet FROM activecontrol WHERE master_serial=$id"; $result = @mysql_query ($query); // Run the query. if (mysql_num_rows($result) == 1) { // Valid node ID, show the form. // Get the user's information. $row = mysql_fetch_array ($result, MYSQL_NUM); // Create the form. echo '<div id="title">Edit a Node</div> <form action="active_edit.php" method="post"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td>Master Serial:</td><td><input type="text" name="master_serial" size="15" maxlength="15" value="' . $row[0] . '" /></td> </tr> <tr> <td>Charger:</td><td><input type="text" name="charger" size="15" maxlength="30" value="' . $row[1] . '" /></td> </tr> <tr> <td>Battery:</td><td><input type="text" name="battery" size="20" maxlength="40" value="' . $row[2] . '" /> </td> </tr> <tr> <td>ABC:</td><td><input type="text" name="abc" size="20" maxlength="40" value="' . $row[3] . '" /> </td> </tr> <tr> <td>DC 1:</td><td><input type="text" name="dc1" size="20" maxlength="40" value="' . $row[4] . '" /> </td> </tr> <tr> <td>DC 2:</td><td><input type="text" name="dc2" size="20" maxlength="40" value="' . $row[5] . '" /> </td> </tr> <tr> <td>Radio:</td><td><input type="text" name="radio" size="20" maxlength="40" value="' . $row[6] . '" /> </td> </tr> <tr> <td>Network:</td><td><input type="text" name="network" size="20" maxlength="40" value="' . $row[7] . '" /> </td> </tr> <tr> <td>SR2-1:</td><td><input type="text" name="sr2_1" size="20" maxlength="40" value="' . $row[8] . '" /> </td> </tr> <tr> <td>SR2-2:</td><td><input type="text" name="sr2_2" size="20" maxlength="40" value="' . $row[9] . '" /> </td> </tr> <tr> <td>SR5-1:</td><td><input type="text" name="sr5_1" size="20" maxlength="40" value="' . $row[10] . '" /> </td> </tr> <tr> <td>SR5-2:</td><td><input type="text" name="sr5_2" size="20" maxlength="40" value="' . $row[11] . '" /> </td> </tr> <tr> <td>Ethernet:</td><td><input type="text" name="ethernet" size="20" maxlength="40" value="' . $row[12] . '" /> </td> </tr> <tr> <td><input type="submit" name="submit" value="Submit" /><input type="hidden" name="submitted" value="TRUE" /></td> <td><input type="hidden" name="id" value="' . $id . '" /></td></tr> </form>'; } else { // Not a valid user ID. echo '<div id="title">Page Error</div> <p class="error">This page has been accessed in error.</p><p><br /><br /></p>'; } mysql_close(); // Close the database connection. ?> Thanks in advance for any help. C