[RESOLVED] UPDATE databse issue

vinny199

Hi,

i am trying to get my table updated with "Worldpay callback parameters" and struggling.

Here is what I'm trying to do.

I have a table named "users"
in that table I need to update a field called "status" with a value posted back by worldpay:

$HTTP_POST_VARS['transStatus']

ith my WHERE condition being that my users table column "Uid" =

$HTTP_POST_VARS['cartId']

(which is another value returned by worlpay server.)
I have tried all sorts and can't seem to get the syntax right or my table updated

Could you help please?

thanks,

Vinny

bpat1434

So what is your code that you've tried?

vinny199

Thanks 4 reply,

ok, I know this is wrong...

  mysql_select_db($database_to_octo, $to_octo);


$query = "UPDATE user SET transStatus = '$HTTP_POST_VARS['transStatus']' . WHERE user = '$HTTP_POST_VARS['cartId']'";

mysql_query($query) ;

bpat1434

$query = "UPDATE user SET status = '$HTTP_POST_VARS['transStatus']' . WHERE Uid = '$HTTP_POST_VARS['cartId']'";

vinny199

yes i see my basic errors, but using your code I get the error:

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /var/www/vhosts/eggmeg.com/httpdocs/callback.php on line 18

(Line 18 being your line)

I know these values are being returned alright as I can echo them on the page

bpat1434

$query = "UPDATE user SET status = '".$HTTP_POST_VARS['transStatus']."' . WHERE Uid = '".$HTTP_POST_VARS['cartId']."'";

vinny199

thank you, it is not quite working but for another reason I think .
I'll keep trying
thanks.

bpat1434

same error, or different?

vinny199

no more errors.
just not updating.
I'm trying to find out why/

I have tried entering a text value for $status and deleted the where condition and my $value was updated fine.

However I have created

$transtatusField = $HTTP_POST_VARS['transStatus'];
$cartID = $HTTP_POST_VARS['cartId'];

and echo:

                        <td><?php echo "$transtatusField" ?>&nbsp;</td>

                        <td><?php echo " $cartID" ?></td>

and both value do display fine,

so maybe I shoud tupdate my query using status = $transtatusField where Uid =$cartID ??

thats what I was about to try. is the syntax different? or do I just replace the HHT_POST with the $?

bpat1434

you're right.....

dalecosp

If $HTTP_POST_VARS['foo'] is blank, but $foo isn't, then you have a problem with your design --- not a big one, necessarily. It's simply that the vars are not being POSTed to the page upon which you are calling them.

If $foo works, though, then your server must be set with register_globals enabled, which is generally considered to be a rather large security risk.

As for the question, "is the syntax different", the answer is, it can be, but doesn't have to be, so try it either way.

vinny199

I have tried a few things, this one not giving me an error, but not working wither.

should it say "echo" and then the $?

$query = "UPDATE users SET transStatus = '".$transtatusField."' . WHERE Uid = '".$cartID."'";

bpat1434

add:

or die(mysql_error());

to the mysql_query() call

vinny199

Grrr!

nearly there, it still has a problem of syntax but at least I know my values are being printed as I get the message:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '. WHERE Uid = '1'' at line 1

1 being the correct cartID number I am trying to retrieve at the other end.

My full query is now:

  mysql_select_db($database_to_octo, $to_octo);
$query_rsusers1 = "UPDATE users SET transStatus = '".$transtatusField."' . WHERE Uid = '".$cartID."'"; 
mysql_query($query_rsusers1) or die(mysql_error());

Thanks again.

vinny199

ok, got it now.
it just didn't like the . before WHERE

many thanks for the help

Vinny