Query returns only one result, put into variable

[rmaij]

The query is going to only result in one item from a table. I want to put that into a variable.

<?php

include("./header.php");
$connID = connect_to_techsupport();

$query = "SELECT ipaddress.IPAddress FROM ipaddress, ipaddress_server WHERE ipaddress.ipaddress_id = ipaddress_server.ipaddress_id AND ipaddress_server.server_id = {$_GET['serverid']}";

echo '<table>';

$result = mysql_query($query);

If I look at what $result is from there, it says something like Resource #2. But if I draw up the table and put it out that way it gives me what I want. How do I just drop what my only result is into a variable from here.

Thanks for the help.

[rmaij]

got it......never mind

list ($ip) = mysql_fetch_array ($result, MYSQL_NUM);