Databases
StackOverflow2013
Postsdbo
POReturn 2 dates from single combo box to query MYSQL db
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POReturn 2 dates from single combo box to query MYSQL db
    primarykey
    data
    text
    <p>So I want to have a user select a 'week' from a combo box, and have that return 2 dates (start and finish of that week) to an SQL statement..... which would give data within that week period. I only need 1 combo box, as this data will only be available for weeks.. how do i do it?</p> <p>Here is my code:</p> <pre><code>&lt;form id="weekselectform" name="weekselectform" method="post" action=""&gt; &lt;div id="weekselect"&gt; &lt;table&gt; &lt;tr&gt; &lt;td&gt;Select Week: &lt;select name="dateentryweek" id="entryweek1"&gt; &lt;option value=""&gt;&lt;/option&gt;&lt;option value="2013-07-01"&gt;Week 1&lt;/option&gt;&lt;option value="2013-07-08"&gt;Week 2&lt;/option&gt;&lt;option value="2013-07-15"&gt;Week 3&lt;/option&gt;&lt;option value="2013-07-22"&gt;Week 4&lt;/option&gt; &lt;option value="2013-07-29"&gt;Week 5&lt;/option&gt;&lt;option value="2013-08-05"&gt;Week 6&lt;/option&gt;&lt;option value="2013-08-12"&gt;Week 7&lt;/option&gt;&lt;option value="2013-08-19"&gt;Week 8&lt;/option&gt; &lt;option value="2013-08-26"&gt;Week 9&lt;/option&gt;&lt;option value="2013-09-02"&gt;Week 10&lt;/option&gt;&lt;option value="2013-09-09"&gt;Week 11&lt;/option&gt;&lt;option value="2013-09-16"&gt;Week 12&lt;/option&gt; &lt;option value="2013-09-23"&gt;Week 13&lt;/option&gt;&lt;option value="2013-09-30"&gt;Week 14&lt;/option&gt;&lt;option value="2013-10-07"&gt;Week 15&lt;/option&gt;&lt;option value="2013-10-14"&gt;Week 16&lt;/option&gt; &lt;option value="2013-10-21"&gt;Week 17&lt;/option&gt;&lt;option value="2013-10-28"&gt;Week 18&lt;/option&gt;&lt;option value="2013-11-04"&gt;Week 19&lt;/option&gt;&lt;option value="2013-11-11"&gt;Week 20&lt;/option&gt; &lt;option value="2013-11-18"&gt;Week 21&lt;/option&gt;&lt;option value="2013-11-25"&gt;Week 22&lt;/option&gt;&lt;option value="2013-12-02"&gt;Week 23&lt;/option&gt;&lt;option value="2013-12-09"&gt;Week 24&lt;/option&gt; &lt;option value="2013-12-16"&gt;Week 25&lt;/option&gt;&lt;option value="2013-12-23"&gt;Week 26&lt;/option&gt;&lt;option value="2013-12-30"&gt;Week 27&lt;/option&gt;&lt;option value="2014-01-06"&gt;Week 28&lt;/option&gt; &lt;option value="2014-01-13"&gt;Week 29&lt;/option&gt;&lt;option value="2014-01-20"&gt;Week 30&lt;/option&gt;&lt;option value="2014-01-27"&gt;Week 31&lt;/option&gt;&lt;option value="2014-02-03"&gt;Week 32&lt;/option&gt; &lt;option value="2014-02-10"&gt;Week 33&lt;/option&gt;&lt;option value="2014-02-17"&gt;Week 34&lt;/option&gt;&lt;option value="2014-02-24"&gt;Week 35&lt;/option&gt;&lt;option value="2014-03-03"&gt;Week 36&lt;/option&gt; &lt;option value="2014-03-10"&gt;Week 37&lt;/option&gt;&lt;option value="2014-03-17"&gt;Week 38&lt;/option&gt;&lt;option value="2014-03-24"&gt;Week 39&lt;/option&gt;&lt;option value="2014-03-31"&gt;Week 40&lt;/option&gt; &lt;option value="2014-04-07"&gt;Week 41&lt;/option&gt;&lt;option value="2014-04-14"&gt;Week 42&lt;/option&gt;&lt;option value="2014-04-21"&gt;Week 43&lt;/option&gt;&lt;option value="2014-04-28"&gt;Week 44&lt;/option&gt; &lt;option value="2014-05-05"&gt;Week 45&lt;/option&gt;&lt;option value="2014-05-12"&gt;Week 46&lt;/option&gt;&lt;option value="2014-05-19"&gt;Week 47&lt;/option&gt;&lt;option value="2014-05-26"&gt;Week 48&lt;/option&gt; &lt;option value="2014-06-02"&gt;Week 49&lt;/option&gt;&lt;option value="2014-06-09"&gt;Week 50&lt;/option&gt;&lt;option value="2014-06-16"&gt;Week 51&lt;/option&gt;&lt;option value="2014-06-23"&gt;Week 52&lt;/option&gt; &lt;/select&gt; &lt;/td&gt; &lt;td&gt;&lt;input type="submit" value="GO" class="button black" id="weekbutton2" /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/div&gt; &lt;/form&gt; </code></pre> <p>That submits to the page and was originally grabbed with 2 combo boxes, by php:</p> <pre><code>$inputweek11 = $_POST[entryweek1]; $inputweek22 = $_POST[entryweek2]; $result1=mysql_query(" SELECT Supervisor, COUNT(CASE WHEN DAYOFWEEK(workdate) = 2 THEN 1 END) `Monday`, COUNT(CASE WHEN DAYOFWEEK(workdate) = 3 THEN 1 END) `Tuesday`, COUNT(CASE WHEN DAYOFWEEK(workdate) = 4 THEN 1 END) `Wednesday`, COUNT(CASE WHEN DAYOFWEEK(workdate) = 5 THEN 1 END) `Thursday`, COUNT(CASE WHEN DAYOFWEEK(workdate) = 6 THEN 1 END) `Friday`, COUNT(CASE WHEN DAYOFWEEK(workdate) = 7 THEN 1 END) `Saturday` FROM payroll.employeedatanew_copy JOIN payroll.employeehours ON employeedatanew_copy.`ID Number` = employeehours.employeeid WHERE employeehours.workdate BETWEEN '$inputweek11' AND '$inputweek22' GROUP BY supervisor "); </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USatomapps
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COThe question can be answered with this one. http://stackoverflow.com/a/3318167/401299
      singulars
      1. POReturn 2 dates from single combo box to query MYSQL db
      1. USdockeryZ
    2. COI don't believe so, I have custom weeks...
      singulars
      1. POReturn 2 dates from single combo box to query MYSQL db
      1. USatomapps
    3. COSince your weeks have been customized to begin in July, you will need to get the correct Week Number for that day and use the solutions in the link above. Any other way would be extremely redundant.
      singulars
      1. POReturn 2 dates from single combo box to query MYSQL db
      1. USdockeryZ
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload