Electrical and Computer Engineering Department
Nothing to display."; } if($result){ ?>| Name | Student # or position | Authorized | Room | Expiration date | $row[name] | "; echo "$row[student_id] | "; $query2 = "select fname,lname from faculty where username='$row[authorized]'"; $result2 = mysql_query($query2); $row2 = mysql_fetch_array($result2); echo "$row2[fname] $row2[lname] | "; echo "$row[room] | "; echo "$row[date] | "; ?> } } else { echo "No data found."; } mysql_free_result($result); ?>