How to select specific Value in row from fetch_assoc () used to get a variable..?

Question

 while ($row = mysqli_fetch_assoc($result)) {
        printf ("%s (%s)\n", $row["Name"], $row["CountryCode"]);
    }

how to I select $row[name] variable first value only..

Answer 1

Do you mean you only want to print `$row['Name']` but not `$row['CountryCode']` ?

Perhaps you can try this:

printf("%s\n", $row['Name']);

But if you output into HTML document you might opt to using <br /> instead of '\n' on the format specifier there.

P.S. You should have tagged PHP.