title: mysqli_num_rows() expects parameter 1 to be mysqli_result geolocation
body: <p>I really don't know what i'm doing wrong. I want to count the rows in my query. My id's started from 1 to ... step 1, so the biggest number is the last record. I only want to let the script run on the last record of de DB. So here is my code.</p>
  
  <pre><code>public function saveLongLan()
      {
          define("MAPS_HOST", "maps.google.com");
          define("KEY", "MYKEY");
  
          $link = mysql_connect('localhost', 'root', 'root');
          if (!$link) {
           die('Not connected : ' . mysql_error());
          }
  
          // Set the active MySQL database
          $db_selected = mysql_select_db('Foodsquare', $link);
          if (!$db_selected)  
          {
              die("Can\'t use db : " . mysql_error());
          }
  
          $query = "SELECT * FROM tblPlaces WHERE 1";
          $result = mysql_query($query);
          $row_cnt = mysqli_num_rows($result);
  
  
              if (!$result) 
                  {
                      die("Invalid query: " . mysql_error());
                  }
  
  
          $delay = 0;
          $base_url = "http://" . MAPS_HOST . "/maps/geo?output=xml" . "&amp;key=" . KEY;
  
          while ($row = @mysql_fetch_assoc($result)) 
              {
                  $geocode_pending = true;
  
                      while ($geocode_pending) 
                          {
                              $address = $row["Street"];
                              $id = $row["Id"];
                              $request_url = $base_url . "&amp;q=" . urlencode($address);
                              $xml = simplexml_load_file($request_url) or die("url not loading");
  
                              $status = $xml-&gt;Response-&gt;Status-&gt;code;
                              if (strcmp($status, "200") == 0) 
                                  {
                                        // Successful geocode
                                        $geocode_pending = false;
                                        $coordinates = $xml-&gt;Response-&gt;Placemark-&gt;Point-&gt;coordinates;
                                        //explode functie breekt een string af vanaf een bepaald teken en stopt hem dan in een array
                                        $coordinatesSplit = explode(',', $coordinates);
                                        // formaat: Longitude, Latitude, Altitude
                                        $lat = $coordinatesSplit[1];//getal = plaats in array
                                        $lng = $coordinatesSplit[0];
  
  
                                        $query = sprintf("UPDATE tblPlaces " .
                                                  " SET lat = '%s', lng = '%s' " .
                                                  " WHERE id = '". $row_cnt . "' LIMIT 1;",
                                               mysql_real_escape_string($lat),
                                               mysql_real_escape_string($lng),
                                               mysql_real_escape_string($id));
                                        $update_result = mysql_query($query);
                                            if (!$update_result) 
                                              {
                                              die("Invalid query: " . mysql_error());
                                              }
                                  } else if (strcmp($status, "620") == 0) 
                                      {
                                            // sent geocodes too fast
                                            $delay += 100000;
                                      } 
                                      else 
                                      {
                                          // failure to geocode
                                          $geocode_pending = false;
                                          echo "Address " . $address . " failed to geocoded. ";
                                      echo "Received status " . $status . " \n";
                                      }
                                  usleep($delay);
                          }
              }
  
      }
  </code></pre>