query($sql);
if ($result->num_rows > 0) {
while($row=$result->fetch_assoc()) {
$id=$row['id'];
$name=$row['name'];
$gender=$row['gender'];
$speciality=$row['speciality'];
$profile=$row['profile'];
$profilepicid=$row['profilepicid'];
$address=$row['address'];
$fee=$row['fee'];
}
}
?>
query($sql);
if ($result->num_rows > 0) {
while($row=$result->fetch_assoc()) {
$filename=$row['filename'];
}
}
?>