Help for this page

Select Code to Download

Select or download this

<b>Name</b>                   <b>Name</b>    
Address                       Address
City                          City
Category                      Category

Select or download this

my $column = ( $type eq 'alpha' ) ? 'name' : "CONCAT_WS(' ',keywords,c
+ategory)";

my $query = "SELECT name, address, city, phone FROM valley ".
    "WHERE $column LIKE ? ORDER BY name LIMIT ?,?";