Re: [PHP] Doing a Multiple Search

2003-03-04 Thread Marek Kilimajer
There have been plenty answers for this, search the archives. Hunter, Jess wrote: I know this must be an easy solution, just not seeing what it is. I have tried to add several options to the below code but can't seem to get it right. Here is the Base Line I am working with: $Query=SELECT *

Re: [PHP] Doing a Multiple Search

2003-03-04 Thread Ernest E Vogelsinger
At 14:50 04.03.2003, Hunter, Jess spoke out and said: [snip] Here is the Base Line I am working with: $Query=SELECT * from $TableName WHERE lastname='$Array[lastname] AND firstname='$Array[firstname]' ; What I ant to be able to do is a search on both the

RE: [PHP] Doing a Multiple Search

2003-03-04 Thread Justin Michael Couto
Hunter, What you need to do is this: $Query=SELECT * from $TableName WHERE lastname='$Array[lastname]' OR firstname='$Array[firstname]' ; That will get the functionality you are looking for. You might also want to consider doing this: $Query=SELECT * from $TableName WHERE lastname LIKE