By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,592 Members | 1,931 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,592 IT Pros & Developers. It's quick & easy.

UPDATE query appears to complete but nothing changes in data

P: n/a
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
Sep 11 '06 #1
Share this Question
Share on Google+
9 Replies


P: n/a
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 ?

Sep 11 '06 #2

P: n/a
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
Sep 11 '06 #3

P: n/a
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.

Sep 11 '06 #4

P: n/a
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
Sep 11 '06 #5

P: n/a
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.)
Sep 11 '06 #6

P: n/a
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
Sep 11 '06 #7

P: n/a
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-)
Sep 11 '06 #8

P: n/a
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
Sep 12 '06 #9

P: n/a
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.

Sep 12 '06 #10

This discussion thread is closed

Replies have been disabled for this discussion.