Switch tables on the fly

[Tmac]

k here is my qustion..., I'm building a form for users to search a database, i have radio buttons at the top for the user to click so they can choose the section of the site, now for each section there are different categories, how could i get the different category tables for each section to change based on what they click?

Thanks for any help

ps using mysql as database

[Namadoor]

This post was an error.

[Namadoor]

Well, you could do something like this:

Say your radio buttons were like
<input type=radio name=catagory value=A> Catagory A <br>
<input type=radio name=catagory value=B> Catagory B <br>
<input type=radio name=catagory value=C> Catagory C <br>

Then, you would have your other search fields. Then you could have a PHP script like so:

dbconnect(); //You should make some kind of function for connecting to the database, and then use the correct one

if ($catagory == A)           {
     //Search the table for catagory A
}
elseif ($catagory == B)          {
    //Search the table for catagory B
}
else       {
   //This means the catagory is C, so seach the table for catagory C
}

Hope this helps!

[[deleted]]

IF you can write javascript
choose table in client computer!

that will be better

[Tmac]

Thanks for the ideas, i'll give them a try!