FUDforum: comp.lang.php » comparing arrays

Home » Imported messages » comp.lang.php » comparing arrays

Show: Today's Messages :: Polls :: Message Navigator

Re: comparing arrays [message #181058 is a reply to message #181044]

Sun, 07 April 2013 18:18

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

On 4/7/2013 10:00 AM, bill wrote:
> On 4/7/2013 8:34 AM, Jerry Stuckle wrote:
>> On 4/7/2013 7:34 AM, bill wrote:
>>> I need to see if a patient has appointments with a
>>> psychotherapist and a
>>> physician on the same day.
>>>
>>> I request the schedule of each therapist and each physician as
>>> arrays of
>>> arrays:
>>> time, patient_number, duration (note, the therapist/physician
>>> id is not
>>> in the array)
>>> They are non-associative arrays (numeric keys)
>>> I might have 1..n physicians and 1..n therapists
>>> I can generate arrays of physicians and arrays of therapists
>>>
>>> Option 1 is a nightmare of nested foreachs
>>>
>>> I am sure there must be an array function that will permit this
>>> check.
>>> AFAIK, the _intersect functions require the same date in all,
>>> when what
>>> I want is "any".
>>>
>>> my current thought is to create arrays of just pt_number, merge
>>> the
>>> physician arrays, merge the therapist arrays, array_flip to
>>> move the
>>> values to keys and then array_intersect.
>>>
>>> But, before I try that I welcome any suggestions.
>>>
>>> bill
>>
>> Does the information come from a SQL database? If so, I'd do it
>> in SQL.
>>
>
> Yes it does, 3 tables: users (therapist/physician), pt_info, schedule.
>
> A little more of a hint please.
>
> bill

Try a newsgroup related to the SQL database you're using for help on
creating the correct SQL statement(s).

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================

Report message to a moderator

[Message index]

		comparing arrays By: bill on Sun, 07 April 2013 11:34
		Re: comparing arrays By: Jerry Stuckle on Sun, 07 April 2013 12:34
		Re: comparing arrays By: bill on Sun, 07 April 2013 14:00
		Re: comparing arrays By: Frank Steinmetzger on Sun, 07 April 2013 14:14
		Re: comparing arrays By: Thomas 'PointedEars' on Sun, 07 April 2013 15:13
		Re: comparing arrays By: bill on Sun, 07 April 2013 15:34
		Re: comparing arrays By: Thomas 'PointedEars' on Sun, 07 April 2013 19:33
		Re: comparing arrays By: Jerry Stuckle on Sun, 07 April 2013 18:18
		Re: comparing arrays By: Thomas 'PointedEars' on Sun, 07 April 2013 13:37
		Re: comparing arrays By: bill on Sun, 07 April 2013 13:59
		Re: comparing arrays By: Thomas 'PointedEars' on Sun, 07 April 2013 15:14
		Re: comparing arrays By: The Natural Philosoph on Sun, 07 April 2013 14:59
		Re: comparing arrays By: The Natural Philosoph on Sun, 07 April 2013 15:01
		Re: comparing arrays By: Frank Steinmetzger on Sun, 07 April 2013 18:22

Previous Topic:	Need help with stripping characters from numbers in array
Next Topic:	Connecting to MySQL server....

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 08:11:58 GMT 2024

Total time taken to generate the page: 0.04961 seconds