[RESOLVED] sort SQL statements

[Broadcast]

Hi,

I have 2 MySQL select statement

		$query1 = "SELECT mib_value FROM $db_table where mib_navn = 'alarmLineId'";
		$result1 = mysql_query($query1);

		$query2 = "SELECT mib_value FROM $db_table where mib_navn = 'alarmName'";
		$result2 = mysql_query($query2);

$query1 will have these values INTEGER:1, INTEGER:2, INTEGER:3.........

$query2 will have these values STRING:CI1, STRING:CI2, STRING:CI3.........

now my problem is that a wont it printed out like this

INTERGER:1 STRING:CI1
INTERGER:2 STRING:CI2
INTERGER:3 STRING:CI3

And not like this

INTERGER:1

INTERGER:2

INTERGER:3

STRING:CI1
STRING:CI2
STRING:CI3

And this is the only one i know how to do :queasy:

Thank you...

[vaaaska]

There are a billion ways to do this...using what you have here perhaps try it this way.

$result1['mib_value'][0] . ' -  ' . $result2['mib_value'][0] . '<br />';
$result1['mib_value'][1] . ' -  ' . $result2['mib_value'][1] . '<br />';
$result1['mib_value'][2] . ' -  ' . $result2['mib_value'][2] . '<br />';

But honestly, you could probably do this with one query and some transformation on your array output.

[Broadcast]

vaaaska wrote:

There are a billion ways to do this...using what you have here perhaps try it this way.

$result1['mib_value'][0] . ' -  ' . $result2['mib_value'][0] . '<br />';
$result1['mib_value'][1] . ' -  ' . $result2['mib_value'][1] . '<br />';
$result1['mib_value'][2] . ' -  ' . $result2['mib_value'][2] . '<br />';

it print thes out

-

vaaaska wrote:

But honestly, you could probably do this with one query and some transformation on your array output.

but how to do that ???
can you give me an example...

[vaaaska]

