Form example to query a table

reisrui

Hello y'all!

I´m a real newbie in php+mysql issues as you can see by my question.

I´m know able to connect to a table in one of my databases and see all of of it´s records.
What I need is to present a kind of a form wich let´s users choose from 3 or 4 select boxes and then submit the search options.
My difficulty is to get the options choosen and then submit the query accordingly...
Can anyone give me a little piece of code example?

Thanks,

reis

bogu

Did u try the manuals?
Mysql
Php
I could copy and paste some examples from there, but I suggest u to copy paste those that u need ...

reisrui

I reviewed a few manuals and I can now query a database no problems.

One specific thing I needed and can´t seem to find it how is:

I´d like to have a <select> in a form that its <option values> where retrieved from a query.
I´m making the query I want, ir returns the values ok (I see it in mysql browser) but I can´t pass it to php code correctly, this is the example:

"....

while ($row = mysql_fetch_array($qcolectividade,MYSQL_ASSOC)) {

print "<option value=".$row{'Colectividade'}.">"."$row{'Colectividade'}"."</option>";

....
"

I always get parsing errors!!! Quite sure it´s because the "", what´s the correct way to do this, please?

Thanks,

mikawhat

Try this:
print "<option value="$row[0]">$row[0]</option>";

change 0 to the value of of what you want to display according to your sql query

reisrui

Ok, done!
It worked with print '...........

Just another question, imagine I have 5 listboxes in my home page with 5 select buttons to retrieve different kind of data; is it possible to have only one result page that opens with different content according to the button I selected in the home page?
This way it wouldn´t be necessary for me to create 5 sub-pages, would it?
How?

thks