Help with Arrays!!!

[sdimoff]

Hey,

I Need some help trying to query data from MySQL with a array... I have the following code in my html:

<?php
$db = mysql_connect("localhost", "","");

mysql_select_db("info",$db);

$result = mysql_query("SELECT * FROM CUSTOMER_SERVER WHERE CUSTOMER_ID=$CUSTOMER_ID",$db);
while ($myrow = mysql_fetch_row($result)) {
echo "<a href=\"serverinfo.php?SERVER_ID=$myrow[1]\">$myrow[1]</a>&nbsp;&nbsp;&nbsp;&nbsp;$row
[2]<br>";
}
?>

Now I need a line in there to go and query the database using the array myrow[1], but when I do it I get in error from mysql... I'm not sure what type of while loop I need to have in there to tell the database this isn't a single variable theres more info in there to keep going until its done... or can that even be done?

What Im trying to do is display the servers a certain customer has.. THEN go to another table and use the $myrow[1] to show that type of server it is...

Any ideas???

[deckrdx]

You could do something like this....

$result = mysql_query("SELECT s.*, t.server_typ FROM customer_server as s, server_type as t WHERE s.customer_id=$CUSTOMER_ID AND s.server_id=t.server_id",$db);

[[deleted]]

$myrow[1] is not an array, it's an element of an array.

Also, remember that $result is still in use in the while loop, so you cannot run a new query and store the result in "$result". You have to use a different name.

And finally, MySQL (and most other database) can very simply retreive information from several tables at once.
Read the MySQL manual about the JOIN statement.
That way you can get the customer data and the server type in one query.