On 2011-04-08, at 1:57 AM, Karl DeSaulniers <karl@xxxxxxxxxxxxxxx> wrote:
> 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:
>>
>>> // 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
>>
>
> Karl DeSaulniers
> Design Drumm
> http://designdrumm.com
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
Try echoing out the SQL and then runningnit thru some GUI like phpmyadmin. It is usually pretty self evident where the problem is at that point
Bastien Koert
Sent from my iPhone
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
