EdwinMurgoh

i don't think i need to create another column for compatible blood types.........The compatible blood types are known all i need is a script to get the current user in session blood group and using the compatible list that i have display contact info all the users that are able to donate to the user. Is it possible to store the users blood group in a session and retrieve it during the matching??? or is there anyone who can help me with the script to get the blood group value which we can later match. I will also make the database changes as advised by scootstah.........I am a newbie in php any assistance i would encourage scripts that i can review.....thank you

I am working on a blood bank mobile app.I seem to have stalled at the logic for matching donors to their respective blood_groups that can donate to them. Curently i have a database called test and 3 tables: health_profile, contact_info and register. register has (id,firstname,lastname,email,username and password) health_profile has (id,username,blood_group,age and weight) contact_info has (username, phone, address, town). I need the php script to get the value of blood_group of the current user and and display the contact_info all the other users in the database that can donate to them. O- can be donated by O- O+ can be donated by O+ and O- A- can be donated by A- and O- A+ can be donated by A+ A- O+ O- B- can be donated by B- and O- B+ can be donated by B+ B- O- O+ AB- can be donated by AB- B- A- O- AB+ can be donated by AB+ AB- B+ B- A+ A- O+ O-