السلام عليكم،،،
• عند إسترجاع بينات بإستخدام mysql_fetch_array ، لا يتم إسترجاع بيانات من قاعدة البيانات. مرفق الكود...
$result = mysql_query("SELECT * FROM teachers_employees");
while($row = mysql_fetch_array($result))
{
$address = $row['addressID'];
$tele = $row['TelID'];
$email = $row['EmailID'];
$job = $row['jobID'];
$image = $row['image'];
// Address
$addr_q = "SELECT * FROM address WHERE addressID ='$address'";
$addr_result = mysql_query($addr_q);
while($row = mysql_fetch_array($addr_result))
{
$countryid = $row['countryID'];
$cityid = $row['CityID'];
$stateid = $row['StateID'];
$villageid = $row['VillageID'];
$home = $row['Home_No'];
}
// Tel
$tel_q = "SELECT * FROM tel WHERE TelID ='$tele'";
$tel_result = mysql_query($tel_q);
while($row = mysql_fetch_array($tel_result))
{
$tel = $row['TelNo'];
}
// Email
$email_q = "SELECT * FROM email WHERE EmailID ='$email'";
$email_result = mysql_query($email_q);
while($row = mysql_fetch_array($email_result))
{
$emailx = $row['Email'];
}
// Job
$job_q = "SELECT * FROM job WHERE JobID ='$job'";
$job_result = mysql_query($job_q);
while($row = mysql_fetch_array($job_result))
{
$jobx = $row['JName'];
}
// Address Data
$country_query = "SELECT CName FROM country WHERE countryID = '$countryid'";
$resulta = mysql_query($country_query);
while($row = mysql_fetch_array($resulta))
{
$country_name = $row['CName'];
}
$state_query = "SELECT stateName FROM state WHERE StateID = '$stateid'";;
$resultb = mysql_query($state_query);
while($row = mysql_fetch_array($resultb))
{
$state_name = $row['stateName'];
}
$city_query = "SELECT CityName FROM city WHERE CityID = '$cityid'";;
$resultc = mysql_query($city_query);
while($row = mysql_fetch_array($resultc))
{
$city_name = $row['CityName'];
}
$village_query = "SELECT VillageName FROM village WHERE VillageID = '$villageid'";;
$resultd = mysql_query($village_query);
while($row = mysql_fetch_array($resultd))
{
$village_name = $row['VillageName'];
}