By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,101 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

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

P: 6
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
Expand|Select|Wrap|Line Numbers
  1. 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
Feb 3 '12 #1

✓ answered by Rabbit

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

Share this Question
Share on Google+
6 Replies


Rabbit
Expert Mod 10K+
P: 12,365
Just add additional filters to target the course and year.
Feb 3 '12 #2

P: 6
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
Feb 3 '12 #3

Rabbit
Expert Mod 10K+
P: 12,365
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.
Feb 3 '12 #4

P: 6
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
Feb 4 '12 #5

Rabbit
Expert Mod 10K+
P: 12,365
You already have the basics in your filter, you just need to add the two additional criteria that you want.
Feb 4 '12 #6

P: 6
So if all criteria are correct ..i will direct to the right page and if not it will return error ...thanks ..SIr. .
Feb 5 '12 #7

Post your reply

Sign in to post your reply or Sign up for a free account.