Re: error
| From: | Karl DeSaulniers | Date: | Fri, 08 Apr 2011 05:57:08 +0000 |
| Subject: | Re: error | ||
| References: | 1 2 3 4 5 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47755@lists.php.net to get a copy of this message | ||
Ooops.
Sry, forgot an escape.
$q = "UPDATE expiringleases SET Cricket_Region = '".mysql_real_escape_string($Cricket_Region)."', Market = ".mysql_real_escape_string($Market)."' WHERE Search_Ring = '".mysql_real_escape_string($id)."'";
mysql_query($q) or die(mysql_error());
Best,
Karl
On Apr 8, 2011, at 12:52 AM, Karl DeSaulniers wrote:
Hi Chris, Try this.. Or season to taste.. $q = "UPDATE expiringleases SET Cricket_Region = '".mysql_real_escape_string($Cricket_Region)."', Market = ".$Market."' WHERE Search_Ring = '".mysql_real_escape_string($id)."'"; mysql_query($q) or die(mysql_error()); Best, Karl On Apr 8, 2011, at 12:13 AM, Chris Stinemetz wrote:Karl DeSaulniers Design Drumm http://designdrumm.com// save the data to the database mysql_query("UPDATE expiringleases SET Cricket_Region='$Cricket_Region', Market='$Market' WHERE Search_Ring='$id'") or die(mysql_error());Karl DeSaulniers Design Drumm http://designdrumm.com --PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php