echo an array value based on a mysql value

Question

Have a hard time trying to echo the $status arrays value into the cell where the $row['status'] is. Right now it prints the DB values of 0-3. if it is a "0" print uploaded.....

    while ($row = mysqli_fetch_assoc($result)) {
$status = array('uploaded', 'processing', 'error', 'closed');
?>
<tr align="center">
<td><?php echo $row['case_id']; ?></td>
<td><?php echo $row['doctor']; ?></td>
<td><?php echo $row['name']; ?></td>
<td><?php echo $row['upload_date']; ?></td>
<td><?php echo $row['service_date']; ?></td>
<td><?php echo $row['status']; ?></td>
<td><?php echo $row['message']; ?></td>
</tr>
<?php
};

As you already accessed the values from your db query, just use the variable as index, e.g. `$status[$row["status"]]` — Rizier123, Jul 08 '15 at 19:08

score 0 · Accepted Answer · answered Jul 08 '15 at 19:09

0

Just echo $status using $row['status'] as the key:

<td><?php echo $status[$row['status']]; ?></td>

answered Jul 08 '15 at 19:09

AbraCadaver

78,200
7
66
87

What if I wanted to add color the the row, can I use an array within the first array? As : or – Steveep Jul 08 '15 at 20:29
Assuming you had a `$color` array, same thing: `echo $color[$row['status']];` – AbraCadaver Jul 08 '15 at 20:53

echo an array value based on a mysql value

1 Answers1