Re: [PHP-DB] how to do query on partial field contents ???

2004-02-24 Thread Nitin Mehta
for partial match like 'value' doesn't work, use like '%value%' Hop that helps Nitin - Original Message - From: -{ Rene Brehmer }- [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 11:57 AM Subject: [PHP-DB] how to do query on partial field contents ??? hi

Re: [PHP-DB] how to do query on partial field contents ???

2004-02-24 Thread Frank Flynn
to do query on partial field contents ??? for partial match like 'value' doesn't work, use like '%value%' Hop that helps Nitin - Original Message - From: -{ Rene Brehmer }- [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 11:57 AM Subject: [PHP-DB

Re: [PHP-DB] how to do query on partial field contents ???

2004-02-24 Thread Andy Armstrong
Frank Flynn wrote: And if you'd like to make wild carding optional keep your code the way it is: $query .= AND `model` LIKE '.$_GET['search'].'; And put a comment on the web page Use the % for wild cards. The thing about: $query .= AND `model` LIKE '%.$_GET['search'].%'; Is it will

Re: [PHP-DB] how to do query on partial field contents ???

2004-02-24 Thread Frank Flynn
Too true - this is why a page that I promised would only take a few minutes winds up taking all week. But it makes steady employment for the QA team... Frank On 2/24/04 10:37 AM, Andy Armstrong [EMAIL PROTECTED] wrote: Frank Flynn wrote: And if you'd like to make wild carding optional

[PHP-DB] how to do query on partial field contents ???

2004-02-23 Thread -{ Rene Brehmer }-
hi gang I've mentioned this project before a couple of weeks ago ... just been busy with school, so haven't had time to work on it that much But anyways ... the test version is running here: http://metalbunny.net/computers/cpudb.php it's running with debug code, which should be obvious if