no - $result is a resource link, a pointer to the result set.
to get an array, you have to use one of the following
[man]mysql_fetch_array[/man]
[man]mysql_fetch_assoc[/man]
[man]mysql_fetch_row[/man]
you can also fetch the result as an object, using [man]mysql_fetch_object[/man]
Full example
// connect to db
$link = mysql_connect($hostname, $username, $password);
// select db
mysql_select_db($dbname);
// sql statement
$sql = "SELECT id, name, email FROM contacts";
// query the db
$result = mysql_query($sql);
// each call to mysql_fetch_assoc only fetches one row
// so we loop through each row
while($row = mysql_fetch_assoc($result)){
echo "ID : " . $row['id'];
echo "Name : " . $row['name'];
echo "Email : " . $row['email'];
echo "<BR>";
}
I personally always use mysql_fetch_assoc - this returns an associative array, so if you put this into $row (as above), you can then get the fields using $row['fieldname'] instead of messing around with numbers etc
hope that helps
adam
