Hello,

I'm trying to make a script so I can select a "unit" and change it's status to either "available" or "unavailable". I just can't seem to get it to work though.

Here is what I'm currently using:

PHP Code:

<?php
        // Display Units
        $resultIncident = mysql_query("SELECT * FROM units");

echo "<table border='1'>
<tr>
<th>Unit ID</th>
<th>Unit Status</th>
<th>District</th>
<th>Change Status</th>
</tr>";

while($row = mysql_fetch_array($resultIncident))
  {
  echo "<tr>";
  echo "<td>" . $row['id'] . "</td>";
  echo "<td>" . $row['status'] . "</td>";
  echo "<td>" . $row['district'] . "</td>";
  //make the title a link
  echo "<input type='hidden' name='pin' value='$row[id]'/>";
  echo "<td><input type='submit' class='deleteButton' name='unitStatusN' value='Delete Incident'/></td>";
  echo "</tr>";
  }
echo "</table>";

        ?>
<?php
// Unit Status (Available)
/*
if ($_POST['statusAvailable']){
    $uid = $_POST['id'];
    $queryUnit = mysql_query("UPDATE units SET status='Available' WHERE id='$uid'")or die(mysql_error());
}
// Unit Status (Unavailable)
if ($_POST['statusUnavailable']){
    $uid = $_POST['id'];
    $queryUnit = mysql_query("UPDATE units SET status='Unavailable' WHERE id='$uid'")or die(mysql_error());
}
*/
//Change Unit Status
if ($_POST['unitStatusN']) {
    $unitID = $_POST['id'];
    $unitQuery = mysql_query("UPDATE units SET status='unavailable' WHERE id='$unitID'")or die(mysql_error());
    $resultUnit = mysql_query($query);
}

// Delete Incident
//If cmd has not been initialized
if(!isset($status)) 
{
   //display all the news
   $resultUnit = mysql_query("select * from units order by id"); 
   
   //run the while loop that grabs all the news scripts
   while($r=mysql_fetch_array($resultUnit)) 
   { 
      //grab the title and the ID of the news
      $idUnit=$r["id"];//take out the id
    }
} 

$statusN = "Unavailable";
?>

If anyone can help me with this, I'd be very grateful.

Thanks

What is the definition of your table ?
Is the field "units" a varchar ?
Also, does the die(mysql_error()) output something or does the update goes without problem ?

Does the block "if ($_POST['unitStatusN'])" is entered (put an echo in it or something like that to check)?

Ok, here's a picture of what I currently have...



In the "Unit Status" column, I want to be able to press either "Available" or "Unavailable" on the right, and it will change it in that "Unit Status" column for the specific unit.

Is that a little clearer?

Sadly, no.

I need the definitions of the table columns.
What is their type? char, varchar, enum, int ?

I need the ouptut of describe tableName in the sql front-end, like this:

mysql> describe band;
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| id          | int(11)      | NO   | PRI | NULL    | auto_increment |
| band_id     | int(11)      | YES  |     | NULL    |                |
| release_ids | varchar(255) | YES  |     | NULL    |                |
+-------------+--------------+------+-----+---------+----------------+
3 rows in set (0.02 sec)

Sorry, I'm pretty new to this stuff so...I'll try my best.

The database name is "units"

I have 4 fields (id, status, district, uid) The id field is varchar(4). The status field is varchar(300). The district field is varchar(10). And the uid row is int(30) and is auto_increment. Each of these fields is NOT null.

Is this what you need? Sorry if this isn't.

No, it's ok. It was my question.
Now I know that the "status" field is really a varchar field.

I just reviewed the PHP code you gave up there, and I don't see much to say.
The logic seems ok.

Just, is it the full file, or just an excerpt of it?
I'm asking because I find a bit strange that you do the update part after the display.

It means that when you hit this page with an update request, you first fetch and display the value in the db, then do the update.
Therefore, what is displayed on the page is not up to date.

Could this be your problem?
When you click the update button in the page, do you see the changes in the db if you check the particular entry you updated ?

The code I gave is just an excerpt of it. Would you like the full code?

Yes, please