Posted by homepricemaps@gmail.com on 06/24/06 15:44

i run a mapping website at http://www.HomePriceMaps.com which maps real
estate prices however i have found that when i do select * where there
are 10 records found in the db that for some reason only 9 are returned
to the user. If there are only 2 records found in the db than only 1
is returned.

my php code looks like this and i cannot tell if its the logic of my
php code or perhaps my javascript:

php code

$query = "SELECT * FROM homepricemaps where citystate = '" . $input
.."';


javascript function

// A function to create the marker and set up
the event window
function createMarker(point,html, label) {
var html = '<div style="width: 300px;height:
175px">' + html + '</div>';
var marker = new GMarker(point, icon);
GEvent.addListener(marker, "click", function() {
//make view default map because sometimes don't
have sattelite images
map.setMapType(G_MAP_TYPE);
map.centerAndZoom(point,3);
marker.openInfoWindowHtml(html);
});
// save the info we need to use later for
the sidebar
gmarkers[i] = marker;
htmls[i] = html;
// add a line to the sidebar html
sidebar_html += '<a
href="javascript:myclick(' + i + ')">' + '<img
src="http://labs.google.com/ridefinder/images/mm_20_red.png">' + label
+ '</a><br>';

i++;


return marker;

}

• Next in forum: Best approach for server side Form Validation ?
• Prev in forum: Re: AJAX + Rubberized Text (GMail Subject Like)
• Thread view: php returns 9 records instead of 10 when i do a select *

[Reply to this message]