Hey!
im using a form i made in flash to send variables to a MySql Database.
code for form:
[AS]
//trace(email1.text+", “+question1.text+”, "+check1.selected);
status1.text
send1.onPress = function () {
status1.text = “sending…”;
var ld:LoadVars = new LoadVars ();
var reciever:LoadVars = new LoadVars();
ld.email1 = email1.text;
ld.question1 = question1.text;
ld.public1 = check1.selected;
trace (ld);
ld.sendAndLoad (‘http://www.valj.nu/live/script/ny.php’, reciever, ‘POST’);
reciever.onLoad = function () {
trace("Recieved info -> "+reciever);
status1.text = "Sent!";
};
};
[/AS]
Its sends it perfectly well to the databse thru this page:
<?
include("dbconnect.php");
$email = $_POST['email1'];
$question = $_POST['question1'];
$public = $_POST['public1'];
$question = stripslashes($question);
$email = stripslashes($email);
$sql = mysql_query("INSERT INTO nya (email , fråga , datum , publiceras)
VALUES('$email', '$question', now(),'$public')")
or die (mysql_error());
?>
however in the database if i have used the swedish letters ÄÅÖ äåö
it looks like this:
“hejsan
jag Heter VoS
Jag Är från Sverige
Öland…”
this is just a text i typed in one of the fields, its supposed to look like this:
“hejsan
jag heter VoS
Jag Är från Sverige
Å öland”
anyone abel to tell my why, and more importantly how i fix it?
thanks
//VoS