piskie

I need to produce a list of All the different "Makes" in a Temporary Recordset. Each "Make" will apear a number of times in the Recordset but I only want each make to appear in the list once. Can anybody guide me to how I can achieve this please. I have pasted (basic) code below. I would very much prefer it to be achieved in the In Body Code only if possible. List Item "Repeat Region" code: <?php do { ?> <li><?php echo $row_LISTMAKES['make']; ?></li> <?php } while ($row_LISTMAKES = mysql_fetch_assoc($LISTMAKES)); ?> Temporary Recordset produced by: <?php require_once('Connections/WEBSITE.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $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; } } $colname_LISTMAKES = "-1"; if (isset($_GET['100'])) { $colname_LISTMAKES = (get_magic_quotes_gpc()) ? $_GET['100'] : addslashes($_GET['100']); } mysql_select_db($database_WEBSITE, $WEBSITE); $query_LISTMAKES = sprintf("SELECT * FROM DEALERS WHERE reference = %s ORDER BY make ASC", GetSQLValueString($colname_LISTMAKES, "int")); $LISTMAKES = mysql_query($query_LISTMAKES, $WEBSITE) or die(mysql_error()); $row_LISTMAKES = mysql_fetch_assoc($LISTMAKES); $totalRows_LISTMAKES = mysql_num_rows($LISTMAKES); ?>

The form has 14 fields. Some Text and some Hidden. It also has several image file upload, resize and rename fields and functions. All this happens on "Submit". I want to add the Merchants Code to the Product Code with the least complications possible. When the Submit Button operates, there's a lot going on and I don't feel able to intercept just the "code" value and modify it and then continue to submit. I am hoping for some function or other to be include around the Insert Function: $ins_stock->addColumn("code", "STRING_TYPE", "POST", "code");

I am storing product details in a MYSQL Table. This is to hold Multiple Merchants each with their own Merchant Code. Each Product code must be Unique. To achieve this but still allow each Merchant to freely assign his own Product Code system I need to prefix the entered Product Code with the appropriate Merchant Code. The Merchant Admin uses php forms and the product code field is: <input type="text" name="code" id="code" value="<?php echo KT_escapeAttribute($row_rsstock['code']);?>" size="12" /> The insert function in the head of the page is: $ins_stock->addColumn("code", "STRING_TYPE", "POST", "code"); For example I would like a product code ABC123 entered by Merchant D100 to automatically become: D100-ABC123 on insert. I also need to prevent the automatically inserted prefix being overtyped in the form field. As I am very much a beginner in PHP & MYSQL, a simple expression would be preferred with enough info for me to impliment with my limited knowledge. Thanks in advance.