I need to create a report / form from a query
to php
.
I have a membership database of a leisure club.
From this query
:
SELECT DISTINCT utilizador.nome, utilizador.data_nascimento,
utilizador.nif, morada.rua,morada.numero_porta, morada.andar,
morada.codigo_postal1, morada.codigo_postal2,
morada.localidade, socio.numero_socio
FROM socioonix, utilizador, morada
WHERE socio.idutilizador = utilizador.idutilizador
AND socio.aprovado = 'Pendente'
AND utilizador.idmorada = morada.idmorada
order by utilizador.nome asc;
This query
returns a member table that is in the pending state.
However, what I want to do is create for each partner something of the sort:
" partner name " with the " nif" strong> "is authorized to attend the Club.
signatures of parents / guardians
It is possible, how? I apologize if it's a very noob question, but my knowledge only goes so far as to generate queries and print tables.