|
require_once('./files/membrii/conf/math.php'); $conn=mysql_connect($hostname_ssmr, $username_ssmr, $password_ssmr); $db_selected =mysql_select_db($database_ssmr,$conn); $query="SELECT nume,prenume, institutie,judet FROM participanti where inregistrare='validata' and EXTRACT(YEAR FROM now())= EXTRACT(YEAR FROM postdate) and concurs='IMAR'order by nume, prenume"; $result=mysql_query($query,$conn); $cateRanduri=mysql_num_rows($result); mysql_close($gmb); echo '
Nr. | '; echo 'Nume | '; echo 'Prenume | '; echo 'Scoala | '; echo 'Judet | '; echo '
'.$crt.'. | '; echo ''.strtoupper($nume).' | '; echo ''.ucwords($prenume).' | '; echo ''.ucwords($scoala).' | '; echo ''.ucwords($judet).' | '; echo '