PHP Database help.

[Davidtheo]

I am trying to create a php page that has 2 drop down lists and a search box, the drop down list are filled via database.

for exmlpe My database can be something like.

Table 1
Subject ID
Subject

Table 2
Subject ID
paper ID
Paper

Table 3
Subject ID
Paper ID
Title
Des

Drop down box 1 will be filled from Table 1 (subject)
Drop down box 2 is filled from Table 2 based on what subject is selected in Drop down box 1
when a search word is entered into the search box then table 3 is searched based on the search box and what is selected in down down boxes 1 and 2
the search result is displayed in a different page as links, the link when clicked  displays the Full record that is in table 3.

Can someone please tell me how to or help me do this?

Thanks

[Davidtheo]

ok It looks this this can't be done in PHP so I am now looking at ASPX, can anyone help he with this?

[housetier]

How far did you look until you came to that conclusion?

[Davidtheo]

How far did you look until you came to that conclusion?

I have spend two days four days before posting this topic and an other two day after posting it just trying to find out this first part.

"Drop down box 1 will be filled from Table 1 (subject)
Drop down box 2 is filled from Table 2 based on what subject is selected in Drop down box 1"

Note: I am trying to do this first part on one page.

I have already found a way I can do this with ASPX using updatepanel but I have not coded it yet, as I am now trying to work out now to connect ASPX using C# to a database. This is proving to be harder in C# and ASPX.

[Kirth]

ok It looks this this can't be done in PHP so I am now looking at ASPX, can anyone help he with this?

Lies and falsehood.  You'd be using AJAX for this -- which includes PHP & JavaScript.  Honestly, if there'se something you cán do with ASP(x), then you can count on the fact that you can do it with PHP also.

[Davidtheo]

OK How would this be done in PHP???? IF I can do this in PHP I do not need to change my server account to MS.

[Carol Haynes]

Have you checked this out using google?

http://www.google.co.uk/search?q=PHP+drop+down+menus&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-GB:official&client=firefox-a

Lots of items listed that look like they do what you want - including complete drop down menu scripts for free.

The following look like good starts:

http://www.scriptdungeon.com/freephpscript/freescripts1010 - it says it now includes MySQL stuff but I didn't check that out. See http://www.steo.it/php/dropdownmenu0.6/ for the download and there is a demo version of the menu at the top of the page.

http://www.coremediadesign.co.uk/web_design_tutorials/php_tutorials/array_drop_down_menu_php.html - uses arrays to generate drop down menus - just fill the array from your MySQL data

You will have to modify any of the scripts to read your database entries and insert the read values into the script.

Don't wish to be funny but I found these scripts within 30 seconds of looking?