PHP Form Submit Query

Paul75

Hi Folks,

I’m hoping this is a simple thing I’m missing or not doing properly.

It relates to posting 2 results from 1 submit button on a form.

Without sending the mass of code, here’s the crux:
(It’s a series of submit buttons in a table)

Then on the other results page I use:

$s1=$POST['Submitano'].$POST['query'];

The problem is when I click on the relevant submit button it pulls through the correct POST [‘Submitano’] that was chosen (i.e. $aa, or $ac) but it ALWAYS pulls through the last query - $query3 instead of the query that is attached to the submit. (i.e. $aa should pull through $query1, but it pulls through $query3)

Hope this makes sense.

Any ideas?

Thanks

Paul

bradgrafelman

Why not use separate forms for each value?

Otherwise, can you determine which query to use if you know the value of 'Submitano' ? If so, change the hidden fields to have names that end with [] (e.g. "query[]") which will make $_POST['query'] an array.

bradgrafelman

Why not use separate forms for each value?

Paul75

Hi There,

Thanks for getting back to me.

Not sure if that would work for what I'm trying to achieve?

Basically the $aa bit is the result of the query. (i.e. $aa is the result of query 1, $ab is the result of query 2, etc)

The user simply sees the results in the value of the submit button, so when they choose the one they want (i.e. $ab - which for talking sake, say it says "73"), then I want the query that generated the answer "73" (i.e. query 2) to be passed to the next screen so I can do something with it, as opposed to passing the answer "73" to the next page.

Any ideas or would your suggesting work and I'm just not seeing it?

Thanks

Paul

Weedpacket

Use [man]sessions[/man] so that you don't have to send anything to the browser that it doesn't need or have any use for.

Paul75

Thanks - I'm already using sessions to pass data. In a nutshell:

Screen 1 – 3 – User chooses a variable on each page that is passed to Screen 4. (via sessions)

Screen 4 – The aforementioned 3 variables are read and fed into 25 pre-set Mysql queries and run (i.e. Query 1, Query 2, etc), but each query has a slightly different element, thus resulting in 25 different answers.

The results of these 25 queries are stored in 25 variables $aa, $ab, etc.

A form is set up that displays the results of these 25 queries, with each answer being displayed in a submit button. (i.e. where I have coded ‘Value=$aa’, it’s so the user can see the answer to that query, i.e. ‘73’ and then click on it).

(The user basically needs to see 25 different answers based on their choices in the first 3 pages, and then choose the answer they want to know more about.)

Page 5 – This page needs to know what button the user clicked, but more importantly which query they chose, but my problem is that it only feeds through the value, and not the preceding query that generated that value - that's what I need to be fed through to page 5?

Thanks

Weedpacket

Paul75 wrote:
Page 5 – This page needs to know what button the user clicked, but more importantly which query they chose, but my problem is that it only feeds through the value, and not the preceding query that generated that value - that's what I need to be fed through to page 5?

That's why you should be storing it in the session.

Paul75 wrote:
The results of these 25 queries are stored in 25 variables $aa, $ab, etc.

Use arrays. This is what arrays are for.

Store the queries (also in an array) in the session; in fact, the queries and their results could be stored together. Looking something like

$queries = array(
    1 => array('query 1', 'answer 1'),
....
);

Give each submit button a unique name, based on the array index the query is stored under in the session ([font=monospace]Submitano[index]). When receiving the form, it will contain an array named [font=monospace]$POST['Submitano'][/font] containing one element. You want the key of that element.
[font]$chosen_query = array_pop(array_keys($POST['Submitano']));[/font]

With that key, you can look up the query (and the answer) in the session data.

Use a set of radio buttons, and one submit button.

Paul75

Thanks Weedpacket - you're a star!

Between that answer and some stuff a guy suggested on another forum I've managed to get it to work.

It's much appreciated man!

Paul

jazzatbay

Paul,

