Running 3.23.56, from phpmyadmin all works fine. I'm building an admin page, I can add a record, but when I try and update, I get this error:
<ERROR Number="8" Description="Error: "Undefined index: ad_num" on line 26 of /web/home/hovey/public_html/update.php."/> Anyone have any ideas? Here's the code for update.php: <?php require_once("config/include/utils.runtime6.php") ?> <?php require_once("config/include/mysql.runtime6.php") ?> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta http-equiv="content-type" content="text/html;charset=iso-8859-1"> <meta name="keywords" content="San Antonio, used cars, new cars, San Antonio new car dealers, San Antonio used cars, San Antonio new cars, cars, truck, trucks, sale, San Antonio mercedes, mercedes,San Antonio BMW, car dealer, bmw, BMW, ferrari, GMC,San Antonio porsche, porsche, classified, classifieds"> <meta name="content" content="San Antonio Pre-Owned Luxury and Classic Cars - Mercedes - Jaguar - Porsche - Ferrari - BMW - and more!"> <meta name="generator" content="Adobe GoLive 5"> <meta name="description" content="San Antonio Pre-Owned Luxury and Classic Cars - Mercedes - Jaguar - Porsche - Ferrari - BMW - all in San Antonio, South Texas"> <meta name="Copyright" content="Hovey Motorcars of San Antonio Texas"> <TITLE>Hovey Database Update Page</TITLE> <style type="text/css" media="screen"><!-- a:link { color: white;} a:visited { color: white;} a:hover { color: blue;} #layer1 { position: absolute; top: 16px; left: 16px; width: 727px; height: 709px; visibility: visible; display: block } --></style> <?php // GoLive Content Source $NewContentSource = WrapMySQLDatabaseResults("hovey", "select * from table1 where ad_num = '" . $GLOBALS["ad_num"] . "'", "block=1","NewContentSource"); ?> </head> <body bgcolor="white"> <div id="layer1"> <form action='config/actions/mysql.actions6.php?<?php echo URLArgs(array())?>' method="post" name="FormName"> <table width="767" border="0" cellspacing="0" cellpadding="0" cool gridx="16" gridy="16" height="655" showgridx showgridy usegridx usegridy> <tr height="48"> <td width="16" height="654" rowspan="15"></td> <td width="192" height="48"></td> <td content csheight="37" width="496" height="48" colspan="3" valign="top" xpos="208"><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">Edit the record and then click the Update button</font></td> <td width="62" height="240" rowspan="7"></td> <td width="1" height="48"><spacer type="block" width="1" height="48"></td> </tr> <tr height="32"> <td content csheight="19" width="224" height="32" colspan="2" valign="top" xpos="16"> <div align="right"> <font color="black"><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">Ad Number</font></font></div> </td> <td width="32" height="606" rowspan="14"></td> <td width="432" height="32" valign="top" align="left" xpos="272"><input type="text" name='ad_num(<?php echo $NewContentSource->AbsolutePosition()?>)' value='<?php echo fixHTMLquotes($NewContentSource->Value("ad_num")) ?>' size="15" maxlength="15"></td> <td width="1" height="32"><spacer type="block" width="1" height="32"></td> </tr> <tr height="32"> <td content csheight="19" width="224" height="32" colspan="2" valign="top" xpos="16"> <div align="right"> <font color="black"><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">Car Type</font></font></div> </td> <td width="432" height="32" valign="top" align="left" xpos="272"><select name='car_type(<?php echo $NewContentSource->AbsolutePosition()?>)' size="1"> <option value="SUV" <?php echo selected($NewContentSource->Value("car_type") == "SUV") ?>>SUV</option> <option value="Sports" <?php echo selected($NewContentSource->Value("car_type") == "Sports") ?>>Sports</option> <option value="Trucks" <?php echo selected($NewContentSource->Value("car_type") == "Trucks") ?>>Trucks</option> <option value="Luxury" <?php echo selected($NewContentSource->Value("car_type") == "Luxury") ?>>Luxury</option> <option value="Classic" <?php echo selected($NewContentSource->Value("car_type") == "Classic") ?>>Classic</option> </select></td> <td width="1" height="32"><spacer type="block" width="1" height="32"></td> </tr> <tr height="32"> <td content csheight="19" width="224" height="32" colspan="2" valign="top" xpos="16"> <div align="right"> <font color="black"><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">Car Year</font></font></div> </td> <td width="432" height="32" valign="top" align="left" xpos="272"><input type="text" name='car_year(<?php echo $NewContentSource->AbsolutePosition()?>)' value='<?php echo fixHTMLquotes($NewContentSource->Value("car_year")) ?>' size="15" maxlength="4"></td> <td width="1" height="32"><spacer type="block" width="1" height="32"></td> </tr> <tr height="32"> <td content csheight="19" width="224" height="32" colspan="2" valign="top" xpos="16"> <div align="right"> <font color="black"><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">Make</font></font></div> </td> <td width="432" height="32" valign="top" align="left" xpos="272"><input type="text" name='make(<?php echo $NewContentSource->AbsolutePosition()?>)' value='<?php echo fixHTMLquotes($NewContentSource->Value("make")) ?>' size="25" maxlength="25"></td> <td width="1" height="32"><spacer type="block" width="1" height="32"></td> </tr> <tr height="32"> <td content csheight="19" width="224" height="32" colspan="2" valign="top" xpos="16"> <div align="right"> <font color="black"><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">Model</font></font></div > </td> <td width="432" height="32" valign="top" align="left" xpos="272"><input type="text" name='model(<?php echo $NewContentSource->AbsolutePosition()?>)' value='<?php echo fixHTMLquotes($NewContentSource->Value("model")) ?>' size="50" maxlength="50"></td> <td width="1" height="32"><spacer type="block" width="1" height="32"></td> </tr> <tr height="32"> <td content csheight="19" width="224" height="32" colspan="2" valign="top" xpos="16"> <div align="right"> <font color="black"><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">Miles</font></font></div > </td> <td width="432" height="32" valign="top" align="left" xpos="272"><input type="text" name='miles(<?php echo $NewContentSource->AbsolutePosition()?>)' value='<?php echo fixHTMLquotes($NewContentSource->Value("miles")) ?>' size="15" maxlength="15"></td> <td width="1" height="32"><spacer type="block" width="1" height="32"></td> </tr> <tr height="32"> <td content csheight="19" width="224" height="32" colspan="2" valign="top" xpos="16"> <div align="right"> <font color="black"><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">VIN #</font></font> </div> </td> <td width="494" height="32" colspan="2" valign="top" align="left" xpos="272"><input type="text" name='vin(<?php echo $NewContentSource->AbsolutePosition()?>)' value='<?php echo fixHTMLquotes($NewContentSource->Value("vin")) ?>' size="75" maxlength="75"></td> <td width="1" height="32"><spacer type="block" width="1" height="32"></td> </tr> <tr height="96"> <td content csheight="19" width="224" height="96" colspan="2" valign="top" xpos="16"> <div align="right"> <font color="black"><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">Features</font></font></ div> </td> <td width="432" height="96" valign="top" align="left" xpos="272"><textarea name='features(<?php echo $NewContentSource->AbsolutePosition()?>)' rows="4" cols="40"><?php echo $NewContentSource->Value("features") ?></textarea></td> <td width="62" height="382" rowspan="7"></td> <td width="1" height="96"><spacer type="block" width="1" height="96"></td> </tr> <tr height="32"> <td content csheight="19" width="224" height="32" colspan="2" valign="top" xpos="16"> <div align="right"> <font color="black"><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">Body Color</font></font></div> </td> <td width="432" height="32" valign="top" align="left" xpos="272"><input type="text" name='body_color(<?php echo $NewContentSource->AbsolutePosition()?>)' value='<?php echo fixHTMLquotes($NewContentSource->Value("body_color")) ?>' size="25" maxlength="25"></td> <td width="1" height="32"><spacer type="block" width="1" height="32"></td> </tr> <tr height="32"> <td content csheight="19" width="224" height="32" colspan="2" valign="top" xpos="16"> <div align="right"> <font color="black"><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">Interior Color</font></font></div> </td> <td width="432" height="32" valign="top" align="left" xpos="272"><input type="text" name='int_color(<?php echo $NewContentSource->AbsolutePosition()?>)' value='<?php echo fixHTMLquotes($NewContentSource->Value("int_color")) ?>' size="25" maxlength="25"></td> <td width="1" height="32"><spacer type="block" width="1" height="32"></td> </tr> <tr height="32"> <td content csheight="19" width="224" height="32" colspan="2" valign="top" xpos="16"> <div align="right"> <font color="black"><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">Trans Type</font></font></div> </td> <td width="432" height="32" valign="top" align="left" xpos="272"><select name='trans_type(<?php echo $NewContentSource->AbsolutePosition()?>)' size="1"> <option value="Automatic" <?php echo selected($NewContentSource->Value("trans_type") == "Automatic") ?>>Automatic</option> <option value="Manual" <?php echo selected($NewContentSource->Value("trans_type") == "Manual") ?>>Manual</option> <option value="Tiptronic" <?php echo selected($NewContentSource->Value("trans_type") == "Tiptronic") ?>>Tiptronic</option> <option value="5-speed Manual" <?php echo selected($NewContentSource->Value("trans_type") == "5-speed Manual") ?>>5-speed Manual</option> <option value="6-speed Manual" <?php echo selected($NewContentSource->Value("trans_type") == "6-speed Manual") ?>>6-speed Manual</option> </select></td> <td width="1" height="32"><spacer type="block" width="1" height="32"></td> </tr> <tr height="32"> <td content csheight="19" width="224" height="32" colspan="2" valign="top" xpos="16"> <div align="right"> <font color="black"><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">Warranty</font></font></ div> </td> <td width="432" height="32" valign="top" align="left" xpos="272"><input type="text" name='warranty(<?php echo $NewContentSource->AbsolutePosition()?>)' value='<?php echo fixHTMLquotes($NewContentSource->Value("warranty")) ?>' size="50" maxlength="50"></td> <td width="1" height="32"><spacer type="block" width="1" height="32"></td> </tr> <tr height="48"> <td content csheight="19" width="224" height="48" colspan="2" valign="top" xpos="16"> <div align="right"> <font color="black"><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">Engine Type & Size</font></font></div> </td> <td width="432" height="48" valign="top" align="left" xpos="272"><input type="text" name='engine_type(<?php echo $NewContentSource->AbsolutePosition()?>)' value='<?php echo fixHTMLquotes($NewContentSource->Value("engine_type")) ?>' size="50" maxlength="50"></td> <td width="1" height="48"><spacer type="block" width="1" height="48"></td> </tr> <tr height="110"> <td width="224" height="110" colspan="2"></td> <td width="432" height="110" valign="top" align="left" xpos="272"><input type="submit" name="_SubmitChanges" value="Update Record" <?php SetupMySQLUpdate("searchmain.html", '$return', $NewContentSource) ?>></td> <td width="1" height="110"><spacer type="block" width="1" height="110"></td> </tr> <tr height="1" cntrlrow> <td width="16" height="1"><spacer type="block" width="16" height="1"></td> <td width="192" height="1"><spacer type="block" width="192" height="1"></td> <td width="32" height="1"><spacer type="block" width="32" height="1"></td> <td width="32" height="1"><spacer type="block" width="32" height="1"></td> <td width="432" height="1"><spacer type="block" width="432" height="1"></td> <td width="62" height="1"><spacer type="block" width="62" height="1"></td> <td width="1" height="1"></td> </tr> </table> <?php SetupMySQLForm($NewContentSource); ?> </form> </div> <p></p> </body> </html> <?php if (false) { ?><!-- Mock Content "NewContentSource/ad_num" text {} "NewContentSource/car_year" text {} "NewContentSource/make" text {Porsche, Mercedes, etc...} "NewContentSource/model" text {} "NewContentSource/miles" text {} "NewContentSource/vin" text {} "NewContentSource/features" text {<li>text<br> <li>text<br> <li>text<br> <li>text<br> <li>text<br> <li>text<br> <li>text<br> <li>text<br> <li>text<br> <li>text<br> <li>text<br> <li>text<br> lt;li>text<br> } "NewContentSource/body_color" text {} "NewContentSource/int_color" text {} "NewContentSource/warranty" text {} "NewContentSource/engine_type" text {} --><?php } ?> Anyone have any ideas? Thanks, Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]