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 #181054 is a reply to message #181045]

Sun, 07 April 2013 15:34

bill
Messages: 310
Registered: October 2010

Karma:

Senior Member

On 4/7/2013 10:14 AM, Frank Steinmetzger wrote:
> 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
>>>> […]
>>>>
>>> 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.
>
> You select two different appointments that have the same date:
>
> SELECT s1.patient_number AS pn, s1.time AS t1, s2.time AS t2,
> s1.duration AS d1, s2.duration AS d2
> FROM schedule s1, schedule s2
> WHERE s1.time=s2.time AND s1.time=<today's date>
> AND s1.patient_number=s2.patient_number
> AND s1.patient_number=<ID of patient of interest>
> AND s1.id!=s2.id
> AND s1.doctor_number!=s2.doctor_number
>
> Of course, those times don't work that way, b/c they have date *and* time,
> and you want to deal with date only. I'm not into advanced SQL, perhaps there
> is an SQL function to only extract and use the date part.

there is
>
> You then would need to PHP-fiddle the time and duration together for only
> those appointments that are today in a nested for-loop.
select s1.user as s1user,
s2.user as s2user,
s1.apptTime as s1apptTime,
s2.apptTime as s2pptTime,
users.physician,
users.user_id
from schedule as s1 join schedule as s2 join users
on (s1.patient_number = s2.patient_number
and users.user_id = s2.user)

where s1.patient_number = s2.patient_number
and s1.appt_status = 'a'
and s2.appt_status = 'a'
and s1.patient_number = '5214'
and s1.schedule_id != s2.schedule_id
and physician = '1'
and date(s1.apptTime) = date(s2.apptTime)
and date(s1.apptTime) = '2013-04-03'

did the job

Thanks for the great suggestion.

bill

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: Wed Dec 18 06:41:12 GMT 2024

Total time taken to generate the page: 0.03827 seconds