Selecting and Displaying Two Columns

Anon

I have looked through the exisiting posts and found twosuggestiong to this problem. I have tried them but they don't seem to work. My situation is: I have a MySQL table with two columns INPUT and OUTPUT. I need to get both of them, place them in and array and display both columns COMBINED in an ORDERED list ASCENDING.

I have tried...

1) Creating a temp table and using INSERT INTO temp (combined) SELECT input,output etc.. this didn't seem to work.

2) Creating an array. I believe this to be the proper way however I can't seem to get the PHP syntax right.

Any ideas and/or code snippets?

Thanks!

Anon

It sounds like you're making this much harder than it should be:

Select the data in ASC order. (but ordered by what? You're not clear on this)

Loop through the results using a while or for loop and mysql_fetch_array(). At the same time display the results.

christer

Try something like this:

$result = mysql_query("select * from tbl_name order by something ASC");
while($row = mysql_fetch_array($result))
{
print($row["INPUT"] . " " . $row["OUTPUT"] . "<BR>");
}

Since you did not explain your problem that well, this is what I came up with. If this is not anything near what you meant, try and explain your problem better. 🙂

Hope this was to any help though.

Anon

What I am ultimately tying to do is find the 95th percentile of a range of numbers. I have it working seperately but for certain reasons they also need a combined percentile. A further explanation as it was explained to me:

A COMBINED query, with different values... i = input, o = output
Let's suppose that INPUT is ORDERED in descending manner:

1 => 25 -> i
2 => 37 -> i
3 => 67 -> i
4 => 78 -> i
5 => 99 -> i
6 => 123 -> i
7 => 128 -> i
8 => 160 -> i
9 => 170 -> i
10 => 189 -> i
11 => 987 -> i
12 => 990 -> i
13 => 1023 -> i
14 => 1056 -> i
15 => 2034 -> i

AND that OUTPUT is ORDERED in descending manner:

1 => 32 -> o
2 => 45 -> o
3 => 67 -> o
4 => 89 -> o
5 => 90 -> o
6 => 112 -> o
7 => 345 -> o
8 => 678 -> o
9 => 998 -> o
10 => 999 -> o
11 => 1023 -> o
12 => 1145 -> o
13 => 1176 -> o
14 => 2365 -> o
15 => 9078 -> o

AND listed TOGETHER in a COMBINED ASCENDING to DESCENDING manner,
listed by what follows '->' as $value is (this is what I am trying to accomplish):

1 => 25 -> i
2 => 32 -> o
3 => 37 -> i
4 => 45 -> o
5 => 67 -> i
6 => 67 -> o
7 => 78 -> i
... n

Suppose n = 14 (95th percentile). Then answer is .95 * 15 = 14.25(14)
| 14th position = 160 (INBOUND)

My question was: How do I get both input and output to 'mix' together in an ordered list?