I want to search 2 database tables where the name is equal to $nome
variable.
I would not like to gather data as if it were FK, but to pull all the information from these tables (other columns).
administradores
adm_id | nome | data_nasc | cod_user |
1 | rafael | 00/00/0000 | 63453 |
2 | paulo | 05/06/2005 | 34241 |
usuarios
user_id | nome | sobrenome | cod_user |
1 | rogério | silva | 32412 |
2 | silvio | lira | 21321 |
I tried to make a select
like this:
SELECT * FROM administradores.nome, usuarios.nome WHERE nome = '$nome';