if($action != "view") { ?> } ?> if($action == "view") { ?>
} else { ?> } ?> /* connect to the database */ mysql_pconnect( "$host", "$user", "$password") or die( "Can't connect to the MySQL-server"); mysql_select_db( "$database"); /* action=view : retrieve data from the database and show it to the user */ if($action == "view") { /* function for showing the data */ function search_it($name) { /* some vars */ global $offset,$total,$lpp,$dir,$records; global $table,$html_mail,$admin_name,$admin_mail; /* select the data to get out of the database */ $query = "SELECT * FROM $table ORDER BY ID DESC"; $result = mysql_query($query); $total= mysql_numrows($result); print "| \n";
print " \n"; print "First Name: $i1\n"; print "Last Name: $i2\n"; print " Address: $i3\n"; print " City: $i4\n"; print " State: $i5\n"; print " Zip: $i6\n"; print " Country: $i7\n"; print " Phone: $i8\n"; print " Pager: $i9\n"; print " Email: $i10\n"; print " Specialty: $i11\n"; print " Desired City: $i12\n"; print " Desired Salary: $i13\n"; print " Desired Start Date: $i14\n"; print " |