How to search database using php

[ehpratah]

what can you say bout it? on my own understanding the error is this part '%{$table}%' and '%{$search}%'

[ehpratah]

but table name must be dynamic and must cope with what the user choose in the form that he submit..or you have a better idea to do it..

[ehpratah]

hey dude i found an alternative i got it working but maybe its a bad coding i dunno..i use if statement

[Rabbit]

The fact that the user needs to choose the table dynamically indicates that your data is in a non-normalized format and you should really think about normalizing it so you don't have to deal with choosing a table.