DaniWeb Forum Index > Web Development > PHP

Php Mysql : Code for Multiple Field Search

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Feb 2008

Posts: 25

Reputation: isomillennium is an unknown quantity at this point

Solved Threads: 1

isomillennium isomillennium is offline

Offline

Light Poster

Php Mysql : Code for Multiple Field Search

May 20th, 2008

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

•

Join Date: Nov 2007

Posts: 3,747

Reputation: nav33n is a jewel in the rough

Solved Threads: 331

nav33n

Offline

Senior Poster

Re: Php Mysql : Code for Multiple Field Search

May 20th, 2008

Help with Code Tags

php Syntax (Toggle Plain Text)

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

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Feb 2008

Posts: 25

Reputation: isomillennium is an unknown quantity at this point

Solved Threads: 1

isomillennium isomillennium is offline

Offline

Light Poster

Re: Php Mysql : Code for Multiple Field Search

May 20th, 2008

•

Originally Posted by nav33n

Help with Code Tags

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 ||