Posted by Petr Vileta on 09/15/06 12:27

StevePBurgess@gmail.com wrote:
> Kim Hunter wrote:
>> i would compare the config on both servers, (maybe registered
>> globals is on on the client).
>>
>
> All the variables used in the script are sourced from the relevant
> $_POST or $_GET. The script was designed for register_globals to be
> off.
>
> I'll check though it there are any discrepancies in the config that
> might cause this problem.

I'm not sure but try to flush tables after all updates.

$sql="select DisplayOrder from CreditType where Id=" . $credcat;
$result=mysql_query($sql);
$row=mysql_fetch_row($result);

$sql="update CreditType set DisplayOrder=" . (($row[0])-1) . " where
Id=" . $credcat;
mysql_query($sql);

$sql="update CreditType set DisplayOrder=" . ($row[0]) ." where
DisplayOrder=" . (($row[0])-1) . " and Id<>" . $credcat;
mysql_query($sql);

# this can resolve your problem
$sql="flush tables";
mysql_query($sql);


--

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

[Back to original message]