freddyk Posted January 26, 2020 Share Posted January 26, 2020 (edited) Hello, how would I change the ..."SELECT DISTINCT OWC FROM cmsExport ORDER BY OWC ASC;" ......OWC in mysql query to a value coming from a html select, selection value on my webpage? Can that be done? Sorry, been using HTML/PHP for my SELECT. Thanks heaps! Edited January 26, 2020 by freddyk Link to comment Share on other sites More sharing options...
Funce Posted January 26, 2020 Share Posted January 26, 2020 It is possible for it to be done, but not safely. What sort of data are you working with here? Can you provide a light example? This sort of thing usually indicates more of a design problem, than an implementation issue. Link to comment Share on other sites More sharing options...
freddyk Posted January 26, 2020 Author Share Posted January 26, 2020 Hello and thank you. I have one table (Tasks Table) which contains tasks information, skills and durations. The idea is to schedule these task considering skill availability and current loading per time unit. Selecting a row of this Task Table brings up the Availability/Loading information for that skill set clicked on. This is purely summing duration by selected skill and date and will be presented in a second table. In this second table I would like also a selection box which allows changing the skill set directly instead of clicking on the table row. I am very new to the web development, mysql, PHP etc. I have build this years ago in Excel and would like now to make an improved version as a web application. Right now I am trying to get a direction in my head which way to go with this, what is possible what is not. Been using internet search and books to help me with that. I guess what I struggle most with is the PHP Server, Javascript (Client) concept. Thanks again. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now