Newbie question...
| From: | Daniel Furse | Date: | Fri, 23 Feb 2001 09:29:07 +0000 |
| Subject: | Newbie question... | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-5710@lists.php.net to get a copy of this message | ||
Hi,
I'm having problems getting a query to work, it's a fairly simple select
query, with wildcards.
This is the query as designed in MS Access 97's query designer:
SELECT Contacts.ForeName FROM Contacts WHERE (((Contacts.ForeName) Like
"*dan*"));
This selects 7 names from our database when run in Access.
I run the following query through PHP:
SELECT Contacts.ForeName FROM Contacts WHERE (((Contacts.ForeName) Like
'$contact_name'))
($contact_name expands to *dan*)
This returns no results. I've tried various wildcard queries, but none of
them seem to work.
How do I do wildcard queries in PHP?
Many thanks,
Dan Furse