Honestly, the problem here really lies in the design of your database. What happens is the number of 'alarmLineId' is not equal to 'alarmName'? The way to deal with that is with more php (and it shoudn't be necessary.

Is 'alarmLineId' related to 'alarmName' in any way? It seems they should be...

It's rather confusing what you are doing here.

[Broadcast]

heheh yes i am also confused.

what i am doing is that i have a button.
When i press it a function is started and then it go out and get data via snmp from a "box".
Then it return the data to a database, all the data is in one table.
The "box" has 96 inputs foreach input there is alarmName, alarmLineId, alarmGroup and so on.

My gool is to print them all out in a web page.

like this in a <table>

input - alarmName - alarmLineId - alarmGroup
input0 - CI0 - INTEGER:0 - STRING:HA
input1 - CI1 - INTEGER:1 - STRING:HU
input2 - CI2 - INTEGER:2 - STRING:HA

I hope this make more sense

this is my table.......
mysql> describe test;
+------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+----------------+
| mib_value | varchar(250) | YES | | NULL | |
| mib_navn | varchar(250) | YES | | NULL | |
| id_dnsnavn | int(15) | NO | PRI | NULL | auto_increment |
+------------+--------------+------+-----+---------+----------------+
3 rows in set (0.00

[vaaaska]

Yeah...confusing...why can't you grab them row by row?

$query = "SELECT * FROM $db_table";
$result = mysql_query($query);

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
   printf("ID: %s  Value: %s  Navn: %s", $row["id_dnsnavn"], $row["mib_value"], $row["mib_value"], $row["mib_navn"]);
}

What do you get?

[Broadcast]

This is only a little extraction from the output.

For not further confusion i will point out that i have 38 different mib_name

D: 1 Value: INTEGER: 1 Navn: INTEGER: 1ID: 2 Value: INTEGER: 2 Navn: INTEGER: 2ID: 3 Value: INTEGER: 3 Navn: INTEGER: 3ID: 4 Value: INTEGER: 4 Navn: INTEGER: 4ID: 5 Value: INTEGER: 5 Navn: INTEGER: 5ID: 6 Value: INTEGER: 6 Navn: INTEGER: 6ID: 7 Value: INTEGER: 7 Navn: INTEGER: 7ID: 8 Value: INTEGER: 8 Navn: INTEGER: 8ID: 9 Value: INTEGER: 9 Navn: INTEGER: 9ID: 10 Value: INTEGER: 10 Navn: INTEGER: 10ID: 11 Value: INTEGER: 11 Navn: INTEGER: 11ID: 12 Value: INTEGER: 12 Navn: INTEGER: 12ID: 13 Value: INTEGER: 13 Navn: INTEGER: 13ID: 14 Value: INTEGER: 14 Navn: INTEGER: 14ID: 15 Value: INTEGER: 15 Navn: INTEGER: 15ID: 16 Value: INTEGER: 16 Navn: INTEGER: 16ID: 17 Value: INTEGER: 17 Navn: INTEGER: 17ID: 18 Value: INTEGER: 18 Navn: INTEGER: 18ID: 19 Value: INTEGER: 19 Navn: INTEGER: 19ID: 20 Value: INTEGER: 20 Navn: INTEGER: 20ID: 21 Value: INTEGER: 21 Navn: INTEGER: 21ID: 22 Value: INTEGER: 22 Navn: INTEGER: 22ID: 23 Value: INTEGER: 23 Navn: INTEGER: 23ID: 24 Value: INTEGER: 24 Navn: INTEGER: 24ID: 25 Value: INTEGER: 25 Navn: INTEGER: 25ID: 26 Value: INTEGER: 26 Navn: INTEGER: 26ID: 27 Value: INTEGER: 27 Navn: INTEGER: 27ID: 28 Value: INTEGER: 28 Navn: INTEGER: 28ID: 29 Value: INTEGER: 29D: 1 Value: INTEGER: 1 Navn: INTEGER: 1ID: 2 Value: INTEGER: 2 Navn: INTEGER: 2ID: 3 Value: INTEGER: 3 Navn: INTEGER: 3ID: 4 Value: INTEGER: 4 Navn: INTEGER: 4ID: 5 Value: INTEGER: 5 Navn: INTEGER: 5ID: 6 Value: INTEGER: 6 Navn: INTEGER: 6ID: 7 Value: INTEGER: 7 Navn: INTEGER: 7ID: 8 Value: INTEGER: 8 Navn: INTEGER: 8ID: 9 Value: INTEGER: 9 Navn: INTEGER: 9ID: 10 Value: INTEGER: 10 Navn: INTEGER: 10ID: 11 Value: INTEGER: 11 Navn: INTEGER: 11ID: 12 Value: INTEGER: 12 Navn: INTEGER: 12ID: 13 Value: INTEGER: 13 Navn: INTEGER: 13ID: 14 Value: INTEGER: 14 Navn: INTEGER: 14ID: 15 Value: INTEGER: 15 Navn: INTEGER: 15ID: 16 Value: INTEGER: 16 Navn: INTEGER: 16ID: 17 Value: INTEGER: 17 Navn: INTEGER: 17ID: 18 Value: INTEGER: 18 Navn: INTEGER: 18ID: 19 Value: INTEGER: 19 Navn: INTEGER: 19ID: 20 Value: INTEGER: 20 Navn: INTEGER: 20ID: 21 Value: INTEGER: 21 Navn: INTEGER: 21ID: 22 Value: INTEGER: 22 Navn: INTEGER: 22ID: 23 Value: INTEGER: 23 Navn: INTEGER: 23ID: 24 Value: INTEGER: 24 Navn: INTEGER: 24ID: 25 Value: INTEGER: 25 Navn: INTEGER: 25ID: 26 Value: INTEGER: 26 Navn: INTEGER: 26ID: 27 Value: INTEGER: 27 Navn: INTEGER: 27ID: 28 Value: INTEGER: 28 Navn: INTEGER: 28ID: 29 Value: INTEGER: 29

[vaaaska]

Something isn't right here...your data is really like this?

1 | 1 | 1
2 | 2 | 2
3 | 3 | 3

And so on?

You migth read up on the formats for outputting your data here...the above doesn't seem right.

http://be2.php.net/manual/en/function.sprintf.php

[Broadcast]

When i do this then i recive the data like i wont it to

I will have to make a select from each mib_navn from the database and then do this...
echo "<table border='1'>";

	while(($line = mysql_fetch_array($result)) && ($line1 = mysql_fetch_array($result1)))
	{

echo "<tr>";

	echo "<td>" . $line['mib_value'] . "</td>";
	echo "<td>" . $line1['mib_value'] . "</td>";

echo "</tr>";
	}

echo "</table>";

vaaaska thank you for youre help and patience..