2. PHPRunner General questions
  3. $strWhereClause Contains
This topic is locked

$strWhereClause Contains

 		12/15/2009 05:41:40
PHPRunner General questions
N
 netmedia59 author

Hello,
I have a Table : docky_life

and a field Categ (varchar)

This Field contains some words like 301 or 301,302 or 303 ...
In the $strWhereClause (before SQL) in the List, I want to list all the records containing 301

How can I write this ?
Thanks
Olivier

Lille (FRANCE)
J
 		Jane 12/15/2009

Olivier,
here is a sample:

$strWhereClause = whereAdd($strWhereClause,"FieldName LIKE '%301%'");
N
 		netmedia59 author 12/15/2009

Hey Jane,
Thanks

It works as expected ... as always !
Olivier



Olivier,
here is a sample:

$strWhereClause = whereAdd($strWhereClause,"FieldName LIKE '%301%'");