RE: Wildcard queries via PHP4

From: "Jeff Fitzmyers" <jeff(dot)fitzmyers(at)managestar(dot)com>
To: "rickf" <rickf(at)dufferinresearch(dot)com>, <pgsql-php(at)postgresql(dot)org>
Subject: RE: Wildcard queries via PHP4
Date: 2001-04-06 23:39:03
Message-ID: 371EAC487A83CD4296F6999FD088D83305895B@atlas.managestar.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

This works for me on 7.1 beta 6; php-4.0.4pl1

$sql="SELECT *
FROM customer
WHERE $look_in ~*'$text' AND
mbewbe='$mbewbe' AND
c_state $query_location
ORDER BY company_name;";

jeff fitzmyers
>>>>

For whatever reason the *~ matching does not work in PHP4 (ie surname *~
)
(or more precisely I can't get it to work >>>>>>

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Grant 2001-04-08 23:46:26 Re: RE: Wildcard queries via PHP4
Previous Message Adam Lang 2001-04-06 17:15:35 Re: Sorting after a search