forms into database

[seanlyons]

I have a form that collects javascript variables. Only 2 fields, name and score.

<form action="the name of my php file when I create it" method="post" name ="command">
<input type="hidden" name="name">
<input type="hidden" name ="score">
</form>

The mysql database table that the data will be collected in has 2 columns, one called name and one called score (aswell as primary key etc)

The database is called assessment, the table called test1. it resides at the root level of my webserver

What code do i need on the "action page" for my form dta to end up in my database?

[notionlogic]

Apart from the obvious validation of form input, you would need to set up a query to insert the data into your table then connect to the database and run it...

For example, the query might look something like this (depending on the required fields in your table):

$query = "insert into test1 (name, score) values ($name, $score)";

I won't spoil the fun by doing everything for you, read up on the MySQL functions to find out about connecting to the database and running the query