UPDATE query appears to complete but nothing changes in data

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.

--

Regards,

Jeff Gardner
___________________________

"Contrary to popular belief, Unix is user friendly. It just happens
to be very selective about who its friends are." --Kyle Hearn

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 ?

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']);

--

Regards,

Jeff Gardner
___________________________

"Contrary to popular belief, Unix is user friendly. It just happens
to be very selective about who its friends are." --Kyle Hearn

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']);

Well - if we could see the insert statment that would heklp.
Check your field lengths - see if yuo're trying to insert too much data
into a particular field.
Check the date format for the lastedit field.

One 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']);
>
> Well - if we could see the insert statment that would heklp.
> Check your field lengths - see if yuo're trying to insert too much data
> into a particular field.
> Check the date format for the lastedit field.
>
apologies... here is the statement that initially creates the record.
It executes just fine. The variables are derived from the same
arguments as the UPDATE variables.

$newOrgIns = "INSERT INTO organization
(org_id,orgname,office,address1,address2,city,stat e,country,zip,phone1,phone2,fax,email,website,note s,lasteditdate,createdate,createdby,publish,update dby)

VALUES
('','$org','$off','$ad1','$ad2','$city','$state',' $country','$zip','$phone1','$phone2','$fax','$emai l','$website','$notes','$lastedit','$lastupdate',' $uname','$pub','$uname')";
include_once 'dsn.php';
$res=mysql_query($newOrgIns)
or die('Query Failed: ' . mysql_error());;

--

Regards,

Jeff Gardner
___________________________

"Contrary to popular belief, Unix is user friendly. It just happens
to be very selective about who its friends are." --Kyle Hearn

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:
" ' ; \ @

--
Petr Vileta, Czech republic
(My server rejects all messages from Yahoo and Hotmail. Send me your mail
from another non-spammer site please.)

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.

--

Regards,

Jeff Gardner
___________________________

"Contrary to popular belief, Unix is user friendly. It just happens
to be very selective about who its friends are." --Kyle Hearn

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-)

IchBin wrote:
> 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?
>

Apparently, since org_id is of a numeric data type, the variable $orgid
does not need to be quoted in the UPDATE query.

--

Regards,

Jeff Gardner
___________________________

"Contrary to popular belief, Unix is user friendly. It just happens
to be very selective about who its friends are." --Kyle Hearn

Just typing:

echo $editO;

Should have given you your answer pretty fast, echoing what is really
being executed is often the best way to debug SQL issues.