php report form help

Question

fire eaters 0 Newbie Poster

12 Years Ago

<select name="criteria" class="report_listbox">
<option value="">Status</option>
<option value="PASS">PASS</option>
<option value="FAIL">FAIL</option>
<option value="ALL">ALL</option>
</select>
------------------------------------------------------------------------------------
$date = $_POST;
$criteria = $_POST;

$sql=" SELECT frsemployees.`name`, bft.`date`,bft.`dpush`,bft.`push`,
bft.`dsit`,bft.`sit`,bft.`drun`,bft.`run`,bft.`status`
FROM `bft`
INNER JOIN frsemployees ON frsemployees .empid = bft.empid
WHERE bft.`date`= '".$date."' AND bft.`status` = '".$criteria."' ";
--------------------------------------------------------------------------------------
the bft database table `status` row containes "FAIL" or "PASS". now when i select "PASS" and "FAIL im getting all the people who passes and failed... how can i modifie the query so that when i click "ALL" in the dropdown list box and get all "PASS" and "FAIL"

php

3 Contributors
6 Replies
117 Views
12 Hours Discussion Span
Latest Post 12 Years Ago Latest Post by karthik_ppts

diafol

12 Years Ago

Just leave off the criteria bit from the where clause

karthik_ppts commented: helpful Post +6

karthik_ppts 81 Posting Pro

12 Years Ago

$date = $_POST['date'];
$criteria = $_POST['criteria'];
$join="";
if($criteria=="PASS" || $criteria=="FAIL" )
{
$join=" AND bft.`status` = '".$criteria."'";
}
$sql=" SELECT frsemployees.`name`, bft.`date`,bft.`dpush`,bft.`push`,
bft.`dsit`,bft.`sit`,bft.`drun`,bft.`run`,bft.`status`
FROM `bft`
INNER JOIN frsemployees ON frsemployees .empid = bft.empid
WHERE bft.`date`= '".$date." $join";

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

fire eaters 0 Newbie Poster · Answer 1 · 2012-02-17T16:06:58+00:00

Just leave off the criteria bit from the where clause

Then i wont get "PASS" and "FAIL" employees... the criteria includes "PASS" "FAIL" and "ALL"

diafol · Answer 2 · 2012-02-17T19:20:21+00:00

AS KP puts it, you just leave off the status part when ALL is the criteria.

fire eaters 0 Newbie Poster · Answer 3 · 2012-02-17T19:43:12+00:00

AS KP puts it, you just leave off the status part when ALL is the criteria.

Thank you both of you.. it really helped me...thanks again

karthik_ppts 81 Posting Pro · Answer 4 · 2012-02-17T19:45:58+00:00

Mark as solved if your problem was solved.
use code tags for your codes.