لدي صفحة تمرر لهذا الكود متغيرين هما number و year
ليقوم بعرض نتيجة الطلاب بالكود التالي
<?
if (!$number)
{
echo "No data entered";
}
$db = mysql_connect("localhost", "root", "");
mysql_select_db("results", $db);
$query = "Select level4.name as 'ÇáÅÓã' , level4.acc_researchs as 'ÏÑÇÓÇÊ ãÍÇÓÈíÉ' , level4.auditing1 as 'ãÑÇÌÚÉ Ã' , level4.managerial_acc as 'ãÍÇÓÈÉ ÅÏÇÑíÉ' , level4.financ_company 'ãäÔÂÊ ãÇáíÉ' , level4.ais 'äÙã ÇáãÚáæãÇÊ ÇáãÍÇÓÈíÉ', level4.international_acc as 'ãÍÇÓÈÉ ÏæáíÉ' from level4 where level4.no = '$number' and level4.year = '$year'";
$result = mysql_query($query);
if (mysql_num_rows($result)==0)
{
echo " áÇ ÊæÌÏ ÈíÇäÇÊ áÑÞã ÇáÞíÏ ÇáãÏÎá !!!";
}
while ($record = mysql_fetch_assoc($result))
{
while (list($fieldname, $fieldvalue) = each($record))
{
echo $fieldname." : <B><font color='#CC0000'>".$fieldvalue."</B></font><BR>";
}
echo "<Br>";
echo "<hr width='50%' color='#E60808'>";
echo "<p align='center'><font face='Tahoma' style='font-size: 9pt' color='#000077'><a target='_blank' href='contactus.php'><font color='#000077'> <span lang='ar-ye'><b><a href='contactus.php'>
<span style='text-decoration: none'>ÊæÇÕá ãÚäÇ</span></font></a></font></span></a></b></span></font></p>
<p align='center' dir='ltr'><font face='Arial' size='1'>Copyright © 2006
Almattari's projects. All rights reserved</font></p>";
}
?>وأريد تحسينه لكي يظهر على شكل جدول به اسم المادة ثم الدرجة ..
:rolleyes: