possible or not?

[brightstar]

ok, i know next to nothing about PHP but I'm willing to learn it if what i want to do is possible using it.

i have built a mysql database. i have the SQL code i want to extract results from it, however the SQL code needs the results from 3 selection boxes (themselves based on results from queries) in order to display the correct results.

so, can i put 3 combo boxes on a page, the first one based on results from a simple select statement, the second one based on a simple select statement and the third one based on a select statement plus the selctions made in the previous 2 selection boxes. Once all three selections have been made another sql select statement needs to run using the values from all three selection boxes and then display the results.

i can do this in ms access really easy but what i want to do now is make the data and process available on the interweb.

please tell me this is also easy in php?

http://www.agonyonline.co.uk

free, anonymous advice provided by the whole world

 

[Vragabond]

As long as you refresh the page every time you change the selection box, it is not a problem. If it is a simple page and quick access the reload will be hardly noticable.

 

[Bastien]

Depending on your data, you may not want the overhead of a db call...storing static data in an array is also a possibility

Bastien

Cat, the other other white meat

 

[brightstar]

static? you mean i could load the results for one or more of the selection boxes when the page intially loads and then query that set of results instead of reloading them at that point from the database?

http://www.agonyonline.co.uk

free, anonymous advice provided by the whole world