| |
أسماء جميع
المشاركين في المؤتمر 2006
المشاركين 2005
- المشاركين 2007
|
الديانة |
المنظمة |
المسمى الوظيفي |
اسم العائلة |
الاسم الأول |
الرقم التعريفي |
الرقم التسلسلي |
$hostname = "localhost";
$username = "qatar-co_mustafa" ;
$password = "mustafa";
$dbName = "qatar-co_dialogue2006";
$table = "arabic";
/* make connection to database */
MYSQL_CONNECT($hostname, $username, $password) OR DIE( "Unable to connect
to database");
@mysql_select_db("$dbName") or die( "Unable to select database");
$Select1 = mysql_query("SELECT DISTINCT Country FROM arabic");
$mynum=mysql_num_rows($Select1) ;
$mycnt;
$mycnt=0;
while ($myrow = mysql_fetch_array($Select1))
{
$mycnt=$mycnt+1;
$mymus[$mycnt] =$myrow[0];
}
$Select2 = mysql_query("SELECT DISTINCT 'Type of Participation' FROM arabic");
$mynum2=mysql_num_rows($Select2) ;
$mycnt2;
$mycnt2=0;
while ($myrow2 = mysql_fetch_array($Select2))
{
$mycnt2=$mycnt2+1;
$mymus2[$mycnt2] =$myrow2[0];
}
for ($mycnt=1;$mycnt<=$mynum;$mycnt=$mycnt+1)
{
/********************************************************************************************************/
$Select = mysql_query("SELECT * FROM $table where Country='$mymus[$mycnt]' and confirmed='confirmed'");
$num=mysql_num_rows($Select) ;
$mus1=Array();
$mus2=Array();
$mus3=Array();
$mus4=Array();
$mus5=Array();
$mus6=Array();
$mus7=Array();
$mus8=Array();
$mus9=Array();
$mus10=Array();
$mus11=Array();
$mus12=Array();
$mus13=Array();
$mus14=Array();
$mus15=Array();
$mus16=Array();
$mus17=Array();
$mus18=Array();
$mus19=Array();
$mus20=Array();
$mus21=Array();
$mus22=Array();
$mus23=Array();
$mus24=Array();
$mus25=Array();
$mus26=Array();
$mus27=Array();
$mus28=Array();
$mus29=Array();
$mus30=Array();
$mus31=Array();
$cnt;
$cnt=0;
while ($row = mysql_fetch_array($Select))
{
$cnt=$cnt+1;
$mus1[$cnt] =$row[0];
$mus2[$cnt] =$row[1];
$mus3[$cnt] =$row[2];
$mus4[$cnt] =$row[3];
$mus5[$cnt] =$row[4];
$mus6[$cnt] =$row[5];
$mus7[$cnt] =$row[6];
$mus8[$cnt] =$row[7];
$mus9[$cnt] =$row[8];
$mus10[$cnt] =$row[9];
$mus11[$cnt] =$row[10];
$mus12[$cnt] =$row[11];
$mus13[$cnt] =$row[12];
$mus14[$cnt] =$row[13];
$mus15[$cnt] =$row[14];
$mus16[$cnt] =$row[15];
$mus17[$cnt] =$row[16];
$mus18[$cnt] =$row[17];
$mus19[$cnt] =$row[18];
$mus20[$cnt] =$row[19];
$mus21[$cnt] =$row[20];
$mus22[$cnt] =$row[21];
$mus23[$cnt] =$row[22];
$mus24[$cnt] =$row[23];
$mus25[$cnt] =$row[24];
$mus26[$cnt] =$row[25];
$mus27[$cnt] =$row[26];
$mus28[$cnt] =$row[17];
$mus29[$cnt] =$row[28];
$mus30[$cnt] =$row[29];
$mus31[$cnt] =$row[30];
}
for ($cnt=1;$cnt<=$num;$cnt=$cnt+1)
{
if ($cnt==1)
{
print "
|
|
" . $mus3[$cnt] . " |
" ;
}
else
{
print "
|
|
|
" ;
}
print "
" . $mus31[$cnt] . " |
" . $mus9[$cnt] . " |
" . $mus8[$cnt] . " |
" . $mus5[$cnt] . " |
" . $mus7[$cnt] . " |
" . $mus1[$cnt] . " |
" . $cnt . " |
";
}
/********************************************************************************************************/
}
?>
&&&
|