Menu Content/Inhalt
Home arrow Songs
Songs Print E-mail
0 '.$whereClause.' ORDER BY '.$fld.' ASC'; $rs = mysql_query($SQL) or die ("Error in query: $SQL. " . mysql_error()); $HTMLString = ' '; $HTMLString .= ' '; $HTMLString .= '
'.ucfirst($fld).' '; $HTMLString .= ''; $HTMLString .= '
'; return $HTMLString; } function Search($srch_term) { // Search for srch_term within the song listing $HTMLString = ' '; $HTMLString .= '
Find Artist/Song:
'; return $HTMLString; } function Search_Trak($fld, $term, $remote_host, $referer) { // Track the search term selected, or value selected in field dropdowns $SQL = "INSERT INTO search_trak VALUES('', '$fld', '$term', '$remote_host', '$referer', CURRENT_TIMESTAMP)"; $link = mysql_connect('localhost', 'db', 'db123'); mysql_select_db('dedbatteries', $link); $rs = mysql_query($SQL); // return $SQL.'
'; } $dbhost="localhost"; $dbuser="blackcat_db"; $dbpw="Beer199^"; $db="blackcat_dedbatteries"; $oncolor = "#DDE8EE"; $offcolor = "#EEFFE8"; $link = mysql_connect($dbhost,$dbuser,$dbpw); mysql_select_db($db, $link); $i=0; $where_clause = ''; // Criteria for listing... if ( $_REQUEST['artist'] <> '') { if (ereg(',', $_REQUEST['artist'])) { $srch_ary = split(',', $_REQUEST['artist']); $cnt = 0; foreach ($srch_ary as $term) { $term=trim($term); $srch_str = $srch_str."artist LIKE '%$term%' "; $cnt++; if ($cnt < count($srch_ary)) { $srch_str = $srch_str.'OR '; } } $where_clause = " WHERE ".$srch_str; } else { $where_clause = " WHERE artist LIKE '%$_REQUEST[artist]%' "; } } if ( $_REQUEST['solo_duet'] <> '' ) { if ( $where_clause == '' ) { $where_clause = " WHERE FIND_IN_SET('$_REQUEST[solo_duet]', `solo_duet`) > 0 "; } else { $where_clause = $where_clause . " AND FIND_IN_SET('$_REQUEST[solo_duet]', `solo_duet`) > 0 "; } } if ( $_REQUEST['style'] <> '' ) { if ( $where_clause == '' ) { $where_clause = " WHERE FIND_IN_SET('$_REQUEST[style]', `style`) > 0 "; } else { $where_clause = $where_clause . " AND FIND_IN_SET('$_REQUEST[style]', `style`) > 0 "; } } if ( $_POST['SearchTerm'] <> '' ) { // Overrides all other criteria Search_Trak('SearchTerm', $_REQUEST['SearchTerm'], $_SERVER['REMOTE_HOST'], $_SERVER['REFERER']); $where_clause = " WHERE song LIKE '%".$_POST['SearchTerm']."%' OR artist LIKE '%".$_POST['SearchTerm']."%' OR filename LIKE '%".$_POST['SearchTerm']."%'"; } if ( $_REQUEST['mp3only'] == 'on' ) { if ( $where_clause == '' ) { $where_clause = " WHERE filename LIKE '%mp3%' "; } else { $where_clause = $where_clause . " AND filename LIKE '%mp3%' "; } } $SQL = " SELECT song, artist, solo_duet, style, filename FROM song_list $where_clause ORDER BY song "; $rs = mysql_query($SQL); ?>
Show All
name="mp3only" OnChange="CheckMP3(this.form.mp3only);">MP3 only
Song Title MP3 Artist(s)
\"".$row['song']."\""; } ?>
Return
Last Updated ( Sunday, 27 May 2007 )
 
« < October 2020 > »
M T W T F S S
28 29 30 1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31 1

About Us

Ded Batteries Entertainment has been providing live music in and around Phoenix, AZ since 2001.


  • Concerts

  • Corporate Events

  • Casino Performances & Showcases

  • Weddings / Birthdays & other Personal Occasions

  • Private Parties

  • Classic rock and / or classical music for instrumental only¬†piano presentations

  • Full production shows of popular artists from the 1950s to 2007 and beyond...

  • Dueling Piano-style request performances

  • The Pink Floyd Tribute performance (Inquire within)

  • Support for female vocal accompanist on request.