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

php title problem
Hi,

I am having a problem managing my page title with PHP.

Currently I have my <

PHP/PKI
I am trying to set up a web application that uses pki. does anyone have a good tutorial to set this

Help with page encoding issue and weird characters
I'm trying to write a screen scraper and when I pull out the lines of the html file that I'm interes

array empty
Hiya peeps,

Ok here is the codes.

order.php

Code:

About imagecopyresampled()
Hello,

I am looking to use this function to resize parts of an image to a fixed thumbnail siz

Install page
How do I make it so when a user submits information on the Install page, it'll right it into the cor

All possible combinations of Strings from table in PL/SQL
Hi,

I am trying to figure out how to build a list of all possible string combinations fro

reading partial code from external site
Hi,

I am trying to write a script for my website to get an article from an external website.

SAP Project Module
I have seen in the SAP Project Module,plan cost and budget are not equal and even difference is sign

Only add new information from XML to MySQL
What I am doing, is taking a xml file, and adding the values to a database. However, what I want to