Variable|mysql|php help

1

Hey all,

i’m trying to have users enter their details from flash then in php it will put them into a database…but instead of putting the variable data from flash through it puts my “$variables” into the database in that format.

here is my code:

<?php

$name = $_POST['name'];
$email = $_POST['email'];
$company = $_POST['company'];

mysql_pconnect("server","user","pass") or die (mysql_error());
mysql_select_db("database123") or die (mysql_error());

$query = "INSERT INTO `sub_mail_list` (`name`, `email`, `company`) VALUES ('$name', '$email', '$company')";
$result = mysql_query( $query ) or die (mysql_error());

$num = mysql_num_rows( $result );
if ($num == 1){
    print "status=Added to Mail List&checklog=1";
    } else {
    print "status=Couldn't Process Form&checklog=2";
}

//$sql = 'INSERT INTO `sub_mail_list` (`userid`, `name`, `email`, `company`) VALUES (\'1\', \'name\', \'test@test.com.au\', \'test\');';
?>