miraculously remembered the code, for those coming across this post seeking assistance, here is the code to do it:
CODE
<?php
$email= $_POST['email'];// in this particular instance i was posting from a form
$con = mysql_connect("localhost","youruser","yourpassword");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("yourdatabasename", $con);
mysql_query("INSERT INTO yourtablename(that you wish to insert into) (the columns you sih to insert into, separated by commas)
VALUES ('VALUE','VALUE')");// the values you wish to insert into stated columns(must be respectively)
mysql_close($con);
?>
In this particular instance i was posting from a form, here is the code for my form:
CODE
<form id="form1" name="form1" method="POST" action="post.php">
<input name="email" type="text" id="email" value="email" size="50" />
<input type="submit" name="submit" id="submit" value="Submit" />
</form>
Hope this helps any people who come across this ^^,