Jump to content
Sign in to follow this  
freddyk

html select, selected value as mysql SELECT FROM variable

Recommended Posts

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 by freddyk

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...