I am trying to color code table rows if a status is a certain type, that part is working fine, but I want to color code one cell differently if an event date is present, below you will find my IF statement, I am trying to color code the entire row yellow, but if event date is > than NULL it only turns that one cell in the yellow row pink. Hope that makes sense. Not sure how to put the second if statement.
if($row_ORDERS_NOT_NULL['status'] == 'IN PRODUCTION') { ////// echo '<td align="center" bgcolor="#FFFF00"><strong>' . $row_ORDERS_NOT_NULL['date_created'] . '</strong></td>'; echo '<td align="center" bgcolor="#FFFF00"><strong>' . $row_ORDERS_NOT_NULL['scnum'] . '</strong></td>'; echo '<td align="center" bgcolor="#FFFF00"><strong>' . $row_ORDERS_NOT_NULL['artnum'] . '</strong></td>'; echo '<td align="center" bgcolor="#FFFF00"><strong>' . $row_ORDERS_NOT_NULL['salesrep'] . '</strong></td>'; echo '<td align="center" bgcolor="#FFFF00"><strong>' . $row_ORDERS_NOT_NULL['company_name'] . '</strong></td>'; echo '<td align="center" bgcolor="#FFFF00"><strong>' . $row_ORDERS_NOT_NULL['invoice_num_op'] . '</strong></td>'; echo '<td align="center" bgcolor="#FFFF00"><strong>' . number_format($row_ORDERS_NOT_NULL['line_qty']) . '</strong></td>'; echo '<td align="center" bgcolor="#FFFF00"><strong>' . $row_ORDERS_NOT_NULL['factory'] . '</strong></td>'; echo '<td align="center" bgcolor="#FFFF00"><strong>' . $row_ORDERS_NOT_NULL['line_desc'] . '</strong></td>'; echo '<td align="center" bgcolor="#FFFF00"><strong>' . $row_ORDERS_NOT_NULL['order_po_number'] . '</strong></td>'; echo '<td align="center" bgcolor="#FFFF00"><strong>' . $row_ORDERS_NOT_NULL['license'] . '</strong></td>'; } **if($row_ORDERS_NOT_NULL['event'] > NULL) { echo '<td align="center" bgcolor="pink"><strong>' . $row_ORDERS_NOT_NULL['event'] . '</strong></td>'; }** if($row_ORDERS_NOT_NULL['status'] == 'IN PRODUCTION') { echo '<td align="center" bgcolor="#FFFF00"><strong>$' . number_format($row_ORDERS_NOT_NULL['factory_price'],2) . '</strong></td>'; echo '<td align="center" bgcolor="#FFFF00"><strong>$' . number_format($row_ORDERS_NOT_NULL['line_price'],2) . '</strong></td>'; echo '<td align="center" bgcolor="#FFFF00"><strong>' . $row_ORDERS_NOT_NULL['putin_prod'] . '</strong></td>'; echo '<td align="center" bgcolor="#FFFF00"><strong>' . $row_ORDERS_NOT_NULL['expected_ship_date'] . '</strong></td>'; echo '<td align="center" bgcolor="#FFFF00"><strong>' . $row_ORDERS_NOT_NULL['ship_from_factory'] . '</strong></td>'; echo '<td align="center" bgcolor="#FFFF00"><strong>' . $row_ORDERS_NOT_NULL['shippedto_customer'] . '</strong></td>'; echo '<td align="center" bgcolor="#FFFF00"><strong>' . $row_ORDERS_NOT_NULL['comments'] . '</strong></td>'; echo '<td align="center" bgcolor="#FFFF00"><strong>' . $row_ORDERS_NOT_NULL['ship_comments'] . '</strong></td>'; echo '</td></tr>'; }else
https://stackoverflow.com/questions/65745271/how-to-have-2-if-statements-for-row-color-coding January 16, 2021 at 08:22AM
没有评论:
发表评论