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!
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!
Comment