Posted by One on 09/11/06 13:51

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 ?

• Next in forum: Re: UPDATE query appears to complete but nothing changes in data
• Prev in forum: UPDATE query appears to complete but nothing changes in data
• Thread view: Re: UPDATE query appears to complete but nothing changes in data

[Reply to this message]