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

Ariba 9r - SAP MM Integration
Hi experts,

The standard Ariba adapter for 9r creates a relationship between Cost Centers

Simple email form - Newbie
Hello all,

First time poster!

I've been asked to create a simple HTML form that submit

help finding hacking loopholes
i was attacked by a redirect php injection

my pc is clean of viruses

so i figure that

Loosing changed contents when used FM REUSE_ALV_GRID_DISPLAY
Hi,

I have used FM REUSE_ALV_GRID_DISPLAY in my program as below.

CALL FUNCT

Sessions Value Not Saved
Hi,

Im making a login form and im using this code:
Code: if($login=="true"){

please help me in this update statment
hi every one

if I have table and this data in it

id name
10

Table trouble
i have been reading the forum for a few weeks and decided to join. i like the format and the advice

Recognising Revenue daily
Hello.
Has anyone come across daily recognition of deferred income?
We want to implement R

update the selected existing records of database
Hi frndz,
I am new to php and get stuck....

Edit.php > Update.php > Updatea

a function to check directory depth
I'm working on a php script to upload files in to a set directory.
the user can select to upload