if description does not contain the following words

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

Hello everyone,

I am parsing a MS Excel (.xls) file and adding it's content to a mySQL database, so far to good, but what I want to do is if the column titled description does not contain these words "seedlings" or "discount" then add it to the database but if it does skip it and keep looping.

Here is my code that I am trying to get working:if((!empty($description))or($available >0)and(!preg_match("/seedlings/i", $description))):
mysql_query("INSERT INTO `availability` VALUES ('','$description','$available','$price')");
endif;

I may not be using the right function for this "preg_match"?

Your Answer:

Login to answer

Other forums

Aris, Netweaver BPM, Visual composer and X'app
Dear Experts,

Whats the relationship between the following components: Aris, Netweaver BP

need help about
i store the value of my select statement result to an array and stored it to a variable named $fname

Change log of Cost centre change in Plant maintenance order
Hi,
How to view Change log of Cost centre in Plant maintenance order. Not visible thru 'Docume

Shuffle between users ??
I have multiple $users in table. I need to send them $message.

I need to send the next messag

Run function every 5 mins ??
I have a function PostMessage()

How can I run it every 5 mins ??

An odd assignment statement. Can someone explain this assignment to me?
What purpose is served by the bit of code between the two equal signs in the $installurl set? Is th

Change Age automatically
hi guys . im new to php , is it possible to change age value in mysql automatically when year change

HTML form problem
Ive made a form to that i want to send to my email via PHP. but when it send only the name's etc sen

confused between ' ' and " "
there is a php i set:
$begin_date_query = mysql_query( "SELECT SUBDATE(due_date, INTERVAL $d

PHP and Javascript
Hi Guys,

Im trying to load the contents of an html file into a text area for editing, this is