query database against form variables

[eitan]

Hello,

my first post to the forum....
My database:

CREATE TABLE tblcd (
code INT( 6 ) NOT NULL AUTO_INCREMENT,
price VARCHAR( 8 ) ,
PRIMARY KEY ( code )

);

My form:

<input type="text" name="code1" size="20">
<input type="text" name="code2" size="20">
<input type="text" name="code3" size="20">

When submitted, I'd like to query the database code rows and return the price for each form field.

is this going anywhere?
$query = "SELECT price FROM tblcd WHERE code = ".$_SESSION['barcode'];
$result = @ ($query);
There should be a loop going all over the code fields???
thanks....

[yelvington]

I don't know why you are looking for a session variable, as you have not set one in the example you provided.

You obtain input from forms as documented here:
http://us4.php.net/manual/en/language.variables.external.php

Any time you catch yourself doing something like this:
name="code1"
name="code2"
name="code3"
... STOP and think harder about the data structures in your program.

A collection of like items should be stored in an array, so that you can loop through the array.

Using arrays to gather form data is explained in the FAQ section of the manual:

http://us4.php.net/manual/en/faq.html.php#faq.html.arrays

[eitan]

I still didn't understand how to go to the database and make the query, sorry....
still got lots to learn.....