php related to figleaves feed

[DaveR]

Tweet

Hi all,

With the recent figleaves feed change I'm havaing difficulties.

I used to say:

$query = "SELECT * FROM Figleaves WHERE Manufacturer='Wonderbra' AND Category='Fashion | Lingerie | Bras";

Now figleaves have introduced a new category to look like this:
Fashion | Lingerie | Bras | Multiway-Strapless
Fashion | Lingerie | Bras | Non-underwired

Is there any way of putting a wild card in to include all these subcategories?

Thanks
Dave

[Retail-Therapy]

Use this

$query = "SELECT * FROM Figleaves WHERE Manufacturer='Wonderbra' AND Category like 'Fashion | Lingerie | Bras%'";

[DaveR]

Lovely thanks

Much appreciated.

DaveR