Re: MySQL with php

"Jan" <[email protected]> wrote in message
news:[email protected]...
| Hello
| i've a simple question i think ;)
| if i want to do a query with 2 keywords in a MySQL database, how do i
write
| it in my script?
|
| ie.  I want to search for name=peter pan   with the keywords "pan" and
| "peter"
|
| I thought it's like this:
| $query=SELECT ... FROM ... WHERE name LIKE '%pan%' AND LIKE '%peter%'
|

$query=SELECT ... FROM ... WHERE name LIKE '%pan%' AND name LIKE '%peter%'


| but this isn't working :(
|
| hope somebody can help me out.
|
| thanks,
|
|
| Jan
|
Cheers,
Dejan