Filtering an Array Based on Value

Posted on 16th Feb 2014 07:03 pm by admin

I have a very simple script set up that pulls data from a database and is output using this code:

Code: Print "<table border cellpadding=3>";
Print "<th>sku</th><th>status</th><th>name</th>";
while($info = mysql_fetch_array( $data ))
{
Print "<tr>";
Print "<td>".$info['sku'] . "</td> ";
Print "<td>".$info['status'] . "</td> ";
Print "<td>".$info['name'] . " </td></tr>";
}
Print "</table>";
However, I would like to only output rows that meet certain criteria. More specifically, I only want to show rows in which the 'status' field contains the text value "Out of stock" at any position within the field. (e.g. some fields say "Out of stock. On order.")

Any help with this will be greatly appreciated.

And here's a sample of what the table output currently looks like:
2250In stock.Product One2251In stock. On order.Product Two2252Out of stock. On order.Product Three2253Out of stock.Product Four

Your Answer:

Login to answer

Other forums

CODE NOT WORKING
Code: [Select]<?php
//include shared codes

include '../lib/common.php';
include

PHP search multiple input field box help
I am having a problem with my search script. At current it will simply search by a selected date whi

Easy administration on MySQL databases
My website is database driven and I am very tired of manually making queries to my tables in order t

mysql timestamp manipulation
How could I use a timestamp (e.g 2009-10-30 13:20:35 ), and with php find out if it is:

from

Need help PLEASE
ok i have this warning showing up

Warning: in_array() [function.in-array]: Wrong datatype for

Multiple websites question.
Hi, does php have any functionality that enables a programmer to extract information from a website

Limiting uploaded file type
I am working on a simple upload script, and I need it to limit the allowed file type that is uploade

how to validate date using javascript
I need to validate date in textbox using javascript..
The date is must be not greater than TODAY

defining website tags
Hi,

What would be the best way to define tags for my site, such as website title, url etc.

New to Arrays
Hi I am new to PHP (a week and a half now) and I am just beginning to read about arrays. I understan