Validation of existence per result on a indexed list, mysql/php

klinesolutions

New Member
We have a directory system that lists people with their credentials such as email phone and etcTheir web profile link is also listed.but this link is created by taking the email username and adding it to a link. so [email protected] has a profile page at school.com/user/joe01currently there is no validation to check if the actual user profile page existsbut what i do have is access to the database of the users which has their username and email listedi was thinking of comparing as the results are shownbut this is incredibly stupid since its a live search directory meaning every time it will be comparing hundreds of results and this will my make Admin very sad. so the user profile database has to be cached then the usermails from the directory database needs to be compared to it. the question is what is the best way to do this caching, a txt file? suggestions please
 
Back
Top