Filtering Alumni members by matching their firstname and lastname ...

[xavierDOTph]

i have a thesis about Alumni Directory of our School..Our problem is that how to filter members that have already have records on our database.. if he wants to join on the site he must fill in right Firstname, Lastname, Course and Year..but the problem is that for example we could match like

firstname LIKE '%fname%' AND lastname LIKE '%lname%'

but there are many same names and lastnames in our records .. how could we target to the person who has a firstname and lastname with the said course and graduated year... ive got this idea from www.PLUalumni.com...hoping for your generous response thanks ...in advance

[Rabbit]

Just add additional filters to target the course and year.

[xavierDOTph]

but could it be a unique process and we could assure that no one have details like what he/she have submitted... could help what to do...and offer to us the best way/feature to let alumni join the site..thanks ..Sir

[Rabbit]

If you're asking whether or not you can enforce uniqueness, the answer is yes. If you're asking whether it is unique in the real world, the answer is no.

[xavierDOTph]

thanks for making me understand Sir.. could u site some codes for me hto learn how to start .with .. like matching firstname, lastname,course then year...and state what query would i use.. thanks Sir for the time

[Rabbit]

You already have the basics in your filter, you just need to add the two additional criteria that you want.

[xavierDOTph]

So if all criteria are correct ..i will direct to the right page and if not it will return error ...thanks ..SIr. .