• Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

mysql_result in mysqli

Collapse
X
  •  
  • Filter
  • Time
  • Show
Clear All
new posts

    mysql_result in mysqli

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

    If everything isn't black and white, I say, 'Why the hell not?'
    John Wayne (My guru, not to be confused with my beloved prophet Jeremy Clarkson)

    #2
    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!
    bloggoth

    If everything isn't black and white, I say, 'Why the hell not?'
    John Wayne (My guru, not to be confused with my beloved prophet Jeremy Clarkson)

    Comment

    Working...
    X