Jump to content

help with php list box


rsammy

Recommended Posts

i am working on a php app. i need to populate a list box(drop down) with three values(not from db) like 'ALL', 'ACTIVE' and "INACTIVE'.

when 'ACTIVE' is chosen from the list box, i need to check one table in the db and get all the info from the table based on a certain criteria. if INACTIVE is chosen, then another table is searched and infor from that table needs to be displayed. ALL displays values from both tables.

Lemme make it clearer:

I have two tables: admission and admit_status. the admission table has a field called discharge_date. as long as the patient is admitted, this field shows '00-00'0000' as the date. it is updated with the date when the patient is discharged. while this date is being updated, the patients info(such as, location, reason, room_no, admit date, etc.) is deleted from theadmit_status table.

I am checking on a patient activity summary report. in this report, i need to see all those patients who are either "ACTIVE' or "INACTIVE'. ACTIVE means the patient is still active in the hospital(admitted state and his discharge_date in the admission table is still '0000-00-00'.

If the I choose INACTIVE from the drop down, the those patients who have been discharged and not active (or admitted in the hospital) - whose info has been deleted from the admit_status table - need to be displayed.

ALL -should display all patients irrespective of their status.

hope i am clear here. any help will be appreciated. THANKS
Link to comment
Share on other sites

Well if you're looking to have it done automatically you're going to need to use AJAX which can do your queries without refreshing the page.  It's a lot more to learn and it takes time and well, I'm angry at it right now.

If you want a drop down with your 3 options and a submit button, I may be able to help.

If this were me though, I would change 'all','active','inactive' fields to '0','1','2' for that inner nerd in me.  The rest is fairly simple.

[code]
<form action="results.php" method="post">
  <select name="patient_status" size="3">
    <option selected="selected">Patient status</option>
    <option value="0">All</option>
    <option value="1">Active</option>
    <option value="2">Inactive</option>
  </select>
  <input type="submit" value="Fetch" />
</form>

<?php
if ($_POST['patient_status']) {
  $checkStatus = mysql_query("SELECT field1, field2 FROM table WHERE status = $_POST[patient_status]") or die (mysql_error());
}

if (mysql_num_rows($checkStatus) == 0) {
  // nothing was returned, fail
} else {
  while ($patient = mysql_fetch_array($checkStatus)) {
    // list patients
  }

?>
[/code]

That's the basics of it all but it should get you started or at the very least, occupied.  I use Adodb so my basic mySQL is kind of rusty, sorry for any errors there.
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

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.   Restore formatting

  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.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.