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"; ?>
First Dance Suggestions back to Quick Lists
  SONG ARTIST
All The Way Frank Sinatra
Almost Paradise Ann Wilson And Mike Reno
Always Erasure
As Time Goes By Jimmy Durante
Avalon Roxy Music
The Best Of Times Styx
Can You Feel The Love Tonight Elton John
Can't Help Falling In Love Elvis Presley
Can't Take My Eyes Off Of You Frankie Valli
Chances Are Johnny Mathis
Cheek To Cheek Ella Fitzgerald & Louis Armstrong
Crazy For You Madonna
Don't Know Much Aaron Neville & Linda Rodstadt
Embraceable You Billie Holliday
Endless Love Lionel Richie & Diana Ross
Fields Of Gold Sting
Fly Me To The Moon Frank Sinatra
Forever And Ever, Amen Randy Travis
Have You Ever Really Loved A Woman Bryan Adams
Heaven Bryan Adams
Here And Now Luther Vandross
Heroes David Bowie
How Sweet It Is (To Be Loved By You) James Taylor
I Get A Kick Out Of You Frank Sinatra
I Only Have Eyes For You The Flamingos
I Swear John Michael Montgomery
If Tomorrow Never Comes Joose
I'll Always Love You Taylor Dayne
In My Life Beatles
In This Life Collin Raye
In Your Eyes Peter Gabriel
It's Impossible Perry Como
I've Got A Crush On You Frank Sinatra with Barbra Streisand
I've Got You Under My Skin Frank Sinatra
Just In Time Dean Martin
Just The Way You Are Billy Joel
Lady Kenny Rogers
Let It Be Me Everly Brothers
Longer Dan Fogelberg
Love Song The Cure
Maybe I'm Amazed Paul McCartney
More Than I Can Say Leo Sayer
My Girl The Temptations
Night And Day Frank Sinatra
Only You The Platters
Save The Best For Last Vanessa Williams
She's Got A Way Billy Joel
Slave To Love Bryan Ferry
Someone To Watch Over Me Frank Sinatra
Sometimes When We Touch Dan Hill
Stand By Me Ben E. King
Strangers In The Night Frank Sinatra
Suddenly Billy Ocean
Summer Wind Frank Sinatra
Sweet Love Anita Baker
Take My Breath Away Berlin
(They Long To Be) Close To You The Carpenters
Time In A Bottle Jim Croce
Tonight I Celebrate My Love Roberta Flack & Peabo Bryson
True Spandau Ballet
True Companion Marc Cohn
Truly Lionel Richie
Unchained Melody The Righteous Brothers
Up Where We Belong Joe Cocker & Jennifer Warnes
The Way You Look Tonight Frank Sinatra
We Belong Pat Benatar
When A Man Loves A Woman Percy Sledge
When I Need You Leo Sayer
A Whole New World Peabo Bryson & Regina Belle
Woman John Lennon
Wonderful Tonight Eric Clapton
You Are So Beautiful Joe Crocker
You Are The Sunshine Of My Life Stevie Wonder
You Give Good Love Whitney Houston
You'd Be So Nice To Come Home To Julie London
Your Love Amazes Me John Berry
Your Song Elton John
You're In My Heart Rod Stewart
You're My Best Friend Queen
You've Got A Friend James Taylor
Grow Old With Me Mary Chapin Carpenter
Have I Told You Lately Van Morrison
Follow You, Follow Me Genesis
All My Life Linda Ronstadt & Aaron Neville
Everything I Do/ I Do It For You Bryan Adams
All I Ask Phantom Of The Opera
Always & Forever Heatwave
If You Say My Eyes Are Beautiful Jermaine Jackson & Whitney Houston
I've Finally Found Someone Barbra Streisand & Bryan Adams
Through The Eyes Of Love Melissa Manchester
Masterpiece Atlantic Starr
Ribbon In The Sky Stevie Wonder
When I Fall In Love Nat King Cole
After All Peter Cetera & Cher
Nothing's Gonna Change My Love For You George Benson
Just You & I Eddie Rabbit & Crystal Gayle
Always Atlantic Starr
It Had To Be You Harry Connick, Jr.
My One & Only Love John Coltrane
Till There Was You Van Craven
At Last Etta James
Soul Provider Michael Bolton
For You I Will Monica
Somebody Depeche Mode
Never Tear Us Apart Inxs
Love Is All Around Wet, Wet, Wet
Our Love Is Here To Stay Ella Fitzgerald
Forever Kiss
Love Of A Lifetime Firehouse
When I'm With You Sheriff
Valentine Jim Brickman & Martina Mcbride
When You Say Nothing At All Allison Krauss
I Knew I Loved You Savage Garden
Truly, Madly, Deeply Savage Garden
From This Moment Shania Twain
You're Still The One Shania Twain
When I Said I Do Clint Black
 
For more wedding-related music and ideas, go to:
www.weddingmusiccentral.com.
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