Flash :: [F8] Losing Data On The Way To Database

Entering Data Without LOSING IT?
Hey all,
I hope this is a straightforward question. Although the answer may not!! augh...

Well I would like to use a mixture of Flash MX/PHP/mySQL. I currently have a form that people fill out in PHP that gets input into mySQL. I want to convert the HTML and use FLash for that and use the PHP scripts in the background.
The problem is this, (which i had with the HTML previously).
As you fill out the form, some of the drop down's may not have the correct info in it (ex: location, job title)
So I would like to be able to click on a button to the right of it and open a little window and fill in the missing data. Then that inputs it into mySQL. You close that window and go back to the drop down and Voila! Its in there now and you can proceed.
What I am trying to do is keep the user in the same page without leaving it.
Is this possible in Flash?
I was thinking about loading a separate movie(.swf) with
_visible = false, and then just having the button activate that movie when you need to fill it in...
But what about the drop down? How do I get "just" the drop down to retreive the new data with refreshing the whole page and losing the data that was already input into the text fields above?

Any info would greatly be appreciated thanks!!!

Indy

Variables Losing Their Data :(
Hi guys! Seems like I'm forever posting here at the moment!

I'm having a problem where AS seems to be losing data that I've stored in variables when it loops back to the start of a movie clip. I'm not sure why, because I'm not re-declaring the variables everytime at the start, they get defined in a button function.

Basically, what I'm trying to do is set a flag variable, and another called 'continueOnFrame'.

When the movie loops back around, it checks to see if the flag has been set to 1. If it has, then it goes to the frame number contained in 'continueOnFrame'.

Or at least, that's what it SHOULD do. I ran a trace on the variables, and the button function sets them fine, but when the movie lops it sets them to 'undefined' again

Here is the code for frame 1:

Code:
stop();

trace("Flag = "+flag+" / continueOnFrame = "+continueOnFrame);

if (flag == 1) {
gotoAndPlay(continueOnFrame);
};

news_btn.onRelease = function() {
trace("pressed");
gotoAndPlay(2);
};

about_btn.onRelease = function() {
trace("pressed");
gotoAndPlay(61);
};
And here is the code which actually defines the variables (frame 35 of the movie):

Code:
stop();
news_btn.onRelease = function() {
trace("news_btn pressed");
var flag = 0;
var continueOnFrame = 0;
trace("Flag set to: "+flag+" / continueOnFrame set to: "+continueOnFrame);
gotoAndPlay(36);
};
about_btn.onRelease = function() {
trace("about_btn pressed");
var flag = 1;
var continueOnFrame = 61;
trace("Flag set to: "+flag+" / continueOnFrame set to: "+continueOnFrame);
gotoAndPlay(36);
};
contact_btn.onRelease = function() {
var flag = 1;
var continueOnFrame = gotoAndPlay(36);
trace("success!");
};
I'll attach the .fla file as well if it helps. I'm using MX2004 (although, I've saved the file in MX format).

Losing XML Data When Moving Between Frames
Now missing patches of hair on this!

Here is the original thread Loading data from xml file...strange conflict?

Can anyone offer any additional suggestions?

How To Prevent Losing Data When Browser Refreshes
When I refersh my browser the movie moves back to the first scene, 1st frame and destroys all variables and data. Can this be avoided? If so can someone help me out please.

Thanks.

Imprting Swfs Into Fla But Losing Xml Data In Dropdowns
I am importing four swfs into a master fla. Swfs are loading beautifully but the dropdown functionality (xml data) isn't showing up in the main SWF. The four child swfs all have differently titled xmls. not other errors. just the blank dropdowns.

master fla buttons look like this

europe_btn.onPress = function () {
_root.createEmptyMovieClip("container", 1);
loadMovie("Europe.swf", "container");
container._x = 0 ;
container._y = 0 ;
}

do i need to load xml in the master as well?

Getting Data From A Php Script That Gets Data From A Database
Hello,

I am trying to get information for a database, and the php script works fine. The php script outputs the data in flash format, and with traces the flash appears to be working fine.

The only problem is when I try to call any value out of the array, it comes back undefined, even though while going through the loop the traces said the values were in fact defined.

Here is my shortened script:

ActionScript Code:
var path = "http://localhost/rpg/web-content/";
var terrainurl = path + "getterrain.php";
terrain.load(terrainurl);

terrain.onLoad = function() {
for (var i:Number = 0; i < this.ttotal; i++) {
terid = this["tid" + i];
terrainpicture[terid] = this["terrainpicture" + i];
}
}
var terrainpicture:Array = new Array();

loadMovie(path + terrainpicture[1], _root.t1);

stop();

The last load movie returns an undefined value. I have other queries going on in the script but I commented them out. Every value comes back undefined.

Any ideas?

Thanks,
Cameron

Adding Data In Database Using ASP
Hello,
I want to add data in Access database from flash. There is one textarea in flash. So i can enter paragraph over there. Now i have made one button for submitting this data. I have submitted data in database using ASP. But Now when user will make login at my site, I want to show his details in profile which is already in flash. I am not able to view whole paragraph in Flash. How can i show new line from database ?

I mean to say my problem is I want to show whole paragraph as it is in flash.

Here i am getting problem is it's not viewing new line characters.

Regards,
Paresh

Geting Data From DataBase
Hello all,
I want to learn how to insert text from database into my flash movie and to move the text on the screen.
I know how to work with access database, all I need to learn is the actionscripts at the flash movie.
Is it possible ?
I realy appreciate is you could help me with that.
Thanks a milion...

[Edited by jakob on 07-02-2002 at 04:46 AM]

Can We Retrive Data From Database Through ASP.NET?
Hi,

Is there any way to retrive data from database using ASP.NET file.

eg(data.aspx)

Plz, Help me.........

But, I know by ASP.

Thanx

Sending Data To My CF Database...
I want to use flash as an interface and send data entered in text boxes to my access database via flash. How?

Scrolling Data From Database
Hello
Im new in flash and i need help:
can somebody show me or if somebody has an example of scroll
i need to display football results from database in flash as scroll without stop.
i have the page now with javascript and i want to move to flash ypi can see what i need in this link : http://www.al-score.de/test/
i hope i will find helper like always, because i trust flsh-kit
thank you

[F8] Form Data To Database Via ASP.
Hey. This is pretty urgent, i hope someone can help.

I have a flash form with the following A/S on the Submit button:

Quote:

on (release) {
if (!_parent.email.length || this._parent.email.indexOf("@") == -1 || this._parent.email.indexOf(".") == -1) {
_parent.Status = "Please enter a valid E-mail address";
} else if (!_parent.fname.length) {
_parent.Status = "Please enter your first name";
} else if (!_parent.sname.length) {
_parent.Status = "Please enter your second name";
} else if (!_parent.address1.length) {
_parent.Status = "Please complete your postal address";
} else if (!_parent.address2.length) {
_parent.Status = "Please complete your postal address";
} else if (!_parent.address3.length) {
_parent.Status = "Please complete your postal address";
} else if (!_parent.postcode.length) {
this._parent.Status = "Please enter your postcode";
}else {
loadVariablesNum ("../form/processForm.asp", "0", "Post");
_parent.Status = "Thank you. Your request was sent.";
}
}

In the ASP file, i have this:

Quote:

<%@language = "VBScript" %>
<%

strFname = Request.Form("fname")
strSname = Request.Form("sname")
strEmail = Request.Form("email")
strAddress1 = Request.Form("address1")
strAddress2 = Request.Form("address2")
strAddress3 = Request.Form("address3")
strAddress4 = Request.Form("address4")
strPostcode = Request.Form("postcode")

MyPath=Server.MapPath("example.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"DBQ=" & MyPath

SQL = "INSERT INTO contacts (FirstName, Surname, Email, Address1, Address2, Address3, Address4, Postcode) VALUES ('"&strFname&"','"&strSname&"','"&strEmail&"','"&s trAddress1&"','"&strAddress2&"','"&strAddress3&"', '"&strAddress4&"','"&strPostcode&"')"
conn.Execute(SQL)
%>

According to my client none of the form variables are being passed to the ASP file at all..

Does anything stand out as being wrong in any of this code?

Thanks so much for any help.

Using Actionscript Data For A Database
How do i get actionscript/flash data into a server side scripting language like PHP? What would a command look like that would allow the script written through the html pull data from the application running in flash? Can i use Ruby on Rails to do the job of PHP since they are similar? An example of PHP code that is retrieving and linking data into a database would be much appreciated.

Thanks

Retrieve Data From Database
ok so I have a login system working but I need flash to load variables from the database thru php. For exaple I want flash to load the characters level from the "level" field in the database. If anyone could type up some actionscript and a php page it would be great.

Thanks in advance!

Using Data From A MySQL Database
Here is the piece of my code:
if (this["projectName"+three] != "") {
_global.projectFile3 = this["projectFile"+three];
heading3_txt.htmlText = this["projectName"+three];
content3_txt.htmlText = this["description"+three];
if (this["thumbnail"+three] != "") {
picHolder3_mc.loadMovie("images/"+this["thumbnail"+three]);
}
} else if (this["projectName"+three] == "") {
content3_txt.htmlText = "";
heading3_txt.htmlText = "";
}

It is for a portfolio thingie i am working on. My script pulls the data from the db three at a time and displays it. the problem is on the last "else if" statment. If there is only 2 items left to display, the third listing is suppose to put in blanks, but instead it places "undefined" in both instances. Any ideas? thanks...

Best Database / Way To Store Data
Pretty much what the title states, for a project i need to make some game (won't need to try very hard, the others are using delphi) but it has to be able to store and recall data... ie.. names, scores, details etc...

Others in the class are using MS access, is that the best prog to use? Or whats mySQL? I've looked at the different ways of doing this, but just wanted some input from those of you with this sorta experience under your belt and can help out.

Any suggestions are welcome

thanks

Database Data To XML Through PHP (renamed)
i need the same data in dynamic from database in any form xml,php etc...in above attaches swf zip file i make it by hardcoding, i in very much confusion and in pressure how to make it in dynamic,plz anybody help in it.........

plz find the attached file...below

thanks in advance........reply soon...any idea welcomed....

How To Receive Data From A Database?
1. I have a mysql database with 4 fields: ID, Type, Price and Available.
2. In a movie named "display_mc" have my flash file with 4 dynamic textfields named ID_txt, Type_txt, Price_txt and Available_txt.
3. In the main stage I have a series of buttons. When I click on each button I want to pull data from a database and send it to the display text fields in my flash movie.
4. My server supports php.

Can anyone help me here? I need this to work for me at least once!

I'd gladly pay you on Thursday
for a hamburger today!

Best Database / Way To Store Data
Pretty much what the title states, for a project i need to make some game (won't need to try very hard, the others are using delphi) but it has to be able to store and recall data... ie.. names, scores, details etc...

Others in the class are using MS access, is that the best prog to use? Or whats mySQL? I havn't really looked into this at all, and any suggestions would help heaps!

thanks

Insert Data To Database
var variable:URLVariables = new URLVariables();
var myRequest:URLRequest = new URLRequest();
myRequest.data = variable;
myRequest.url = "http://localhost/insert.php";
var loader:URLLoader = new URLLoader();
loader.dataFormat = URLLoaderDataFormat.VARIABLES;
//loader.addEventListener(Event.COMPLETE,getServerResponds);

btnSend.addEventListener(MouseEvent.CLICK,sendData);
function sendData(evt:MouseEvent){
variable.fName = txtName.text;
variable.fMail = txtMail.text;
loader.load(myRequest);

}
please help me coz i fedup in this problem this coming every timeeeeee

error....
Error: Error #2101: The String passed to URLVariables.decode() must be a URL-encoded query string containing name/value pairs.
at Error$/throwError()
at flash.net::URLVariables/decode()
at flash.net::URLVariables$iinit()
at flash.net::URLLoader/flash.net:URLLoader::onComplete()

Saving Data To Database And Retrieving It
does anyone know of a tutorial that explains how to save variables from flash to any database and the retrieving it using ASP or PHP scrips? i really need a very detailed tutorial since i dont know nothining of php or asp or flash action scrip that deals with sending and receiving variables.. maybe a tutorial on how to use the new flash communication thing?

Store Vector Data In Database
Ok, here's a crazy idea that probably isn't possible. :-) Is there some way to take a vector graphic and store the information that makes up that graphic, in a database?

Any ideas?

Thanks,
Andrew

Passing Dynamic Data To Database
I'm trying to send info to a database, but the amount of variables sent varies. I have spent most of my time trying to use the loadVars object:

myLoadVars.variable1 = temp1;
myLoadVars.variable2 = temp2;
myLoadVars.variable3 = temp3;
and so on...

where I need to create a loop that can dynamically create the myLoadVars.variable(i) where i increments.

Is there a way to dynamically create objects/variables in this situation or is that a big no-no? Or, is there a better way to send dynamic amounts of info, like XML?

Thx in advance...

Retrieving And Saving Data Into Database
Goodday to all Flash users,

I am currently using Flash MX to create a simple e-Book. One of the function is Bookmark. This function will bring up a box that contains a listbox, one "Add" button and one "Delete" button.

For example when a user is in Chapter 5, then click on "Bookmark" in the menu, that box pops up. When he/she clicks on the "Add" button, "Chapter 5" would be displayed in the listbox.

I need to save this info into a database so that when user opens the e-Book, the data should be retrieved from the database and store into the Flash e-Book.

Can somebody show me the code to do this please? Or maybe a link to a tutorial on this perhaps? I had went thru the Macromedia Flash Support Center on Creating Forms with UI components tutorial, but it doesn't teach me how to save/retrieve data into/from database.

Would appreciate it very much if anyone could help me on this, thanks a bunch!

Pulling Data From A Notes Database (.nsf)
I need to link a flash application to a Lotus Notes database (.nsf), do any one had worked on this before? Please help!!!

Inserting Data From Database To A List Box
I am working in a flash/php project. It is a kind of kitchen designing project. Users can login and design their kitchen using some tools like windows, doors, appliances etc. and then they can save the project and after that they can open their projects too.

Now what I want is when users click on the open button they should get the list of the projects that they have designed previously. So I want to use a list box where their previous projects can be shown. But I don't know how to do this.

I know how to show the data in a text box but that won't do.

Please help me with this.

Thanks in advance

Inserting Data From Database To A Combo Box
I am working in a flash/php project. It is a kind of kitchen designing project. Users can login and design their kitchen using some tools like windows, doors, appliances etc. and then they can save the project and after that they can open their projects too.

Now what I want is when users click on the open button they should get the list of the projects that they have designed previously. So I want to use a combo box where their previous projects can be shown. But I don't know how to do this.

I know how to show the data in a text box but that won't do.

Please help me with this.

Thanks in advance

Insert Data Into Mysql Database
I have a php/mysql database which is working fine, but I would like to have flash design for my entry and query pages.
I opened a new Flash MX 2004 document with just one frame (no need for validation at this moment, confirmation will be managed by the php script file).
I tried 2 things:
1) drag a button component and a textfield component onto the stage
2) use the text tool and draw a rectangle for 'input text' and put a button from the common libraries menue onto the stage. I'm not sure if both versions are ok, I think so and don't see the difference.

The button has an instance name 'submit' and the input field has the instance name 'name' and in the var field for the input text, I tried 'thisFieldName' or '$thisFieldName' (without 's)

as action for the button I put this code:

on (release)
{
getURL("insertNewFromFlash.php", "_self", "POST");
}

The corresponding table has just two fields, id (autoincrement, so I don't use it in the flash entry form and my insertNewFromFlash.php file is:

<?php
// include_once("../team/ventas/connection.php");
//
// $thisName = addslashes($_REQUEST['thisFieldName']);
//
//$sqlQuery = "INSERT INTO fromflash ( name ) VALUES ( '$thisName' )";
//$result = MYSQL_QUERY($sqlQuery);
//
//?>
A new record has been inserted in the database. Here is the information that has been inserted :- 
here comes some html code and the following php line wich just works as a confirmation about the inserted data, however it always remains empty
<table>

<tr height="30">
<td align="right">Name : </td>
<td><? // echo $thisName; ?></td>
</tr>
</table>

<?php
// include_once("footer.php");
?>
//Tere are no comments in my file, seems to be necessary in order to get the code displayed here in this forum.

The problem is that when I press the submit button, a new entry is registered in my table, the dbconnection works fine but the entry only registers the autoincremental id while the variable $thisname isn't inserted. There are no error messages, the name just isn't inserted although the connection is established and the insert command is carried out, however, looks like the variable isn't parsed from the flash to the php file.

Thank you in advance

Sending Survey Data To A Database
First, apologies for asking this common question (i see lots of other people have tried to do this) but i can't seem to find any useful help in the rest of the forum.

Objectives:

Create an online questionnaire in Flash MX
The form will have some text input boxes (name, email, contact details etc), some tickboxes, and for the majority... radio buttons for preference (love it, impartial, hate it... for example)
When the submit button is pressed, data is added to a database
Admin can access the db at any time and view the data (preferably exportable to MS excel)

Questions:

I know how to get the components onto the stage, edit the formatting etc. Firstly, how do i send to a script

Secondly how do i make that script add the variables to a db

And also... what type of db and script is best to use? (i have little to no programming knowledge in asp, php, sql)

So, the challenge is set! Am i beyond help?!?!

Many thanks in advance
rob

Data Type Coverstion From AS1.0 To Database
I have a mulitdimensional array (three levels) that needs to be saved into a mysql database through a php page. I was wondering if anyone knew of a way to convert an array easily. I was thinking of creating a function that would convert the array into one big string and separate each different level with an exclamation mark, but that isn't working so well with a three level array. Is there a way to store the array as an array in the mysql database?

How Get Data From Database Info Flash?
Using ActionScript, I am able to load data from Text files and XML files into text fields in my Flash movie, but how can I pull directly from a database?

Thanks for any help,
Ron Cook
Boulder, CO

How Get Data From Database Info Flash?
Using ActionScript, I am able to load data from text and XML files into text fields within my Flash video. But, how can I pull data directly from a database? Is that possible?

Thanks for any help.

Ron Cook
Boulder, CO

Textbox That Shows Data From Database
In my file I have a ticker text which reads data from a text box. I want this text box to be filled with data from the database. How can I do that?

So what should happen is that the text box is filled with data from the database and the text box data becomes the ticker text.

Or is there a better way to make a ticker text from data that comes from a database. I would really appreciate some code because I am not very good at connecting to the database.

Thanks

Aneesha

I Am Trying To Load Data From A Database To Flash
Hello

I am trying to load data from a database to flash.

This is the actionscript that I use :

Code:

myData = new LoadVars()
myData.ref = this
myData.load("con_flash3.php")
myData.onLoad = function(success){
if(success){
for(var i=0; i<this.total; i++){
this.ref.word.htmlText += " "+this["word"+i]

}
} else trace("Error loading data")

}

con_lash3.php

Code:

<?php

require("config.php");

$connection = mysql_connect($db_host, $db_user, $db_password) or die("error connecting");
mysql_select_db($db_name, $connection);

$query = "SELECT * from news ORDER BY month desc";

$result = mysql_query($query, $connection);

$words = '';
$count = 0;

while ($row = mysql_fetch_assoc($result)) {

$words .= '&word'.$count.'='.urlencode($row['comments']);
$count++;

}

echo 'total='.$count.$words;

?>

I had debug the php script and it woks !

I haven’t be able to pass the data to flash

I don’t know what I am doing wrong, If you have any idea please help !

Thank you !

Loading Database Data Into A Dropdown Box
hi everyone

now im not very experienced with as2 or PHP and ive been struggling to load some data from my mySQL database, into a drop down box. Im using amfphp remoting as well. Now i know this may be asking a lot of you guys but can someone show/give me some code which will help me do this? ive been trying for ages but i think my code is totally wrong, hence why i havent put it up here.
Help with the PHP code and actionscript code would be extremely appreciated. thanks!

Data Validation In Flash With Xml/database.
Hi,
I have 2 create a login page in Flash8. it will have 2 textinput boxes for-- username and password. once the user enters these 2 info, the data will be validated. i have been given the choice of using xml or database.
Pls guide me as to how to do this job.

I Am Trying To Load Data From A Database To Flash
Hello

I am trying to load data from a database to flash.

This is the actionscript that I use :

Code:

myData = new LoadVars()
myData.ref = this
myData.load("con_flash3.php")
myData.onLoad = function(succes){
if(succes){
for(var i=0; i<this.total; i++){
this.ref["word"].text = " "+this["word"+i]

}
} else trace("Error loading data")

}

con_lash3.php

Code:

<?php

require("config.php");

$connection = mysql_connect($db_host, $db_user, $db_password) or die("error connecting");
mysql_select_db($db_name, $connection);

$query = "SELECT * from news ORDER BY month desc";

$result = mysql_query($query, $connection);

$words = '';
$count = 0;

while ($row = mysql_fetch_assoc($result)) {

$words .= '&word'.$count.'='.urlencode($row['comments']);
$count++;

}

echo 'total='.$count.$words;

?>
I had debug the php script and it woks !

I haven’t be able to pass the data to flash

I don’t know what I am doing wrong, If you have any idea please help !

Thank you !

[F8] Retrieving Data From Database Into Flash
I only just figured out how to implement a login system into flash using PHP to connect to the database. But now I need to know how to call data from the database into flash, so that once a user logs in, they have access to their exclusive account and such.

For example, I have a field in the database called "name" and I need firstly a button so that when I click on it, it sends a query to the MySQL database, and inputs a new name into the "name" field for their specfic account.

If anyone has a tutorial that might be helpful, or knows how to do something along these lines, I would much appreciate any information that is shared.

If you know how to do something similar, please post instructions because I can have a fiddle with the code to try and change it to my needs.

Thanks in advance!

How Do You Load In Your Database Data? All At Once Or By Section?
I am working out the best methods of flash database interaction. Do you load in all the database information first, then run through the site.
Or,
Do you load in the relevant information from the database when clicking into each section?

Need To Load Database Data Into Flash Through Php
I'm redesigning a site i did for a band and i would like to do it all in flash but i don't know how to load php into flash. I need to load in their news and tour dates into a scrolling textbox. Here's what I had when it was html:

PHP Code:

<?require('DB.php');require('Smarty.class.php');$dsn = array( 'phptype' => 'mysql', 'hostspec' => 'localhost', 'database' => 'name', 'username' => 'theusername', 'password' => 'thepassword');// initialize Smarty object$smarty = new Smarty;$smarty->template_dir = '.';$smarty->compile_dir = 'templates_c';// connect to database$dbh = DB::connect($dsn);// snarf data$smarty->assign('array_tour', $dbh->getAll('SELECT * FROM tour ORDER BY date DESC', DB_FETCHMODE_ASSOC));// display page (for now)$smarty->display('tour.html');

HTML Code:
<ul>
{section name=i loop=$array_news}
<li>{$array_news[i].date} 
{$array_news[i].headline} 
{$array_news[i].details}
</li>
{/section}
</ul>

Removing Commas From Database Data
Does anyone have a technique for removing commas from that data that comes
back from a database call. I have tried the split command and it isn't
working. It is strange because if I put the data in a ComboBox, the commas
aren't there. However, if I put the data in a TextBox, every data point is
separated by a comma. When I print the data (send to printer), the commas
are in there. I would like to remove them and possible even put a hard
return in there instead.

So ultimately, I would like to replace the comma with a hard return.

Thank you.

Dave

Loadin Dynamic Data From A Database
Hi

I was looking at the tutorial which loads dynamic data from text files..... heres the link http://www.kirupa.com/developer/mx/c...namic_text.zip

what i would like to no is that can data be loaded from a ms access database via asp???

could someone please help.

many thanks

Passing Data From Database To Flash
Hey all, im new here, So first Id just like to say HI!!!.
I am working on creating a basic message board for my website and I am having difficulty getting things to pass from Flash to Database to Flash. I just checked out the tutorial on this site that shows how to go from Flash to Database. Which is awesome by the way. I was wondering if anyone could help me on how to get the database data back into flash and post in a message board style.
In another related note. I am also wondering how to do this.
Through a form set
-grab an image file off the users computer
-store it in a database or in a folder or something.
-and then pass it back into flash to be posted in a determined place. Much like a
gallery.

Any help would be awesome. Even if its just references to sites that can help with databases, ASP, Flash, Actionscript. Thanks again.

-Brad

Preloading Dynamic Data From A Database
Hi,

I am trying to have a preloader come up and go through a loading process when I am waiting for data to return from the database.

Does anyone know how to do this or knows of any tutorials that I can look at?

thanks

Inserting Data Into A Database Using Flash
I have a little application with five text fields and a submit button that i want to put the inputted data from into a database. i have my database done and everything, and here is the code for the PHP file i'm using:

PHP Code:

<?php
$server = "localhost";
$username = "reintro_matt";
$password = "*******";
$database = "reintro_testdb";
$table = "ecard";

mysql_pconnect($server, $username, $password);
mysql_select_db($database);

$success = 1;

$ins_str = "INSERT INTO " . $table . " VALUES ('".$HTTP_POST_VARS['fromName']."', '".$HTTP_POST_VARS['fromEmail']."', '".$HTTP_POST_VARS['toName']."', '".$HTTP_POST_VARS['toEmail']."', '".$HTTP_POST_VARS['message']."')";

//echo $ins_str;

if (!mysql_query ($ins_str)) {
 $success = 0;
 $msg = 'Problem saving records to the database';
} else {
 $msg = 'Record was saved successfully. Refreshing display...';
}

echo '&success='.$success.'&msg='.$msg.'&';

?>

i'm not very good with PHP but after doing some research and reading some tutorials i think that is good to go. my text fields in flash have the variables that i'm using in the POST_VARS commands in PHP and similar instance names. how would i go about writing the actionscript to collect this data and insert it into the database in flash (or make corrections to the PHP i already have if it isn't ready).

thanks in advance.