Posted by IchBin on 09/11/06 22:33

Jeff Gardner wrote:
> Petr Vileta wrote:
>> Jeff Gardner wrote:
>>> One wrote:
>>>> Jeff Gardner wrote:
>>>>> Greetings:
>>>>>
>>>>> I have an UPDATE query (php 5.1.6/mysql 5.0.24a on apache 2.2) that
>>>>> appears to execute with no errors (php,mysql, or apache) but the
>>>>> data in the "UPDATED" table doesn't change. I've checked
>>>>> privileges for connecting account and that isn't an issue. Maybe
>>>>> it's my query: $editO = "
>>>>> UPDATE organization
>>>>> SET
>>>>> orgname = '$name',
>>>>> office = '$off',
>>>>> address1 = '$add1',
>>>>> address2 = '$add2',
>>>>> city = '$city',
>>>>> state = '$state',
>>>>> country = '$country',
>>>>> zip = '$ZIP',
>>>>> phone1 = '$phone1',
>>>>> phone2 = '$phone2',
>>>>> fax = '$fax',
>>>>> email = '$email',
>>>>> website = '$website',
>>>>> notes = '$notes',
>>>>> lasteditdate = '$lastedit',
>>>>> publish = '$pub',
>>>>> updatedby = '$uname'
>>>>> WHERE org_id = '$orgid'";
>>>>>
>>>>> include_once 'dsn.php';
>>>>> $res=mysql_query($editO)
>>>>> or die('Query Failed: ' . mysql_error());
>>>>>
>>>>> I've shuffled it around to get rid of whitespace to no effect. Any
>>>>> advice is appreciated.
>>>>
>>>> Can you echo out the statment being processed and post it as well ?
>>>>
>>> It's from a form that is pre-populated with existing data:
>>>
>>> $org = trim($_POST['name']);
>>> $off = trim($_POST['off']);
>>> $ad1 = trim($_POST['add1']);
>>> $ad2 = trim($_POST['add2']);
>>> $city = trim($_POST['city']);
>>> $state = trim($_POST['state']);
>>> $country = trim($_POST['country']);
>>> $zip = trim($_POST['ZIP']);
>>> $phone1 = trim($_POST['phone1']);
>>> $phone2 = trim($_POST['phone2']);
>>> $fax = trim($_POST['fax']);
>>> $email = trim($_POST['email']);
>>> $website = trim($_POST['website']);
>>> $cleanNotes = htmlspecialchars($_POST['notes']);
>>> $notes = trim($cleanNotes);
>>> $lastedit = date ('D \t\h\e jS \of M Y \@ h:i:s a T');
>>> $pub = trim($_POST['pub']);
>> Isn't some "must be escaped" character in some $_POST[] field? Some
>> stupid characters are:
>> " ' ; \ @
>>
> All input is shot through mysql_escape_string. The same data INSERTS
> properly.
>

Could it be something simple like the mysql_autocommit() is set off?

--
Thanks in Advance...
IchBin, Pocono Lake, Pa, USA http://weconsultants.phpnet.us
'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)

[Back to original message]