UPDATE query appears to complete but nothing changes in data

[Jeff Gardner]

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

[One]

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 ?

[Jeff Gardner]

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

[One]

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.

[Jeff Gardner]

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

[Petr Vileta]

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

[Jeff Gardner]

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

[IchBin]

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

[Jeff Gardner]

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

[william.clarke]

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.