Searching

[chwebdesigns]

Hi,

 

I have a PHP code which searches a mysql database. And then shows the results. However, I want the code to search multiple columns and then show which column it comes from.

 

An example of the table called $table:

Gold

Silver

Bronze

J Smith

A Jones

C Holmes

 

and i used the php code to select it from a single column rather than searching multiple columns:

<?php $sql  = "SELECT * from $table where gold like '%$name%' "; ?>

 

Hope that this makes sense.

 

Thanks in advance

[lemmin]

You will have to list all of the columns that you want it to search in:

<?php $sql  = "SELECT * from $table where gold like '%$name%' OR silver like '%$name%' OR bronze like '%$name%'"; ?>

 

After that, you will have to search the returned array for which row key has the search value because it will return something like this:

[gold] => "J Smith",
[silver] => "A Jones",
[bronze] => "C Holmes"

 

So you have find the value and return the key to see what column it was in.