• 0
Sign in to follow this  
Manuel André

Inicio de sessão com duas tabelas

Question

ola amigos poderia me dar uma ajuda  organizar esse codigo

alguém me deu uma ideia mais mesmo assim esta difil ,pois sou iniciante em php

verifica se o saldo é suficiente
select saldo from conta, proprietario where codigo = SESSION[id] and prop_codigo = SESSION[id];

Novo_saldo1 = session[saldo1] - valor_informado

update conta set saldo = Novo_saldo1 where id_conta = SESSION[id_conta]

select * from conta where id_conta = numeroContaInformado
Novo_saldo2 = session[saldo2] + valor_informado
update conta set saldo = novo_saldo2 where id_conta = numeroContaInformado

exemplo
SELECT id_conta,saldo, nome FROM conta, usuarios WHERE id_usuario =501 and id = 501 

update conta set saldo = 50000-10000 WHERE id_usuario = 501 

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this