[SOLVED] Mysql result and xml

[leest]

Ok,

 

I have a piece of code i have modified to take results from a database and plot them on to a google map, now the code works well, however it only display one result and doesn't seem to loopthrough the xml code, i am quite new with this type of coding and so a litle confused any pointers would be much appreciated.

 

$sql = "SELECT * FROM joborder ";
  
  $result = mysql_query($sql) or die(mysql_error());
  
  while($row = mysql_fetch_array($result)){
      
$title = $row['title'];
$city = $row['city'];
$state = $row['state'];

}

{"locations":

{"location":[

{"id":  "

 echo "$title";

",

"city": "

 echo "$title"; 

",

"location": "

 echo "$city"; 

",

"address": "

 echo "$state";

",

"date": "May 2nd, 2007"

}

]

}}

 

 

[fenway]

It's hard to see w/o proper indentation... btw, there's a UDF that does this for you.

[leest]

Ok, well i guess that could be a whole lot easier, any idea where i would find it???

[GingerRobot]

You close your while loop after setting the variables $title,$city and $state, but before doing anything with them - hence why it doesn't loop in the way you would want.

 

I expect fenway was referring to: http://code.google.com/apis/maps/

[leest]

Cheers, that works, i guess i will go have a look for the udf,

 

cheers guys.

[fenway]

Cheers, that works, i guess i will go have a look for the udf,

 

cheers guys.

 

mysqludf.com