Without giving too much away...can you let me know how you resolved this issue? I am also stuck at the same stage and only the last row seems to be making its way into the database.

Cheers,

Paul75

No Worries,

I solved that problem one way - then found another way of passing data later. I'll briefly explain and if they're any good or you need some code examples, just let me know.

Way 1 - The submit buttons were in a grid of 25 squares, so I set it up as an array so if you choose button 12 (say), then the code on the other page was set up that if array 11 was chosen (as arrays start at 0) then do A,B,C or if button 23 was chosen, then 22 was rigged to do X,Y,Z.

Way 2 - For each submit button, have loads of hidden data that gets submitted with it. (i.e. Input hidden name=a value =a, name=b value=b, attached to submit 1 then Input hidden name=x value=x, name=y value=y, attached to submit 2, etc).

Then on the receiving page - all the $_POST['x'], etc were set up to recieve whatever was clicked.

Hope this helps? I can post code if need be?

Paul

jazzatbay

I did solve this with hidden variables...but have not been able to get the array way working. If you can give a code snippet for that, it would help....thanks in advance for the tips...

Paul75

Here's the code that created the table: (1 of 4)

<?php

// Generate and run the 35 queries required to be calculated to populate the 35 squares of the confusion matrix

// 1-25 - The main grid

$query1 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'a' AND a2.Hypothesis = 'a' AND
(a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result1 = mysql_query($query1);

while($hypos1 = mysql_fetch_array($result1))
{
$aa = $hypos1['COUNT(*)'];
}

$query2 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'b' AND a2.Hypothesis = 'a' AND
(a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result2 = mysql_query($query2);

while($hypos2 = mysql_fetch_array($result2))
{
$ab = $hypos2['COUNT(*)'];
}

$query3 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'c' AND a2.Hypothesis = 'a' AND
(a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result3 = mysql_query($query3);

while($hypos3 = mysql_fetch_array($result3))
{
$ac = $hypos3['COUNT(*)'];
}

$query4 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'd' AND
a2.Hypothesis = 'a' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result4 = mysql_query($query4);

while($hypos4 = mysql_fetch_array($result4))
{
$ad = $hypos4['COUNT(*)'];
}

$query5 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'e' AND
a2.Hypothesis = 'a' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result5 = mysql_query($query5);

while($hypos5 = mysql_fetch_array($result5))
{
$ae = $hypos5['COUNT(*)'];
}

$query6 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'a' AND
a2.Hypothesis = 'b' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result6 = mysql_query($query6);

while($hypos6 = mysql_fetch_array($result6))
{
$ba = $hypos6['COUNT(*)'];
}

$query7 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'b' AND
a2.Hypothesis = 'b' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result7 = mysql_query($query7);

while($hypos7 = mysql_fetch_array($result7))
{
$bb = $hypos7['COUNT(*)'];
}

$query8 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'c' AND
a2.Hypothesis = 'b' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result8 = mysql_query($query8);

while($hypos8 = mysql_fetch_array($result8))
{
$bc = $hypos8['COUNT(*)'];
}

$query9 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'd' AND
a2.Hypothesis = 'b' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result9 = mysql_query($query9);

while($hypos9 = mysql_fetch_array($result9))
{
$bd = $hypos9['COUNT(*)'];
}

$query10 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'e' AND
a2.Hypothesis = 'b' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result10 = mysql_query($query10);

while($hypos10 = mysql_fetch_array($result10))
{
$be = $hypos10['COUNT(*)'];
}

$query11 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'a' AND
a2.Hypothesis = 'c' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result11 = mysql_query($query11);

while($hypos11 = mysql_fetch_array($result11))
{
$ca = $hypos11['COUNT(*)'];
}

$query12 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'b' AND
a2.Hypothesis = 'c' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result12 = mysql_query($query12);

while($hypos12 = mysql_fetch_array($result12))
{
$cb = $hypos12['COUNT(*)'];
}

$query13 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'c' AND
a2.Hypothesis = 'c' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result13 = mysql_query($query13);

while($hypos13 = mysql_fetch_array($result13))
{
$cc = $hypos13['COUNT(*)'];
}

$query14 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'd' AND
a2.Hypothesis = 'c' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result14 = mysql_query($query14);

while($hypos14 = mysql_fetch_array($result14))
{
$cd = $hypos14['COUNT(*)'];
}

....TBC

Paul75

....CONT (2 of 4)

$query15 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'e' AND
a2.Hypothesis = 'c' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result15 = mysql_query($query15);

while($hypos15 = mysql_fetch_array($result15))
{
$ce = $hypos15['COUNT(*)'];
}

$query16 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'a' AND
a2.Hypothesis = 'd' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result16 = mysql_query($query16);

while($hypos16 = mysql_fetch_array($result16))
{
$da = $hypos16['COUNT(*)'];
}

$query17 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'b' AND
a2.Hypothesis = 'd' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result17 = mysql_query($query17);

while($hypos17 = mysql_fetch_array($result17))
{
$db = $hypos17['COUNT(*)'];
}

$query18 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'c' AND
a2.Hypothesis = 'd' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result18 = mysql_query($query18);

while($hypos18 = mysql_fetch_array($result18))
{
$dc = $hypos18['COUNT(*)'];
}

$query19 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'd' AND
a2.Hypothesis = 'd' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result19 = mysql_query($query19);

while($hypos19 = mysql_fetch_array($result19))
{
$dd = $hypos19['COUNT(*)'];
}

$query20 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'e' AND
a2.Hypothesis = 'd' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result20 = mysql_query($query20);

while($hypos20 = mysql_fetch_array($result20))
{
$de = $hypos20['COUNT(*)'];
}

$query21 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'a' AND
a2.Hypothesis = 'e' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result21 = mysql_query($query21);

while($hypos21 = mysql_fetch_array($result21))
{
$ea = $hypos21['COUNT(*)'];
}

$query22 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'b' AND
a2.Hypothesis = 'e' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result22 = mysql_query($query22);

while($hypos22 = mysql_fetch_array($result22))
{
$eb = $hypos22['COUNT(*)'];
}

$query23 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'c' AND
a2.Hypothesis = 'e' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result23 = mysql_query($query23);

while($hypos23 = mysql_fetch_array($result23))
{
$ec = $hypos23['COUNT(*)'];
}

$query24 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'd' AND
a2.Hypothesis = 'e' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result24 = mysql_query($query24);

while($hypos24 = mysql_fetch_array($result24))
{
$ed = $hypos24['COUNT(*)'];
}

$query25 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'e' AND
a2.Hypothesis = 'e' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result25 = mysql_query($query25);

while($hypos25 = mysql_fetch_array($result25))
{
$ee = $hypos25['COUNT(*)'];
}

// 26-30 - The totals for rows

$query26 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND
(a1.Hypothesis = 'a' or a1.Hypothesis = 'b' or a1.Hypothesis = 'c' or a1.Hypothesis = 'd' or a1.Hypothesis = 'e')
AND a2.Hypothesis = 'a' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result26 = mysql_query($query26);

while($hypos26 = mysql_fetch_array($result26))
{
$tr1 = $hypos26['COUNT(*)'];
}

$query27 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND
(a1.Hypothesis = 'a' or a1.Hypothesis = 'b' or a1.Hypothesis = 'c' or a1.Hypothesis = 'd' or a1.Hypothesis = 'e')

AND a2.Hypothesis = 'b' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result27 = mysql_query($query27);

while($hypos27 = mysql_fetch_array($result27))
{
$tr2 = $hypos27['COUNT(*)'];
}

$query28 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND
(a1.Hypothesis = 'a' or a1.Hypothesis = 'b' or a1.Hypothesis = 'c' or a1.Hypothesis = 'd' or a1.Hypothesis = 'e')

AND a2.Hypothesis = 'c' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result28 = mysql_query($query28);

while($hypos28 = mysql_fetch_array($result28))
{
$tr3 = $hypos28['COUNT(*)'];
}

...TBC

Paul75

..cont (3 of 4)

$query29 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND
(a1.Hypothesis = 'a' or a1.Hypothesis = 'b' or a1.Hypothesis = 'c' or a1.Hypothesis = 'd' or a1.Hypothesis = 'e')

AND a2.Hypothesis = 'd' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result29 = mysql_query($query29);

while($hypos29 = mysql_fetch_array($result29))
{
$tr4 = $hypos29['COUNT(*)'];
}

$query30 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND
(a1.Hypothesis = 'a' or a1.Hypothesis = 'b' or a1.Hypothesis = 'c' or a1.Hypothesis = 'd' or a1.Hypothesis = 'e')

AND a2.Hypothesis = 'e' AND (a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result30 = mysql_query($query30);

while($hypos30 = mysql_fetch_array($result30))
{
$tr5 = $hypos30['COUNT(*)'];
}

// 31-35 - The totals for columns

$query31 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'a' AND
(a2.Hypothesis = 'a' or a2.Hypothesis = 'b' or a2.Hypothesis = 'c' or a2.Hypothesis = 'd' or a2.Hypothesis = 'e') AND
(a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result31 = mysql_query($query31);

while($hypos31 = mysql_fetch_array($result31))
{
$tc1 = $hypos31['COUNT(*)'];
}

$query32 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'b' AND
(a2.Hypothesis = 'a' or a2.Hypothesis = 'b' or a2.Hypothesis = 'c' or a2.Hypothesis = 'd' or a2.Hypothesis = 'e') AND
(a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result32 = mysql_query($query32);

while($hypos32 = mysql_fetch_array($result32))
{
$tc2 = $hypos32['COUNT(*)'];
}

$query32 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'c' AND
(a2.Hypothesis = 'a' or a2.Hypothesis = 'b' or a2.Hypothesis = 'c' or a2.Hypothesis = 'd' or a2.Hypothesis = 'e') AND
(a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result32 = mysql_query($query32);

while($hypos32 = mysql_fetch_array($result32))
{
$tc3 = $hypos32['COUNT(*)'];
}

$query33 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'd' AND
(a2.Hypothesis = 'a' or a2.Hypothesis = 'b' or a2.Hypothesis = 'c' or a2.Hypothesis = 'd' or a2.Hypothesis = 'e') AND
(a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result33 = mysql_query($query33);

while($hypos33 = mysql_fetch_array($result33))
{
$tc4 = $hypos33['COUNT(*)'];
}

$query34 = "SELECT COUNT(*) FROM annotations AS a1, annotations AS a2 WHERE (a1.Patient I.D. = a2.Patient I.D. OR a2.Patient I.D. = '0')
AND a1.Day = a2.Day AND a1.Hour = a2.Hour AND a1.Updated? (Y/N) = '1' and a2.Updated? (Y/N) = '1' AND
a1.Clinician/Rule-Set I.D. = '".$var_value."' AND a2.Clinician/Rule-Set I.D. = '".$usename2."' AND a1.Hypothesis = 'e' AND
(a2.Hypothesis = 'a' or a2.Hypothesis = 'b' or a2.Hypothesis = 'c' or a2.Hypothesis = 'd' or a2.Hypothesis = 'e') AND
(a1.Patient I.D. = '".$fr."') AND (a2.Patient I.D. = '".$fr2."' OR a2.Patient I.D. = '0')";

$result34 = mysql_query($query34);

while($hypos34 = mysql_fetch_array($result34))
{
$tc5 = $hypos34['COUNT(*)'];
}

// Query to get screen name of comparator
$querycun = "SELECT screenname FROM clinicianandruleset where Clinician/Rule-Set I.D.='".$usename2."'";

$resultcun = mysql_query($querycun);

while($cun=mysql_fetch_array($resultcun))
{
$cund = $cun['screenname'];
}

// Create confusion matrix and populate it with query results

echo "<table width='40' cellpadding='15' cellspacing='5' border='2'>";

echo "<tr>
<td colspan=\"2\" rowspan=\"2\" style=\"border:0;\"></td>
<th colspan=\"6\" align=\"center\" style=\"border:0;\">$usename</th>
</tr>";

echo "<tr>
<td align=\"center\">A</td>
<td align=\"center\">B</td>
<td align=\"center\">C</td>
<td align=\"center\">D</td>
<td align=\"center\">E</td>
<td align=\"center\">Total</td>
</tr>";

echo "<tr>
<th rowspan=\"6\" style=\"border:0;\">$cund</th>
</tr>";

echo "<tr>
<td align=\"center\">A</td>
<td align=\"center\"style=\"background-color:lightblue;\"> <input type=\"hidden\" name=\"fr\" value=\"$fr\">
<input type=\"hidden\" name=\"fr2\" value=\"$fr2\">
<input type=\"hidden\" name=\"cund\" value=\"$cund\">
<input type=\"submit\" name=\"Submitano[0]\" value='$aa'</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[1]\" value='$ab'</td>
<td align=\"center\" ><input type=\"submit\" name=\"Submitano[2]\" value='$ac'</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[3]\" value='$ad'</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[4]\" value='$ae'</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[25]\" value='$tr1'</td>
</tr>";

echo "<tr>
<td align=\"center\">B</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[5]\" value='$ba'</td>
<td align=\"center\"style=\"background-color:lightblue;\"><input type=\"submit\" name=\"Submitano[6]\" value='$bb'</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[7]\" value='$bc'</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[8]\" value='$bd'</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[9]\" value='$be'</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[26]\" value='$tr2'</td>
</tr>";

echo "<tr>
<td align=\"center\">C</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[10]\" value='$ca'</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[11]\" value='$cb'</td>
<td align=\"center\" style=\"background-color:lightblue;\"><input type=\"submit\" name=\"Submitano[12]\" value='$cc'</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[13]\" value='$cd'</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[14]\" value='$ce'</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[27]\" value='$tr3'</td>
</tr>";

echo "<tr>
<td align=\"center\" >D</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[15]\" value='$da'</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[16]\" value='$db'</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[17]\" value='$dc'</td>
<td align=\"center\" style=\"background-color:lightblue;\"><input type=\"submit\" name=\"Submitano[18]\" value='$dd'</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[19]\" value='$de'</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[28]\" value='$tr4'</td>
</tr>";

echo "<tr>
<td align=\"center\">E</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[20]\" value='$ea'</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[21]\" value='$eb'</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[22]\" value='$ec'</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[23]\" value='$ed'</td>
<td align=\"center\" style=\"background-color:lightblue;\"><input type=\"submit\" name=\"Submitano[24]\" value='$ee'</td>
<td align=\"center\" ><input type=\"submit\" name=\"Submitano[29]\" value='$tr5'</td>
</tr>";

echo "<tr>
<td style=\"border:0;\"</td>
<td align=\"center\">Total</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[30]\" value='$tc1'</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[31]\" value='$tc2'</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[32]\" value='$tc3'</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[33]\" value='$tc4'</td>
<td align=\"center\"><input type=\"submit\" name=\"Submitano[34]\" value='$tc5'</td>
</tr>

	</table>";

</form>

...TBC

Paul75

...Cont (4 of 4)

And here's the code that picked up which square was chosen and thus which info to then use:

<?php

// Get required variables for queries

$var_value = $SESSION['myusername'];
$check = $SESSION['employee'];
$fr = $POST['fr'];
$fr2 = $POST['fr2'];
$usename2 = $SESSION['usename2'];
$cund = $POST['cund'];

// In order to know which square of the confusion matrix was chosen, and thus what annotations to base the queries on, create the POST form data
// from the confsuin matrix as an array

$chosen_query = array_pop(array_keys($_POST['Submitano']));

// If squares 1-25 were chosen

if ($chosen_query == 0)
{
$hypoc1 = "a";
$hypoc2 = "a";
}

elseif ($chosen_query == 1)
{
$hypoc1 = "b";
$hypoc2 = "a";
}

elseif ($chosen_query == 2)
{
$hypoc1 = "c";
$hypoc2 = "a";
}

elseif ($chosen_query == 3)
{
$hypoc1 = "d";
$hypoc2 = "a";
}

elseif ($chosen_query == 4)
{
$hypoc1 = "e";
$hypoc2 = "a";
}

elseif ($chosen_query == 5)
{
$hypoc1 = "a";
$hypoc2 = "b";
}

elseif ($chosen_query == 6)
{
$hypoc1 = "b";
$hypoc2 = "b";
}

elseif ($chosen_query == 7)
{
$hypoc1 = "c";
$hypoc2 = "b";
}

elseif ($chosen_query == 8)
{
$hypoc1 = "d";
$hypoc2 = "b";
}

elseif ($chosen_query == 9)
{
$hypoc1 = "e";
$hypoc2 = "b";
}

elseif ($chosen_query == 10)
{
$hypoc1 = "a";
$hypoc2 = "c";
}

elseif ($chosen_query == 11)
{
$hypoc1 = "b";
$hypoc2 = "c";
}

elseif ($chosen_query == 12)
{
$hypoc1 = "c";
$hypoc2 = "c";
}

elseif ($chosen_query == 13)
{
$hypoc1 = "d";
$hypoc2 = "c";
}

elseif ($chosen_query == 14)
{
$hypoc1 = "e";
$hypoc2 = "c";
}

elseif ($chosen_query == 15)
{
$hypoc1 = "a";
$hypoc2 = "d";
}

elseif ($chosen_query == 16)
{
$hypoc1 = "b";
$hypoc2 = "d";
}

elseif ($chosen_query == 17)
{
$hypoc1 = "c";
$hypoc2 = "d";
}

elseif ($chosen_query == 18)
{
$hypoc1 = "d";
$hypoc2 = "d";
}

elseif ($chosen_query == 19)
{
$hypoc1 = "e";
$hypoc2 = "d";
}

elseif ($chosen_query == 20)
{
$hypoc1 = "a";
$hypoc2 = "e";
}

elseif ($chosen_query == 21)
{
$hypoc1 = "b";
$hypoc2 = "e";
}

elseif ($chosen_query == 22)
{
$hypoc1 = "c";
$hypoc2 = "e";
}

elseif ($chosen_query == 23)
{
$hypoc1 = "d";
$hypoc2 = "e";
}

elseif ($chosen_query == 24)
{
$hypoc1 = "e";
$hypoc2 = "e";
}

// If rows (buttons) 25-30 were chosen

elseif ($chosen_query == 25)
{
$hypoc1 = "a' or a1.Hypothesis = 'b' or a1.Hypothesis = 'c' or a1.Hypothesis = 'd' or a1.Hypothesis = 'e";
$hypoc2 = "a";
}

elseif ($chosen_query == 26)
{
$hypoc1 = "a' or a1.Hypothesis = 'b' or a1.Hypothesis = 'c' or a1.Hypothesis = 'd' or a1.Hypothesis = 'e";
$hypoc2 = "b";
}

elseif ($chosen_query == 27)
{
$hypoc1 = "a' or a1.Hypothesis = 'b' or a1.Hypothesis = 'c' or a1.Hypothesis = 'd' or a1.Hypothesis = 'e";
$hypoc2 = "c";
}

elseif ($chosen_query == 28)
{
$hypoc1 = "a' or a1.Hypothesis = 'b' or a1.Hypothesis = 'c' or a1.Hypothesis = 'd' or a1.Hypothesis = 'e";
$hypoc2 = "d";
}

elseif ($chosen_query == 29)
{
$hypoc1 = "a' or a1.Hypothesis = 'b' or a1.Hypothesis = 'c' or a1.Hypothesis = 'd' or a1.Hypothesis = 'e";
$hypoc2 = "e";
}

// If columns (buttons) 31-35 were chosen

elseif ($chosen_query == 30)
{
$hypoc1 = "a";
$hypoc2 = "a' or a2.Hypothesis = 'b' or a2.Hypothesis = 'c' or a2.Hypothesis = 'd' or a2.Hypothesis = 'e";
}

elseif ($chosen_query == 31)
{
$hypoc1 = "b";
$hypoc2 = "a' or a2.Hypothesis = 'b' or a2.Hypothesis = 'c' or a2.Hypothesis = 'd' or a2.Hypothesis = 'e";
}

elseif ($chosen_query == 32)
{
$hypoc1 = "c";
$hypoc2 = "a' or a2.Hypothesis = 'b' or a2.Hypothesis = 'c' or a2.Hypothesis = 'd' or a2.Hypothesis = 'e";
}

elseif ($chosen_query == 33)
{
$hypoc1 = "d";
$hypoc2 = "a' or a2.Hypothesis = 'b' or a2.Hypothesis = 'c' or a2.Hypothesis = 'd' or a2.Hypothesis = 'e";
}

elseif ($chosen_query == 34)
{
$hypoc1 = "e";
$hypoc2 = "a' or a2.Hypothesis = 'b' or a2.Hypothesis = 'c' or a2.Hypothesis = 'd' or a2.Hypothesis = 'e";
}

// Create queries to display annotions and readings for chosen confusion matrix square

// If squares (main buttons and rows) 1-30 were chosen

if (($chosen_query == 0) || ($chosen_query == 1) || ($chosen_query == 2) || ($chosen_query == 3) || ($chosen_query == 4) || ($chosen_query == 5) ||
($chosen_query == 6) || ($chosen_query == 7) || ($chosen_query == 8) || ($chosen_query == 9) || ($chosen_query == 10) || ($chosen_query == 11) ||
($chosen_query == 12) || ($chosen_query == 13) || ($chosen_query == 14) || ($chosen_query == 15) || ($chosen_query == 16) || ($chosen_query == 17) ||
($chosen_query == 18) || ($chosen_query == 19) || ($chosen_query == 20) || ($chosen_query == 21) || ($chosen_query ==22) || ($chosen_query == 23) ||
($chosen_query == 24) || ($chosen_query == 25) || ($chosen_query == 26) || ($chosen_query == 27) || ($chosen_query == 28) || ($chosen_query == 29))

{

$query50 = "SELECT a1.`Patient I.D.`, a2.`Hypothesis`, a1.`Hypothesis`, a1.`Day`, a1.`Hour` , r.`Time` , r.`50%Dex/15uInsulin` , 
r.`Adrenaline`, r.`Alfentanil`, r.`Blood_Pump_Speed`, r.`CVP` , r.`Diastolic`, r.`Dobutamine`, r.`FiO2`, r.`Gelofusin`, r.`Hartmanns`, 
r.`HR`, r.`Hydrocortisone`, r.`LiDCOCCI`, r.`LiDCOCCO`, r.`LiDCODO2`, r.`LiDCOSV`, r.`MAP`, r.`MgSO4`, r.`Noradrenaline`, 
r.`PiCCO_CI`, r.`PiCCO_CO`, r.`PiCCO_EVLWI`, r.`PiCCO_SV`, r.`Potassium`, r.`Potassium_Phosphate`, r.`Propofol`, r.`Sodium_Chloride_0.9%`, 
r.`Sodium_Phosphate`, r.`SpO2`, r.`Systolic`, r.`Temp`, r.`Temp_Site`, r.`Urine:_Catheter`, r.`Vasopressin`, r.`Velosulin`
FROM annotations AS a1, annotations AS a2, readings AS r
WHERE a1.`Patient I.D.` = r.`Patient I.D.` 
AND a1.`Day` = r.`Day` 
AND a1.`Hour` = r.`Hour` 
AND (a1.`Patient I.D.` = a2.`Patient I.D.` OR a2.`Patient I.D.` =  '0')
AND a1.`Day` = a2.`Day` 
AND a1.`Hour` = a2.`Hour` 
AND a1.`Updated? (Y/N)` = '1' and a2.`Updated? (Y/N)` = '1'
AND a1.`Clinician/Rule-Set I.D.` =  '".$var_value."'
AND a2.`Clinician/Rule-Set I.D.` =  '".$usename2."'
AND (a1.`Hypothesis` =  '".$hypoc1."')
AND (a2.`Hypothesis` =  '".$hypoc2."')
AND (a1.`Patient I.D.` = '".$fr."') AND (a2.`Patient I.D.` = '".$fr2."' OR a2.`Patient I.D.` = '0')";


$result50 = mysql_query($query50);

....etc

}
else
{

($chosen_query == 30) || ($chosen_query == 31) || ($chosen_query == 32) || ($chosen_query == 33) || ($chosen_query == 34);

// If squares (columns) 31-35 were chosen

$query52 = "SELECT a1.`Patient I.D.`, a1.`Hypothesis`, a2.`Hypothesis`, a1.`Day`, a1.`Hour` , r.`Time` , r.`50%Dex/15uInsulin` , r.`Adrenaline`, 
r.`Alfentanil`, r.`Blood_Pump_Speed`, r.`CVP` , r.`Diastolic`, r.`Dobutamine`, r.`FiO2`, r.`Gelofusin`, r.`Hartmanns`, r.`HR`, r.`Hydrocortisone`, 
r.`LiDCOCCI`, r.`LiDCOCCO`, r.`LiDCODO2`, r.`LiDCOSV`, r.`MAP`, r.`MgSO4`, r.`Noradrenaline`, r.`PiCCO_CI`, r.`PiCCO_CO`, r.`PiCCO_EVLWI`, 
r.`PiCCO_SV`, r.`Potassium`, r.`Potassium_Phosphate`, r.`Propofol`, r.`Sodium_Chloride_0.9%`, r.`Sodium_Phosphate`, r.`SpO2`, r.`Systolic`, r.`Temp`, 
r.`Temp_Site`, r.`Urine:_Catheter`, r.`Vasopressin`, r.`Velosulin`
FROM annotations AS a1, annotations AS a2, readings AS r
WHERE a1.`Patient I.D.` = r.`Patient I.D.` 
AND a1.`Day` = r.`Day` 
AND a1.`Hour` = r.`Hour` 
AND (a1.`Patient I.D.` = a2.`Patient I.D.` OR a2.`Patient I.D.` =  '0')
AND a1.`Day` = a2.`Day` 
AND a1.`Hour` = a2.`Hour` 
AND a1.`Updated? (Y/N)` = '1' and a2.`Updated? (Y/N)` = '1'
AND a1.`Clinician/Rule-Set I.D.` =  '".$var_value."'
AND a2.`Clinician/Rule-Set I.D.` =  '".$usename2."'
AND (a1.`Hypothesis` =  '".$hypoc1."')
AND (a2.`Hypothesis` =  '".$hypoc2."')
AND (a1.`Patient I.D.` = '".$fr."') AND (a2.`Patient I.D.` = '".$fr2."' OR a2.`Patient I.D.` = '0')";

$result52 = mysql_query($query52);

...etc

Hope this helps.

Paul