Hello,
In ASP you can set records fields then call a dbupdate function.
It appears mysql only supports update with the UPDATE query?
Here is my code:
<?
$sql="SELECT * FROM lsm where ID = ".$HTTP_GET_VARS["ID"];
$result=query($sql);
if (!$result) die('sql error');
$dbrec=getrec($result);
if ($dbrec)
{
$dbrec["Complexname"]=$HTTP_POST_VARS["Complexname"];
$dbrec["Subdivision"]=$HTTP_POST_VARS["Subdivision"];
$dbrec["Beds"]=$HTTP_POST_VARS["Beds"];
$dbrec["BathsTotal"]=$HTTP_POST_VARS["BathsTotal"];
if ($HTTP_POST_VARS["SqFtTotal"]!="")
$dbrec["SqFtTotal"]=$HTTP_POST_VARS["SqFtTotal"];
$dbrec["ListPriceLow"]=$HTTP_POST_VARS["ListPriceLow"];
$dbrec["Streetnum"]=$HTTP_POST_VARS["Streetnum"];
$dbrec["Streetname"]=$HTTP_POST_VARS["Streetname"];
dbrec.update();
}
?>
How would you do a dbrec.update (which updates just the row you changed with the
variables)
thanks
Steve
__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
