Ad:

PHP Discussion Thread
Unsolved
Views: 9040

May 20th, 2008

Php Mysql : Code for Multiple Field Search

Expand Post »

What would be the php mysql code to search more than 1 field in a table ?

Im trying to search for a given partial phone number in all three fields home mobile and work ..

im trying to use

$query = "SELECT `first`, `last`, `home_phone` , `work_phone` , `mobile_phone` FROM `profiles` WHERE LIKE '%516353%'

but this returns everything thats in the table

Any help would be appreciated

Similar Threads

Searching multiple fields... in PHP
Getting Radio Buttons to access Mysql Database in PHP
multiple search terms+fulltext search in MySQL
hello and plz help in PHP

isomillennium

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

25 posts
since Feb 2008

Permalink

May 20th, 2008

Re: Php Mysql : Code for Multiple Field Search

php Syntax (Toggle Plain Text)

$query = "select * from table where home_phone like '%516%' OR work_phone like '%516%' OR mobile_phone like '%516%'";

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

May 20th, 2008

Re: Php Mysql : Code for Multiple Field Search

Click to Expand / Collapse Quote originally posted by nav33n ...

php Syntax (Toggle Plain Text)
$query = "select * from table where home_phone like '%516%' OR work_phone like '%516%' OR mobile_phone like '%516%'";
$query = "select * from table where home_phone like '%516%' OR work_phone like '%516%' OR mobile_phone like '%516%'";

thatnk it worked fine i just had to change OR TO ||

isomillennium

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

25 posts
since Feb 2008

Permalink

May 20th, 2008

Re: Php Mysql : Code for Multiple Field Search

It should work with OR.. But anyway, cheers!

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: FTP problem

Next Thread in PHP Forum Timeline: error_reporting() doesn't seem to work

DaniWeb Message

Cancel Changes

User Name
Password