Losing my mind ... Willing to pay for some help!

Anon

Yes, I'm losing my mind. I really need some help and am willing to pay for some direction here. Below is a copy of an earlier question I posted. Mostly, I need to know if what I have to do is even possible!

Laurie

Here is the schematic of what I am trying to do. Can anyone tell me whether this is possible? And maybe point me in some direction. I have been reading the various manuals and the forum discussions, but don't seem to find answers to my particular questions. I guess the biggest question is just whether or not it's do-able. For more details, see http://www.llhgraphics.com/sample.htm.

Thanks,
Laurie

// User selects 1 of 4 SERVICEs, and 1 or more MONTHs

// TABLE 1

// ROW 1
strMonth
strBetterThanExpected
strAsExpected
strWorseThanExpected
strTotal

// ROW 2
$MONTH[1]
$result[1] = mysql_query("select 31_EXPECTED, COUNT() where SERVICE LIKE '$SERVICE%' and $MONTH[1] and 31_EXPECTED='A'")
$result[2] = mysql_query("select 31_EXPECTED, COUNT() where SERVICE LIKE '$SERVICE%' and $MONTH[1] and 31_EXPECTED='B'")
$result[3] = mysql_query("select 31_EXPECTED, COUNT(*) where SERVICE LIKE '$SERVICE%' and $MONTH[1] and 31_EXPECTED='C'")
$result[4] = ("sum($result[1],$result[2],result[3]))

// ROW 3
$MONTH[2]
$result[5] = mysql_query("select 31_EXPECTED, COUNT() where SERVICE LIKE '$SERVICE%' and $MONTH[2] and 31_EXPECTED='A'")
$result[6] = mysql_query("select 31_EXPECTED, COUNT() where SERVICE LIKE '$SERVICE%' and $MONTH[2] and 31_EXPECTED='B'")
$result[7] = mysql_query("select 31_EXPECTED, COUNT(*) where SERVICE LIKE '$SERVICE%' and $MONTH[2] and 31_EXPECTED='C'")
$result[8] = ("sum($result[5],$result[6],result[7]))

// ROW 4
$MONTH[3]
$result[9] = mysql_query("select 31_EXPECTED, COUNT() where SERVICE LIKE '$SERVICE%' and $MONTH[3] and 31_EXPECTED='A'")
$result[10] = mysql_query("select 31_EXPECTED, COUNT() where SERVICE LIKE '$SERVICE%' and $MONTH[3] and 31_EXPECTED='B'")
$result[11] = mysql_query("select 31_EXPECTED, COUNT(*) where SERVICE LIKE '$SERVICE%' and $MONTH[3] and 31_EXPECTED='C'")
$result[12] = ("sum($result[9],$result[10],result[11]))

// Repeat depending on how many months selected

// ROW (last)
strTotal
$result[13] = ("sum($result[1],$result[5],result[9]))
$result[14] = ("sum($result[2],$result[6],result[10]))
$result[15] = ("sum($result[3],$result[7],result[11]))
$result[16] = ("sum($result[4],$result[8],result[12]))

// TABLE 2
// (Repeat above but with percentages instead of counts.)

Anon

What exactly are you trying to accomplish, I think if you explained it in a more straightforward manner, people might be able to help you out.

Anon

If you go to this html page, I have tried to explain what I need to do:
http://www.llhgraphics.com/sample.htm

Thanks,
Laurie

Anon

I've taken a look at your sample and I'd just like to know how you generate the count figures. I believe here is your first problem. You have no relationship between the count figures and what they should be representing.i.e. "Good,Ok,or Bad"(a bit abbreviated from your version).

What does your MySql table look like? It should have the fields service,month,rating, and count. I think your missing the rating field.

Let me know if I'm wrong.

Anon

Looking at your web site, it's clear that you're pretty close, but need to do some more programming to make it work.

A. The query needs to sort in the opposite order, so that the minor sorting
is by the field that appears in the column heading and the major sorting
is the row results. This will then enable...

B. The table-formatting code needs to be modified to only start a new row
when the "control" field changes.
Sums is easily done once you make the changes in 1; just have one
accumulator for the row, and an array of them for the columns.
On second thought, in #2 you really need to retain all the data for each
cell, since you will need that data to calculate the percentages.
QUESTION: are the actual results really about this size, i.e. a table
with up to 12 columns and 5 or 6 rows?
What kind of chart do you need? A simple histogram can be built
with just X characters (using <pre></pre>). If you need an actual
graphic, PHP can do that too, but it must have the graphics support
compiled in to it.

If you want someone to actually implement these changes for you, I'd
be happy to be considered.

Anon

The field in question is called 31_EXPECTED. There are 3 possible responses:
"A" which is Better Than Expected
"B" which is As Expected
"C" which is Worse Than Expected

I do have SERVICE and MONTH fields, but the problem is with the COUNT(*) function and the displaying of the results in separate columns according to the SERVICE and MONTH selected.

Does this make any sense?

With this query:

select 31_EXPECTED, MONTH, SERVICE, COUNT(*) from Client001 where SERVICE='Emergency' and MONTH='April' GROUP BY MONTH, SERVICE, 31_EXPECTED

I get:
A April Emergency 8
B April Emergency 25
C April Emergency 1

Not exactly what I want though ... see http://www.llhgraphics.com/sample.htm

Anon

I am still digesting your 1-4, but in answer to your last statement ... YES!

You don't happen to live in Northern Michigan, do you?
:-)

Anon

You don't happen to live in Northern Michigan, do you?
:-)

No; I get to the Duluth/Superior area every once in a while but that's it.
(My wife is from Cloquet MN.)

But hey, this is internet stuff, if we can't do it virtually, we're just fooling
people... :-)

Anon

No, in the Internet World, it doesn't matter where you live. I was just thinking that if I hired you to help me, and you were in another country (which seems to be true for many of these discussion people), then any exchanging of $ might be difficult.

P.S. Still thinking through your first message.

Anon

OK, I'm located in Tacoma WA so currency conversions are no problem. Why don't we take this to email if you want to pursue it farther; I've already sent you something at your address shown on the web site.

Anon

FYI, I live on the border of Tacoma/Puyallup Washington although this post couldn't be more offtopic. Just, don't hear 'Tacoma' very often so couldn't resist 😉