My webpage basically saves and fetches information about the employment history of an employee; Each employee having at least 10 to 15 work experience with the company; My issue is that i am having trouble fetching the data for date hired.
Here are the details of table wexp
LNAME|FNAME|WFROM|WTO|PT|DEPT|MS|SGSI|SOA|GOVS
I was wondering if it is possible to fetch the last row for a specific employee something like in mysql_fetch_assoc
$wexp = "SELECT * FROM wexp WHERE LNAME='$lname' && FNAME='$fname';
$viewwexp = mysql_query($wexp,$con);
while($row = mysql_fetch_assoc($viewwexp))
Any assistance is much appreciated; I am also open for suggestion if you think what i have in mind is not possible
Thanks in advance.