count($setlist)) ) { while ($index <= count($TestCookie)) { setcookie("TestCookie[$index]"); $index++; } } } /* End Set Cookies */ /* Erase Cookie */ if (isset($ClearList) && isset($TestCookie)) { while (list ($name, $value) = each ($TestCookie)) { /* setcookie("TestCookie[$name]"); */ setcookie ("TestCookie[$name]", "", time()-7*24*3600); } } /* End Erase Cookie */ if (!isset($forward) && !isset($back) ) { header ("Location: database.php3"); exit; } } $cid = mysql_connect($host,$usr,$pwd); if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); } /* Build Query String if the user clicked on search */ if (isset($search)) { $query = "select * from inventory where ID > 1 "; if ($song != '' && !isset($exact)) $query = $query . "AND song LIKE '%" . $song . "%' "; else if ($song != '') $query = $query . "AND song LIKE '" . $song . "' "; if ($band != '' && !isset($exact)) $query = $query . "AND band LIKE '%" . $band . "%' "; else if ($band != '') $query = $query . "AND band LIKE '" . $band . "' "; if ($album != '' && !isset($exact)) $query = $query . "AND album LIKE '%" . $album . "%' "; else if ($album != '') $query = $query . "AND album LIKE '" . $album . "' "; if ($category != '') $query = $query . "AND category LIKE '%" . $category . "%' "; $query = $query . "ORDER BY " . $sortby; } /* Show Song list - Retrieve Song information for Cookie values */ else { $query = "select * from inventory where ID = -12345 "; if (isset ($TestCookie) ) { reset($TestCookie); while (list ($name, $value) = each ($TestCookie)) { $query = $query . "OR ID = $value "; } } } /* End of Build Query */ /* print "$query

\n"; */ $retid = mysql_db_query($db, $query, $cid); #if (!$retid) { echo( mysql_error()); } if (!$retid) {$numrows=0;} else {$numrows = mysql_num_rows($retid);} /* Email Results */ if (isset($mail)) { $emailtext = "Song List for $custname <$email> (" . $numrows . " songs)\n\n"; while (($row = mysql_fetch_array($retid)) && $rowcount <= $rowlimit) { $emailtext = $emailtext . "$row[song] $row[band] $row[album]\n"; } if (isset($CC)) $sendto = $sendto . "," . $email; mail($sendto, "Centerstage Productions Song List", $emailtext, "From: $email"); header ("Location: after_inventory.php3"); exit; } /* End of Mail Output Loop */ ?> Los Angeles Wedding DJ, Los Angeles Beach DJ, Orange County Wedding DJ, Karaoke DJ, Corporate Entertainment Specialist, Los Angeles Wedding Entertainment

Los Angeles & Orange County Wedding DJ, Beach Weddings & Karaoke

