"mysqli_real_escape_string" is working but control is not entering into second if block
<p>Following program i picked from the php site (http://php.net/manual/en/mysqli.real-escape-string.php) and ran on my system running wamp server.
I found that escape charecter is getting added but control is not getting inside 2nd if block</p>

<p>Here's the code:</p>

<pre><code>&lt;?php
$link = mysqli_connect("localhost", "admin", "admin", "sampdb");

/* check connection */
if (mysqli_connect_errno()) {
        printf("Connect failed: %s\n", mysqli_connect_error());
            exit();
}

mysqli_query($link, "CREATE TEMPORARY TABLE myCity LIKE City");

$city = "'s Hertogenbosch";

/* this query will fail, cause we didn't escape $city */
if (!mysqli_query($link, "INSERT into myCity (Name) VALUES ('$city')")) {
        printf("Error: %s\n", mysqli_sqlstate($link));
}

 $city = mysqli_real_escape_string($link, $city);
print $city;

/* this query with escaped $city will work */
if (mysqli_query($link, "INSERT into myCity (Name) VALUES ('$city')")) {
        printf("%d Row inserted.\n", mysqli_affected_rows($link));
}

mysqli_close($link);
?&gt;
</code></pre>

<p>O/P : </p>

<p>Error: 42000</p>

<p>\'s Hertogenbosch</p>

<p>As per example mentioned in the link : "http://php.net/manual/en/mysqli.real-escape-string.php" the control should enter into the second if block and print number of rows inserted. which is not happening in this case.</p>
