Could anyone tell me how to...?

Alright, it happened that I translated the file to english to post it here, but it seems that I forgot to translate back to spanish a variable... my bad.
Anyway, the query is still not working. S:

[cliente]

It didn't show anything. mhmmm...

check the var names in your URL:

...189.153.101.203/lagunadesign/recibir_pago.php?cliente=eliezer.com&monto=127

[',"]

That's alright now. I realized that if I exchange the '," marks, so the query looks like this:

Code:

$sql="UPDATE clientes SET saldo = saldo - " . (int)$_GET['monto'] . " WHERE

id_cliente=" . $id_cliente . "";

then I get this error:
Unknown column 'eliezer.com' in 'where clause'

I don't know why it's taking the value as a column it has the equal mark and everything.

because you have to place strings into SINGLE quotes:

$sql="UPDATE clientes SET saldo = saldo - " . (int)$_GET['monto'] . " WHERE

id_cliente= ' " . $id_cliente . " ' "; (remove the spaces and maybe you should use LIKE and not =)

and of course it is time start with some beginners tutorials, your problems are really mistakes made by newbies

I love you. ( :
It worked!

here is also the sprintf version (and tell me what is better to read)

Code:

<?php
$sql= sprintf("UPDATE clientes SET saldo = saldo - %d WHERE id_cliente = '%s'", $_GET['monto'], $id_cliente);

btw. you need to validate the value $id_cliente to prevent SQL injections

For some reason, if I use sprintf on 'saldo' column when I register a payment of 100.00 its gets off 200.00 from the balance. If I input 50.00 it gets 100.00 off, if I input 150.50 it gets 200 off.
It seems like it's taking the total to the closer integer.


MySQL 'saldo' column properties..

Code:

  `saldo` DECIMAL(10,2) NOT NULL,

in this case you need this one:

<?php
$sql= sprintf("UPDATE clientes SET saldo = saldo - %f WHERE id_cliente = '%s'", $_GET['monto'], $id_cliente);


note the %f

I would like to know what are those letters about. I guess they define arguments or something...
anyway...
last query does take the decimals exactly, BUT every amount I input it gets doubled.

( any amount ) * ( 2 )

I would like to know what are those letters about. I guess they define arguments or something...
anyway...
last query does take the decimals exactly, BUT every amount I input it gets doubled.

( any amount ) * ( 2 )

www.php.net/sprintf

Always in debt!!! 

[Guest]

[62.883]

Googlebot