PHP & MySQL search

Need help about how to search sql database

[borisp71]

Hi,
I'm new in this, so be patient.
I have SQL base with several categories.
I need some php lines to search on example
user choose from drop down menu one category
and he get lot of data from sql base of that category
and in that category choose another sub category ang
get less results .
Is that possible to make?
Thank you in advance

[henry0]

Welcome to WebmasterWorld Boris!

First if as mentioned you are somehow new to PHP MySQL you could have a look Here [webmasterworld.com]

Regarding your project you might want consider AJAX to perform such a chain of events.

Or you could do it the procedural way:
One) Go with the first round of select
for ex: built a drop down box with an option to select from:
widgets, apples, banana
for example widgets are selected by the user, pass the selected info to another page:
Two) Built another drop down box of only widgets sub categories.
For example widgets with a blue trim.
.. and so going on

let us know where you stand and if you have written some code
post your samples
and we will help you.

[eelixduppy]

Indeed, welcome to WebmasterWorld! :)

If you are up to an AJAX solution, I have written a quick example at this thread: [webmasterworld.com...]

It may not be exactly what you need but with a little fine tuning, it sounds like it fits your needs pretty nice.

Good luck!