Home PageHowContact Us About Your Wedding Reception
\n"; print "\n"; if (isset($search)) { print "\n"; } print "\n"; ?>
Donny Williams Song List back to Quick Lists
SOCIETY/JAZZ STANDARDS
All the Things You Are Our Love is Here to Stay Have You Met Miss Jones
Autumn Leaves Stolen Moments Since I Fell for You
How Insensitive Mack the Knife I Wish You Love
Cocovado Don't Explain Satin Doll
How High the Moon When I Fall in Love Take the "A" Train
Nature Boy Center Piece Summertime
Girl from Ipanema Nows the Time Stormy Weather
Lady is a Tramp Yesterdays I Could Write a Book
There Will Never Be another You Here's That Rainy Day What's New
Misty Unforgettable Midnight Sun
Route 66 Masquerade Black Orpheus
Dindi Sentimental Reasons Feel Like Making Love
Georgia on My Mind God Bless the Child Smoke Gets in Your Eyes
But Beautiful I Cover the Waterfront Angel Eyes
I Left My Heart in San Francisco One Note Samba They Can't Take that Away From Me
BLUES STANDARDS
Kansas City Straight No Chaser C.C. Rider
Aint' I Good Toy You Baby What You Want Maybelline
O.K. Alright Baby Don't Cha Go Down Home Blues
R & B / POP / MOTOWN
SONG ARTIST
How Deep is Your Love Bee Gees / Portrait
Could It Be I'm Falling in Love Spinners
I Can Love You Like That All-4-One
Love Trip Acid Jazz Dance U.K.
You Know What I Want Acid Jazz Dance U.K.
Humpin AroundA Bobby Brown
Two Can Play at that Game Bobby Brown
I Saw Her Standing There Beatles
Twist & Shout Beatles
That the Way Love Goes Janet Jackson
You Are Not Alone Michael Jackson
My Cheri Amour Stevie Wonder
Sunshine of My Life Stevie Wonder
Ribbon in the Sky Stevie Wonder
I Was Mad to Love Her Stevie Wonder
The Closer I Get to You Roberta Flack
What's Goin On Marvin Gaye
All This Love DeBarge
Baby Baby Brandy
La La Means I Love You Delphonics
You are so Beautiful Joe Cocker
Sweet Love Anita Baker
Rapture of Love Anita Baker
Here I Go Again Smokey Robinson
Please, Please James Brown
My Girl Temptations
Get Ready Temptations
Searchable Music Database
SONG TITLE ARTIST ALBUM CATEGORY
> Exact Match   
Query matched $numrows songs.   \n"; if ($numrows > $rowlimit) { if ($startrow == 0) print "(Showing first $rowlimit songs.)\n"; else { $endrow = $startrow+$rowlimit; $realstartrow = $startrow+1; if ($endrow > $numrows) $endrow=$numrows; print "(Showing songs $realstartrow - $endrow.)\n"; } } if ($numrows <= 10) { print "You are welcome to supply any music we may not have.
If the song/artist is a viable addition to our library, we are happy to purchase a copy.

\n"; } } if (!isset($search)) { if ($numrows == 1) print " 
You have $numrows song in your song list.\n"; else print " 
You have $numrows songs in your song list.\n"; if ($numrows == 0) print "Fill in the fields above to select songs."; } print "

"; if ($numrows >0) print " \n"; if (isset($TestCookie) && !isset($showlist) ) print "    "; print "
\n"; if ($numrows > 0) { print "\n"; /* Forward/Backward Browsing Buttons */ if ($numrows > $rowlimit) { print "\n"; } /* End of Browsing Buttons */ print "\n"; /* Start of Song Output Loop */ $rowcount = 0; if (isset($startrow) && isset($search)) { mysql_data_seek($retid, $startrow); } while (($row = mysql_fetch_array($retid)) && $rowcount <= $rowlimit) { print ""; print ""; print ""; print ""; print ""; print ""; print "\n"; $rowcount += 1; } /* End of Song Output Loop */ /* Forward/Backward Browsing Buttons */ if ($numrows > $rowlimit) { print "\n"; } /* End of Browsing Buttons */ print "
\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; if ($startrow > 0) print " \n"; if (($startrow+$rowlimit) < $numrows) print "   \n"; print "
  SONG ARTIST ALBUM CATEGORY
$row[song]$row[band]$row[album]$row[category]
\n"; if ($startrow > 0) print " \n"; if (($startrow+$rowlimit) < $numrows) print "   \n"; print "

"; print "
"; if (isset($search)) print " \n"; if ( isset($search) && isset($TestCookie) && !isset($showlist) ) print "   \n"; if (isset($TestCookie) && !isset($search)) { print "\n"; } print "
"; } /* End of no output loop */ mysql_close ($cid); if (($numrows > 0) && !isset($search) ) { print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "
\n"; print "
Send Song List to DJ Peace
Your Name:Your E-mail:
\n"; print " Send a copy to your email address
"; } ?> SetList Values:
\n"; reset($setlist); while (list ($name, $value) = each ($setlist)) { echo "$name == $value
\n"; } } print "

\n"; if (isset ($TestCookie)) { print "

Cookie Values:
\n"; reset($TestCookie); while (list ($name, $value) = each ($TestCookie)) { echo "$name == $value
\n"; } } */ ?>

 
Copyright ©1997-2003 Centerstage Productions All rights reserved