[PHP-DB] Help Please! Complex AND OR LIKE queries MySQL/PHP

2001-09-18 Thread Dave Watkinson
Hi everyone I need to write a small search script for our admin site (and eventually for the outsiders too!). There's a text box where the user types in what they're searching for. It's easy enough to parse their string into an array and create the query from it, for example user typed in

RE: [PHP-DB] Help Please! Complex AND OR LIKE queries MySQL/PHP

2001-09-18 Thread Rick Emery
] Help Please! Complex AND OR LIKE queries MySQL/PHP Hi everyone I need to write a small search script for our admin site (and eventually for the outsiders too!). There's a text box where the user types in what they're searching for. It's easy enough to parse their string into an array and create

RE: [PHP-DB] Help Please! Complex AND OR LIKE queries MySQL/PHP

2001-09-18 Thread Dave Watkinson
Cheers Rick ... I think I nailed it. I've copied my little function below for anyone else interested. Am keen on the saving milliseconds bit, though (will add it to the function below before making it live). Any more tips? Dave function parse($what) { $what =