PHP Developers Network
http://forums.devnetwork.net/

Array to find providers based on Answers to Qs
http://forums.devnetwork.net/viewtopic.php?f=2&t=147882
Page 1 of 1

Author:  simonmlewis [ Mon Jun 17, 2019 5:25 am ]
Post subject:  Array to find providers based on Answers to Qs

Hi there

I'm a little bit rusty these days with My-SQL so hoping I can be led into a good route for this.

We have been asked to do a website where people can answer questions (from dropdown answers), and the result will bring up a list of providers for language support.

So if you answer Yes to "can you write a letter in English", then it will find all those providers who have stated whether they can support that.

So far these are my tables

Add question to db-Questions
id
question

Add answers to db-Answers
id
Qid
answer
ProvideId (array)

Add providers to db-Providers
id
contact name
company
address1
address2
town
county
postcode

My difficulty is how to assign providers to the answers. ie. if an answers means providers 1, 3 and 7 need to be selected, how do I do that?

Would it go into a ProviderIDs field, as 1,3,7 using an array, and then 'explode' it in a query?

How would I go about doing that? 4 years ago I could have figured it out but am a little rusty!

Thanks.

Author:  Christopher [ Sat Jul 06, 2019 2:28 pm ]
Post subject:  Re: Array to find providers based on Answers to Qs

You could put "1,3,7" in the ProvideId field, or create a forth Answers_Providers table that has AnswerId and ProviderId fields.

Page 1 of 1 All times are UTC - 5 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/