I'm an iOS developer trying to update a bit 'o php to work with the mysqli\_\* stuff instead of the deprecated mysql\_\* stuff. 

I know next to nothing about php/mysql, and I'm stuck. I'm using a script found at <http://www.w3schools.com/php/php_mysql_select.asp>, with changes to reflect my field names etc

When I call the following from a browser I get an access error (Connection failed: Access denied for user 'whoisit7'@'localhost' (using password: YES)). The server name, password and username etc I'm using all work with an existing script in a browser but not with this new one. 

Can anyone point me at what I'm getting wrong?

```
<?php
$servername = "localhost";
$userName = "whoisit7_ios";
$password = "blahblahblah";
$dbName = "whoisit7_scathing";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

$sql = "SELECT name, latitude, longitude FROM location where status = 1";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
        echo "name: " . $row["name"]. " - latlong: " . $row["latitude"]. " " . $row["longitude"]. "<br>";
    }
} else {
    echo "0 results";
}

mysqli_close($conn);
?>

```