+ Reply to Thread
Posts 1 to 2 of 2
  1. #1

    Double Godlike!

    xoggoth's Avatar
    Join Date
    Jul 2005
    Location
    xoggoth towers
    Posts
    11,945
    Thanks (Given)
    1
    Thanks (Received)
    324
    Likes (Given)
    117
    Likes (Received)
    1096

    Default 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. #2

    Double Godlike!

    xoggoth's Avatar
    Join Date
    Jul 2005
    Location
    xoggoth towers
    Posts
    11,945
    Thanks (Given)
    1
    Thanks (Received)
    324
    Likes (Given)
    117
    Likes (Received)
    1096

    Default

    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)

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Content Relevant URLs by vBSEO 3.6.0 ©2011, Crawlability, Inc.