Open Realty - Joomla! Forum - community, help and support

1/ fails inside ie, error "ie cannot open internet site" shows url, says "operation aborted", error page "the page cannot displayed". did band-aide make not appear if ie browser. found out javascript has go in head or @ end of body. problem don't know how joomla/openrealty set-up because of database querying , "get user" function has go on open realty page.

2/ i'm making lot of querying know unnecessary, can show me how condense 6 query statements 1 statement, how spit them out?

code: select all

<?php                        
require_once('http://website.com/agent/include/user.inc.php');
$userid = $_get['user'];

//get latitude
      $querylat = mysql_query("select userdbelements_field_value realty_en_userdbelements userdbelements_field_name='latitude' , userdb_id=$userid");
      $query_latrow = mysql_fetch_array($querylat);
      $latitude = ($query_latrow[userdbelements_field_value]);
   
//get longtitude
      $querylong = mysql_query("select userdbelements_field_value realty_en_userdbelements userdbelements_field_name='longitude' , userdb_id=$userid");
      $query_longrow = mysql_fetch_array($querylong);
      $longitude = ($query_longrow[userdbelements_field_value]);
      
//get address
      $queryadd = mysql_query("select userdbelements_field_value realty_en_userdbelements userdbelements_field_name='address' , userdb_id=$userid");
      $query_addrow = mysql_fetch_array($queryadd);
      $address = ($query_addrow[userdbelements_field_value]);

//get city
      $querycity = mysql_query("select userdbelements_field_value realty_en_userdbelements userdbelements_field_name='city' , userdb_id=$userid");
      $query_cityrow = mysql_fetch_array($querycity);
      $city = ($query_cityrow[userdbelements_field_value]);
      
//get state
      $querystate = mysql_query("select userdbelements_field_value realty_en_userdbelements userdbelements_field_name='state' , userdb_id=$userid");
      $query_staterow = mysql_fetch_array($querystate);
      $state = ($query_staterow[userdbelements_field_value]);   
   
//get zip
      $queryzip = mysql_query("select userdbelements_field_value realty_en_userdbelements userdbelements_field_name='zip' , userdb_id=$userid");
      $query_ziprow = mysql_fetch_array($queryzip);
      $zip = ($query_ziprow[userdbelements_field_value]);   

?>

<div id="map" style="width: 570px; height: 300px"></div>
    <script src="http://maps.google.com/maps?file=api&v=1&key=api_key" type="text/javascript">
    </script>
   
<script>
if (navigator.appname!="microsoft internet explorer") {
        var map = new gmap2(document.getelementbyid("map"));
      map.addcontrol(new glargemapcontrol());
      map.addcontrol(new gmaptypecontrol());
        map.setcenter(new glatlng(<?php echo $latitude;?>,<?php echo $longitude;?>), 16);
      map.setmaptype(g_hybrid_type);
 
      function createmarker(point, number, html) {
      var marker = new gmarker(point);
      gevent.addlistener(marker, "click", function() {
           marker.openinfowindowhtml(html);
      });
         // not sure if next line still necessary
      if (!marker.point) {marker.point = marker.getpoint()}
      return marker;

}

      var html = '<b>we right here.<br><br><?php echo $address;?><br><?php echo $city;?>, <?php echo $state;?> <?php echo $zip;?></b>';
      var point = new glatlng(<?php echo $latitude;?>,<?php echo $longitude;?>);
      var marker = createmarker(point,1,html);
      gmarkers = new array();
      gmarkers.push(marker);
      map.addoverlay(gmarkers[0]);
}


</script>