How to insert data from flash into Mysql database

programming
1

Hi everybody,
I am novice and new born and interested in learning flash script, php and mysql. Here is my problem. I tried to store data from flash to mysql. First i got the data from flash to a php file and from there i mailed, it worked fine; now i want instead of sending the data to an email id to store the data in mysql database. Here is my code:

<?php

$mess="Dear Sir,

	 Action    : " . $_POST['action'].",

	 Song   : " . $_POST['song'];

mail("victorelango@yahoo.com",“I want solution”,$mess,“From:bennycreatives.com”);

?> This worked fine - I got the dynamic data from the flash file -

(www.bennycreatives.com/pro/oliver/index.html)

But…,

<?php
$action= $_POST[‘action’] ;
$song = $_POST[‘song’] ;
?>

<body>
<table width=“400” border=“1” cellspacing=“0” cellpadding=“0” align=“center”>

<tr>
<td width=“100”><?php echo("$action");?></td>
<td> </td>
<td width=“250”><?php echo("$song");?></td>

</table>
</body>

CREATE TABLE IF NOT EXISTS user (
ID int(11) NOT NULL auto_increment,
name text NOT NULL,
action text NOT NULL,
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Pls guide me?