mysql_result in mysqli

[xoggoth]

Having been arsed to look at what's going on, associative arrays etc., think the first should work. Can't rely on CUK to do all my work for me these days! Bah!

[xoggoth]

About to convert MySQL to MySQLi and putting together some notes before starting.

Mostly looks straightforward but appears there's no simple equivalent to mysql_result. Things on net rather poor and a bit confusing and I don't want a chunky function if I can help it.

I have a single row that matches the customer id and need to find out delivery country to calculate postage. This was:

$result=mysql_query("SELECT * FROM shop WHERE custid = '$custid'");
...
$country = mysql_result($result,0,country);

Looks to me it should be:
$result=conn->query("SELECT * FROM shop WHERE custid = '$custid'");
...
$country = $result->fetch_assoc()[country];

or should it be:

$country = $result->fetch_object()->country;

Any ideas? Cheas!