# &ntilde or &Ntilde

**URL:** https://forum.kirupa.com/t/ntilde-or-ntilde/154275
**Category:** programming
**Created:** [July 8, 2005, 7:28am UTC](https://forum.kirupa.com/t/ntilde-or-ntilde/154275 "2005-07-08T07:28:23Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![onmosh](https://avatars.discourse-cdn.com/v4/letter/o/958977/32.png) [@onmosh](https://forum.kirupa.com/u/onmosh)
#### Post date: [July 8, 2005, 7:28am UTC](https://forum.kirupa.com/t/ntilde-or-ntilde/154275/1 "2005-07-08T07:28:23Z")

</div>

I have a one problem about sending/posting a data from database to the flash MX.

Take a look this problem. i’m in the localhost only.  
This is the first record without “ñ” in the database:

[http://www.kirupa.com/forum/attachment.php?attachmentid=26218&stc=1](http://www.kirupa.com/forum/attachment.php?attachmentid=26218&stc=1)  
 ![](http://www.geocities.com/moshunderground/fourth.jpg) ![](http://www.geocities.com/moshunderground/fourth.jpg)  
This is the output of the first record without “ñ” from the database:

![](http://www.geocities.com/moshunderground/first.jpg)[http://www.kirupa.com/forum/attachment.php?attachmentid=26215&stc=1](http://www.kirupa.com/forum/attachment.php?attachmentid=26215&stc=1)

This is the second record with “ñ” in the database:

![](http://www.geocities.com/moshunderground/third.jpg)[http://www.kirupa.com/forum/attachment.php?attachmentid=26217&stc=1](http://www.kirupa.com/forum/attachment.php?attachmentid=26217&stc=1)

This is the ouput of the second record with “ñ” from the database:

![](http://www.geocities.com/moshunderground/second.jpg)[http://www.kirupa.com/forum/attachment.php?attachmentid=26216&stc=1](http://www.kirupa.com/forum/attachment.php?attachmentid=26216&stc=1)

This is the property of my dynamic text in flash Mx:

![](http://www.geocities.com/moshunderground/fifth.jpg)[http://www.kirupa.com/forum/attachment.php?attachmentid=26219&stc=1](http://www.kirupa.com/forum/attachment.php?attachmentid=26219&stc=1)

This is the code how i concatenate the first, Middle, last Name in a single dynamic text in flash MX.[indent]cname = c2 + " " + c3 + ". " + c1;

[/indent]This is the code how i load/retrieve the data’s from database to the flash MX:[indent][color=Blue]loadVariables[/color]([color=Blue]“sLoad.php?scode=”[/color]+scode, m01);  
[color=Magenta]//m01 is a target MovieClip because i’m using loadMovie.  
//scode is a input entry.[/color]

[/indent]This is sample code of my query in php:[indent]\<?php  
[color=Blue]mysql\_connect/color;  
[color=Blue]@mysql\_select\_db/color;

$result = [color=Blue]mysql\_query[/color](“SELECT \* FROM $table1 WHERE STUDENT\_CODE = ‘$scode’”);

$c1 = [color=Blue]mysql\_result/color;  
$c2 = [color=Blue]mysql\_result/color;  
$c3 = [color=Blue]mysql\_result/color;  
[color=Magenta]//etc…[/color]

if($call == “”){[indent]$call = “Hello $scode”;  
$c1 = “c1=$c1”;  
$c2 = “c2=$c2”;  
$c3 = “c3=$c3”;  
[color=Magenta]//etc…[/color]  
[/indent]}  
echo “call=$call&$c1&$c2&$c3”;  
[color=Magenta]//etc…  
//The etc is the other fields and other objects…[/color]  
?\>

[/indent]Anyone can fix this problemand how? any tutorials site? sample codes?