Filtering an Array Based on Value

[swib30]

I have a very simple script set up that pulls data from a database and is output using this 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:

2250

In stock.

Product One

2251

In stock. On order.

Product Two

2252

Out of stock. On order.

Product Three

2253

Out of stock.

Product Four

[.josh]

select column from table where column not like '%out of stock%'

[swib30]

Beautiful, thank you very much for the quick reply.

 

There is also a 'date' column which stores the date at which the field was added to the database. Because the script is run daily, there are multiple occurrences of each 'sku' with different statuses. How would I only display the most recent occurrence of each record?

[trq]

SELECT DISTINCT sku, status, name WHERE status NOT LIKE %out of stock% ORDER BY datefld DESC