Selecting multiple fields from a table

[erme]

Hi, Im trying to select more then one field in a table for a search function.

 

select * from TABLENAME where FIELDNAME1 FIELDNAME2 '%".$_GET['content']."%'

[Lamez]

SELECT * FROM $table WHERE col = 'val'

[erme]

SELECT * FROM $table WHERE col = 'val'

 

So will this work?

 

select * from TABLENAME where col = 'FIELDNAME1 FIELDNAME2' '%".$_GET['content']."%'

[Lamez]

no you need a and clause.

 

SELECT * FROM $table WHERE col = 'val' AND col2 = 'val2'

 

I think that is right.

[erme]

Got it to work thanks

[Lamez]

Hoped I helped. Mark as solved!