using a recordset to pre-fill my product information form - undefined index warnings?
Have created a standard admin page with a link to an UPDATE form, the row id being passed as a querystring.
I've got a recordset on the UPDATE form page which filters the database table using the querystring value passed from the previous page and I've populated the form fields with values from the recordset however when I get to the UPDATE form page almost all of the form fields have the following within them (specific to each field):
br /><b>Notice</b>: Undefined index: LEDtitlemeta in <b>/home/linweb27/l/ledwarehouseuk.com/user/htdocs/ledADMIN/editprod.php</b> on line <b>339</b><br />
If I turn error reporting off (I have <?php error_reporting(E_ALL); ini_set('display_errors','on'); ?> at the very start of the page) then these errors disappear but I'd rather there weren't any errors on the page.
Also the errors seems to affect, for example, drop down menus in that regardless of what the value from the recordset is for one of the drop down menu fields the first value from the drop down menu is displayed. Like it's not picking up on the recordset value at all?
Here's an example of one of the drop down menus:
<select name="LEDtypeID" id="LEDtypeID">
<?php
do {
?>
<option value="<?php echo $row_rsCATEGORY['LEDtypeID']?>"<?php if (!(strcmp($row_rsCATEGORY['LEDtypeID'], $row_rsEDITPROD['LEDtypeID']))) {echo "selected=\"selected\"";} ?>><?php echo $row_rsCATEGORY['LEDtypename']?></option>
<?php
} while ($row_rsCATEGORY = mysql_fetch_assoc($rsCATEGORY));
$rows = mysql_num_rows($rsCATEGORY);
if($rows > 0) {
mysql_data_seek($rsCATEGORY, 0);
$row_rsCATEGORY = mysql_fetch_assoc($rsCATEGORY);
}
?>
</select>
I attach the two pages in question and details of how to log in to the admin system in the private section below.
Thank you.