[insert_php]

$hostname= »triathlonv303.mysql.db »; //local server name default localhost
$username= »triathlonv303″; //mysql username default is root.
$password= »Greenday1″; //blank if no password is set for mysql.
$database= »triathlonv303″; //database name which you created

$con=mysql_connect($hostname,$username,$password);

if(! $con) {
die(‘Connection Failed’.mysql_error());
}

mysql_select_db($database,$con);
mysql_query(« SET NAMES UTF8 »);

$query = mysql_query(« SELECT id,nom,prenom,sexe,paiement FROM inscrits_individuelle_licencie where course=’Courte distance’ and paiement=’effectuer’ GROUP BY nom,prenom UNION SELECT id,nom,prenom,sexe,paiement FROM inscrits_individuelle_non_licencie where course=’Courte distance’ and paiement=’effectuer’ GROUP BY nom,prenom ORDER BY nom »);

echo ‘Lista de participantes a distancia que realizaron el pago : ‘;

echo’

‘;

while($rowtwo = mysql_fetch_array($query)){

echo’

‘;
echo’

‘;
}
echo’

‘;
echo’

Número de registro Nombre Appellido Sexo
‘.$rowtwo[« id »].’ ‘.$rowtwo[« nom »].’ ‘.$rowtwo[« prenom »].’ ‘.$rowtwo[« sexe »].’

‘;

mysql_close($con);

[/insert_php]