db retreival using forms

[Anon]

I've just downloaded PHP and installed it. Connected to an Oracle database and have picked up rows from the database. Now I have built an HTML form into which I want to put parameters to be passed to the where clause in SQL. Can anyone please point me to an article or offer advice on how to do this as I am not getting the desired results. Thks and Rgds. Peter.

[crowezr]

I'm not exactly sure what you are looking for, but in order to use form variables in a query, you can just reference them in the statement.

$query = "SELECT * FROM database WHERE username = '$username' AND password = '$password'";

In this example, username and password are the variables passed from the form.

[peter55]

Thanks. I did manage to do that. It was more on how to put a retrieved field value back (e.g. $company) into the form where I made my intial '$username' and '$password' selection. i.e. it has gone to the database. The value is dispalyed but I want to refresh the form with the retrieved values...... Thks & rgds. Peter.