SEARCHING MYSQL

jacklindsay1990 · Joined: 09 Jan 2009 Posts: 1

hello people. im having a bit of a dilemma Sad

im working on a little project for work which is a has a form which puts data into a table in mysql...this work fine.

i now want another form on a different page which contains a dropdown box which is populated either staticaly of dynamically (doesn't matter which on yet). it will need to contain rep number, serial, tag, description and rep name.

the script will need to be able to do this:
depending on which option is chosen from the dropdown. all other text fields are disabled execept for the one which is chosen in dropdown.

so if rep number is chosen. the fields, serial, tag description and repname are disabled.
when the user types a rep number in the field, and presses a button, i want the script to query the database and find that record and display all the results in the equivilant texts fields, even though there disabled. i then want a button called edit, which when selected re-enabled all the disabled text fields, so i can edit the data and then have another button called re-submit which updates the information in the table.

the only thing remote like what im asking for is the simple print command in php which prints all the results in the table. i need to choose what i want to see.

any idea's on how i can do this?

Atif · Joined: 09 Jul 2009 Posts: 1

Articles tutorials and free codes on PHP, SQL, Web design, HTML, ASP, JavaScript, PhotoShop for webmasters and programmers.

http://www.frenchsuppliers.com, http://www.diytoolsdirectory.com, http://www.usawholesalers.com, http://www.francewholesalers.com.

robertflorish · Joined: 12 Jan 2010 Posts: 1

Scriptsdesk - web script directory providing all kinds of scripts such as php scripts,asp scripts,asp.net scripts,javascripts,cgi scripts and many more scripts. Scriptsdesk has the collections of best scripts and resources you need.You can submit your scripts here and you can download free scripts & commercial scripts.
check for the script you want in this scripts directory.
http://www.scriptsdesk.com