Newbie is trying to edit a mysql record on my local machine using mysql 3.23.34 and PHP 4.04 and nothing gets updated after changes are made. I would be most grateful for any help Thank you Gee.
<html> <head> </head> <body> <table border=0 cellpadding=4 cellspacing=0 width=730 align=center> <? echo "<form method='post' action='$PHP_SELF'>"; ?> <? include("matai.inc"); mysql_connect(localhost,$user,$password); $query1 = "select * from $table where id = '$id'"; $result1 = mysql_db_query('matai',$query1); while($row = mysql_fetch_object($result1)) { print "<tr><td align=right>Latin Name:</td><td align=left> <input type=text name='latin_name' value='$row->latin_name'></td></tr>"; print "<tr><td align=right>Common Name:</td><td align=left> <input type=text name='common_name' value='$row->common_name'></td></tr>"; print "<tr><td align=right>Description:</td><td align=left> <input type=text name='description' value='$row->description'></td></tr>"; print "<tr><td align=right>Height:</td><td align=left> <input type=text name='height' value='$row->height'></td></tr>"; print "<tr><td align=right>Growth Rate:</td><td align=left> <input type=text name='growth_rate' value='$row->growth_rate'></td></tr>"; print "<tr><td align=right>Soil Requirement:</td><td align=left> <input type=text name='soil_requirement' value='$row->soil_requirement'></td></tr>"; print "<tr><td align=right>Price 100:</td><td align=left> <input type=text name='price100' value='$row->price100'></td></tr>"; print "<tr><td align=right>Price 200:</td><td align=left> <input type=text name='price200' value='$row->price200'></td></tr>"; print "<tr><td align=right>Price 1000:</td><td align=left> <input type=text name='price1000' value='$row->price1000'></td></tr>"; $id = $row->id; } echo "</table><p>"; echo "<br><input type=hidden name='id' value='$id'>"; ?> <table border=0 cellpadding=4 cellspacing=0 width=730 align=center> <input type=submit name="change" value="Update record"> </form> <? if ($change) { //Do some error-checking first if($latin_name == "" || $common_name == "" ) { die("<b>You left one or more fields blank.</b>"); } $sql = "UPDATE matai SET cat='$cat', latin_name='$latin_name', common_name='$common_name', description='$description', height='$height', growth_rate='$growth_rate', soil_requirement='$soil_requirement', price='$price', frost_tolerance='$frost_tolerance', price100='$price100', price1000='$price1000', onelitretubes='$onelitretubes', price200='$price200', fivelitrepots='$fivelitrepots', price10='$price10', Flowering_Season='$Flowering_Season', price500='$price500' where id='$id'"; mysql_db_query('matai',$sql); echo "<b>Your record has been updated</b></p>"; } mysql_close(); ?> <a href='modconifers.php'><b>View updated database</b></a> </table> </body> </html> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]