SELECT pays.code_pays,pays.libelle_pays FROM pays
order by pays.libelle_pays
Profil de #Session.Pseudo#
Select adh_pseudo, adh_login, adh_nom, adh_prenom, adh_adr1, adh_adr2,adh_adr3, adh_code_postal, adh_ville, adh_pays, adh_email, adh_inscription, adh_fincontrat, adh_actif from membres
where adh_nochrono=#Session.NoMembre#
SELECT * FROM profils where nochrono=#Session.NoMembre#
SELECT coalesce(sum(note) ,0) as notepos from evenements where nomembre=#session.Nomembre# and note > 0
SELECT coalesce(sum(note) ,0) as noteneg from evenements where nomembre=#session.Nomembre# and note < 0
Notes positives : #qNotepos.Notepos#, notes négatives : #qNoteneg.Noteneg#
|
|