<HTML>
<HEAD>
<META content="text/html; charset=iso-8859-9" http-equiv=Content-Type>
<META content="OPENWEBMAIL" name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
Dear Jacob,
<br />Thank you for your suggestion.
<br />The following php codes bring one of the record from mysql I mean only one row.
<br />
<br />That row consist of the cityname (iladi), districtname (ilceadi) and village name (koyadi).
<br />
<br />
<br />$query = "SELECT * FROM $db_tb WHERE iladi LIKE '$iladi' AND
<br />ilceadi LIKE '$ilceadi' AND koyadi LIKE '$koyadi'";
<br />
<br />$result = mysql_query($query) or die("Query failed : " . mysql_error());
<br />
<br />
<br />
<br />$num = mysql_numrows($result);
<br /> $i=0;
<br />while ($i < $num) {
<br />$koyadi = mysql_result($result,$i,"koyadi");
<br />$ilceadi = mysql_result($result,$i,"ilceadi");
<br />$iladi = mysql_result($result,$i,"iladi");
<br />$zone = mysql_result($result,$i,"zone");
<br />$lon = mysql_result($result,$i,"lon");
<br />$lat = mysql_result($result,$i,"lat");
<br /> ++$i;
<br />}
<br />
<br />> Have you tested whether any part of this code works? Which part is giving you trouble? Does your PHP log say anything?
<br />By using this query result I'm drawing point of the village on the map.
<br />The part of this issue does work succesfully. I mean drawing of the point was achieved already by the support of the list user.
<br />The second step Which I intend to write the name of village near to point.
<br />
<br />So I was changed the name of koyadi into villagename in order to understand for people in my message. sorry.
<br />Now I have tried to ad your suggestion into the php code but still the name of village doesnt appearing on the map..
<br />I hope I could explained What I'm trying to do.
<br />Thanks.
<br />Murat
<br />
<br />The new codes are here after your suggestion. But I2m not sure exacly where I have to put your suggestion on the code.
<br />$map_path="/var/www/html/zone/";
<br /> $map = ms_newMapObj($map_path."zone.map");
<br /> $map->setExtent($nMinX, $nMinY, $nMaxX, $nMaxY);
<br />
<br />// create a temp layer to hold our points
<br />$point_layer = ms_newLayerObj($map);
<br />$point_layer->set("name", "markers");
<br />$point_layer->set("type", MS_LAYER_POINT);
<br />$point_layer->set("status", MS_DEFAULT);
<br />$point_layer->setProjection("proj=latlong",MS_TRUE);
<br />
<br />// create a class and style for this layer
<br />$point_class = ms_newClassObj($point_layer);
<br />$point_style = ms_newStyleObj($point_class);
<br />$point_layer->set("labelitem","$koyadi");
<br />$point_symbol = $map->getSymbolByName("cpoint");
<br />
<br />$point_style->set("symbol", $point_symbol);
<br />$point_style->set("size", 12);
<br />$point_style->color->setRGB(255,0,255);
<br />$point_style->outlinecolor->setRGB(255,255,0);
<br />
<br />$label = $point_class->label;
<br />$label->set("position", MS_CC);
<br />
<br />$label->set("font","sans");
<br />$label->set("type",MS_TRUEYPE);
<br />$label->set("size",MS_MEDIUM);
<br />$label->color->setRGB(22,8,3);
<br />$label->backgroundcolor->setRGB(0,0,0);
<br />$label->set(minsize,4);
<br />$label->set(maxsize,100000);
<br />
<br />
<br />// draw our image without the points
<br /> $ref = $map->drawreferencemap();
<br /> $legend=$map->drawLegend();
<br />
<br />$image = $map->draw();
<br />
<br />// initialize our point and add it to the map
<br />$point = ms_newPointObj();
<br />$longitude=$lon;// comes from select queries from mysql as a result
<br />$latitude=$lat;// comes from select queries from mysql as a result
<br />echo $longitude, ' ', $lat;
<br />
<br />$point->setXY($longitude, $latitude);
<br />
<br />$point->draw($map, $point_layer, $image, 0, "");
<br />
<br />
<br /> $map_url=$image->saveWebImage();
<br /> $ref_url = $ref->saveWebImage();
<br /> $legend_url=$legend->saveWebImage();
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />On Tue, 26 Sep 2006 16:04:33 +0800, Delfos, Jacob wrote
<br />> Murat,
<br />>
<br />> Are you sure you want all your villages to have the same label ($villagename)?
<br />> I think you may want to define a labelitem:
<br />>
<br />> $point_layer->set("labelitem","villagename"); // "villagename" is the name of the attribute of the layer
<br />>
<br />> Also, you quoted "$koyadi", which is probably not correct. Or remove the '$'.
<br />>
<br />> Have you tested whether any part of this code works? Which part is giving you trouble? Does your PHP log say anything?
<br />>
<br />> regards,
<br />>
<br />> Jacob
<br />>
<br />
<br />
</BODY>
<br />--
<br />This message has been scanned for viruses and
<br />dangerous content by
<a href="http://www.mailscanner.info/"><b>MailScanner</b></a>, and is
<br />believed to be clean.
</HTML>