Hi, In the HTML forum I asked how I could get the results from a form which I will put on my site via e-mail, I was told:


I was then told to come to this forum and ask about the basics of PHP form processing.

Any help would be appreciated!
Martin

<form action="database.php" method="POST">
firsetname"<br>
<input type="text" name="firstname"><br>
last name:
<input type="text" name="lastname"><br>
<input type="submit" value="submit" name="submit">
</form>

<?
$name=$_POST['firstname'];
$lastname=$_POST['lastname'];
$username="your databse username";
$password="your databse password";
$hostname="localhost";
$db=mysql_connect($hostname, $username, $password) or die ("could not connect to database sorry");

$a=mysql_query("insert into tablename(field1,field2)values('$name','$lastname')");

?>

<?
$sel=mysql_query("select * from tablename");
$n1=mysql_num_rows($sel);
$i1=0;


while($i1<$n1)
{
$fname=mysql_result($sel,$i1,"field1");
$lname=mysql_result($sel,$i1, "field2");


print $fname;
print $lname;
$i1++;
}

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /mnt/storage/users/m/a/r/martinkorner/database.php on line 7
could not connect to database sorry

Alright, to process a form to a Database is a pretty simple task, however with no experience it's going to be some work. Below is a link I would suggest taking a look at to get started:
http://www.chauy.com/2005/11/php-mys...ta-into-mysql/

Basically the "jest" of storing form data into a MySQL database as follows:

Create a Database and it's required Tables
Build the Form Section in HTML
Process the Form and store info in MySQL DB
Pull information from database and Display it

If you have any questions, just follow up!