# Variable|mysql|php help

**URL:** <https://forum.kirupa.com/t/variable-mysql-php-help/212307>\
**Category:** Uncategorized\
**Created:** [January 10, 2007, 2:14am UTC](https://forum.kirupa.com/t/variable-mysql-php-help/212307 "2007-01-10T02:14:30Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Flash\_Man1](https://avatars.discourse-cdn.com/v4/letter/f/8797f3/32.png) [@Flash\_Man1](https://forum.kirupa.com/u/Flash_Man1)\
**Post date:** [January 10, 2007, 2:14am UTC](https://forum.kirupa.com/t/variable-mysql-php-help/212307/1 "2007-01-10T02:14:30Z")

</div>

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:

```auto
<?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\');';
?>

```