form processing

[laserw]

Hi,

I have created a form.php file and another file which I will call answer.php. What I am confused about is that I have one selection box in the form file which when submitted returns a year and is then supposed to be used by the answer file to display the results. It doesn't do it.

I am using the following snips as my example.
FORM.PHP
<FORM ACTION="mysql_t5.php" METHOD="POST">
<B>Year Graduated:</B>
<SELECT NAME="$year" size="4">""">click here

ANSWER.PHP
$fld_name='fn04'; // fieldname, eg fn04
$query='$year'; // 1 char or better
$sortparm='fn03, fn01';
// sort by lastname, firstname

Should the form and answer be in one file?
When I test the submit, I see the following in the address bar of my browser:
http://mydomain.net/t05.php?%24gyear=1973

Any help appreciated,
Peter

[zhabala]

The name of the select tag should be only year not $year like this:
<SELECT NAME="year" SIZE="4">
<OPTION ...
</SELECT>

and in answer it should look like
$query = $year; without the '

Zdenek

[laserw]

Hi,

I was also wondering, if the forms file can be separated from the query file or are they usually combined?

I am learning php and mysql on my own and since I have a strong background in databases through dbase, clipper, etc. I was wondering what might be the best way to procede regarding separate files.

Thank you for your help.

Peter