Posted by Jeff Gardner on 09/11/06 13:44

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

• Next in forum: Re: UPDATE query appears to complete but nothing changes in data
• Prev in forum: Re: MSSQL slow on IIS 6
• Thread view: UPDATE query appears to complete but nothing changes in data

[Reply to this message]