Easy Search

There are two ways to search: the easy way and the advanced way.

Easy search

In the easy way, you just enter a search term, and it searches for that search term in most of the available table fields. The construction of the MySQL statement looks like this:

  my $sql = "SELECT * FROM gen44_rom WHERE " . 
         "DanceName LIKE '%$easy%' OR " .
         "Rhythm LIKE '%$easy%' OR " .
         "Phase LIKE '%$easy%' OR " .
         "Choreographer LIKE '%$easy%' OR " .
         "Label LIKE '%$easy%' OR " .
         "Record LIKE '%$easy%' OR " .
         "Year LIKE '%$easy%' OR " .
         "Extra LIKE '%$easy%'; ";

Advanced Search »