# Special Character Php Help

**URL:** <https://forum.kirupa.com/t/special-character-php-help/257968>\
**Category:** programming\
**Created:** [April 18, 2008, 9:55pm UTC](https://forum.kirupa.com/t/special-character-php-help/257968 "2008-04-18T21:55:43Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![unkempt](https://avatars.discourse-cdn.com/v4/letter/u/c2a13f/32.png) [@unkempt](https://forum.kirupa.com/u/unkempt)\
**Post date:** [April 18, 2008, 9:55pm UTC](https://forum.kirupa.com/t/special-character-php-help/257968/1 "2008-04-18T21:55:43Z")

</div>

Hi - sorry if i am new to php

I am using flash 8 and i am grabbing data from mySql using php to feed flash.  
My data has special characters in it (éö etc)

I have embedded these characters in flash but the data is not displaying correctly.  
I have been told that urlencode in my php will help

This is my php function tht calls the data - how can i url encode all the data that is returned?

Note: i use several functions which are almost identical to this in my php, which basically grab all data from each field in a table - so i need all the data which is held in an array to be urlencoded - the letters needed to be encoded are éöÉÖ

HÖPE YÖU CAN HÉLP

```php
function getAllArtists ($live) {
			// Create SQL statement
			$sql = sprintf("SELECT * FROM artists WHERE live = '%s';",
					$live);
			// Trace the query in the NetConnection debugger
			//NetDebug::trace($sql);
			// Run query on database
			$result = mysql_query($sql);
			
			$return = Array();
while($row=mysql_fetch_object($result)) {
				$row->last_updated = $this->datetime_mysql_to_mysoup($row->last_updated);
				array_push($return, $row);
			}
			return $return;			
	}

```