Welcome Guest ( Log In | Register )










Reply to this topicStart new topicStart Poll

> New Music Search!
CelticRadio 
Posted: 03-Feb-2004, 08:52 PM
Quote Post

Member is Offline



Celtic Guardian
Group Icon

Group: Administrator
Posts: 9,748
Joined: 23-Sep-2001
ZodiacOak

Realm: Toronto, CAN

male

Medieval Kingdom
Rank #74
222,391 Gold!






Check out our request page and our database of almost 4,000 songs. We now have a new search engine that makes it a snap to locate songs by Artist, Song or Album! Search for all or limit your search to an exact phrase.

We received many requests for this feature, so again we are glad that we have provided a new service suggested by our listeners!

http://www.celticradio.net/php/playlist.php

Enjoy!


--------------------
Celtic Radio DJ
http://www.CelticRadio.net
Celtic Radio Music Network
PMEmail PosterUsers Website My Photo Album               View my Facebook Profile.View my Linked-In Profile.View my Google plus Profile.View my Twitter Profile.View My Space Profile.View my YouTube Profile.
Top
hammerharper 
Posted: 04-Feb-2004, 02:13 PM
Quote Post

Member is Offline



Peasant
*

Group: Celtic Nation
Posts: 1
Joined: 10-Nov-2003
ZodiacWillow


male





Greetings,
I appreciate the search, and have used it. However, if I get more than one page of results, I cannot go the the second page. When I click Next>> I get the following:

status=err
SQL error=1064
SQL error string=You have an error in your SQL syntax near ') ' at line 1
SQL=SELECT count(*) as cnt FROM songlist WHERE (songtype='S') AND (status=0) AND ()

Just thought you should know.

Michael
PMEmail Poster               
Top
MacErca 
Posted: 04-Feb-2004, 03:35 PM
Quote Post

Member is Offline



Celtic Guardian
********

Group: Celtic Nation
Posts: 312
Joined: 03-Oct-2003
ZodiacHazel

Realm: Houston, Texas

male





Mac tried it ,and it looks great, kudos to you. thumbs_up.gif thumbs_up.gif


--------------------
"Cuimhnich air na daoine o'n d'thaining thu"
Remember the men from whom you are descended.


I am Wolf.
It is my cry you hear in the night,
My eyes that gaze at you from the shadows.
It is my heart that beats in your Soul,
My strength that makes you whole.
I am Wolf. I am in you.
You are in Me. We Are Wolf.
PMEmail PosterMy Photo Album               
Top
CelticRadio 
Posted: 04-Feb-2004, 05:48 PM
Quote Post

Member is Offline



Celtic Guardian
Group Icon

Group: Administrator
Posts: 9,748
Joined: 23-Sep-2001
ZodiacOak

Realm: Toronto, CAN

male

Medieval Kingdom
Rank #74
222,391 Gold!






QUOTE (hammerharper @ Feb 4 2004, 04:13 PM)
Greetings,
I appreciate the search, and have used it. However, if I get more than one page of results, I cannot go the the second page. When I click Next>> I get the following:

status=err
SQL error=1064
SQL error string=You have an error in your SQL syntax near ') ' at line 1
SQL=SELECT count(*) as cnt FROM songlist WHERE (songtype='S') AND (status=0) AND ()

Just thought you should know.

Michael

Oooo...you found a bug!!! I am on it! Somebody get me the RAID!!!!!!!!!!!
PMEmail PosterUsers Website My Photo Album               View my Facebook Profile.View my Linked-In Profile.View my Google plus Profile.View my Twitter Profile.View My Space Profile.View my YouTube Profile.
Top
maggiemahone1 
Posted: 04-Feb-2004, 05:59 PM
Quote Post

Member is Offline





High Queen of Ireland
********

Group: Celtic Nation
Posts: 3,596
Joined: 03-Jan-2002
ZodiacIvy

Realm: Southern West Virginia

female





QUOTE (hammerharper @ Feb 4 2004, 08:13 PM)
Greetings,
I appreciate the search, and have used it. However, if I get more than one page of results, I cannot go the the second page. When I click Next>> I get the following:

status=err
SQL error=1064
SQL error string=You have an error in your SQL syntax near ') ' at line 1
SQL=SELECT count(*) as cnt FROM songlist WHERE (songtype='S') AND (status=0) AND ()

Just thought you should know.

Michael

I had the same problem. I never did find my song. sad.gif The Fields of Athenny Does anyone know who sings it? Thank ya kindly!!!

maggiemahone1
PMEmail Poster                View My Space Profile.
Top
CelticRadio 
Posted: 04-Feb-2004, 06:19 PM
Quote Post

Member is Offline



Celtic Guardian
Group Icon

Group: Administrator
Posts: 9,748
Joined: 23-Sep-2001
ZodiacOak

Realm: Toronto, CAN

male

Medieval Kingdom
Rank #74
222,391 Gold!






QUOTE (maggiemahone1 @ Feb 4 2004, 07:59 PM)
I had the same problem. I never did find my song. sad.gif The Fields of Athenny Does anyone know who sings it? Thank ya kindly!!!

maggiemahone1

I am glad that you are all of the forgiving type! And here I thought my super smart search engine was perfect!!!

Actually, this really helped me understand how to create webpages that querry the database and give the results on mult-pages. This will help me when I create the musician database.

The bug has been found and fix. Maggie, select a 'song' search, then type in 'Fields of' then click on exact search. You will see all of the songs that start with this prefix.

Ok, any more bugs you can take me out back and shoot me!! tongue.gif
PMEmail PosterUsers Website My Photo Album               View my Facebook Profile.View my Linked-In Profile.View my Google plus Profile.View my Twitter Profile.View My Space Profile.View my YouTube Profile.
Top
maggiemahone1 
Posted: 04-Feb-2004, 07:23 PM
Quote Post

Member is Offline





High Queen of Ireland
********

Group: Celtic Nation
Posts: 3,596
Joined: 03-Jan-2002
ZodiacIvy

Realm: Southern West Virginia

female





clap.gif It works! clap.gif

maggiemahone1
PMEmail Poster                View My Space Profile.
Top
Aaediwen 
Posted: 04-Feb-2004, 07:53 PM
Quote Post

Member is Offline



Celtic Guardian
Group Icon

Group: Super Moderator
Posts: 3,069
Joined: 09-Oct-2003
ZodiacHolly

Realm: Kentucky

male





Maggie: it's a traditional song. I like Hollie Smith's rendition the best of any I've heard so far. It's on Light From a Distant Shore


--------------------
Poet and seeker of knowledge



PMEmail Poster My Photo Album               
Top
TheCarolinaScotsman 
Posted: 07-Feb-2004, 09:12 PM
Quote Post

Member is Offline



Celtic Guardian
********

Group: Celtic Nation
Posts: 2,509
Joined: 13-Jun-2003
ZodiacBirch

Realm: North Carolina

male

Medieval Kingdom
Rank #76
43,035 Gold!






QUOTE (Macfive @ Feb 4 2004, 07:19 PM)
Maggie, select a 'song' search, then type in 'Fields of' then click on exact search. You will see all of the songs that start with this prefix.

tongue.gif

Actually you get more accurate results if you just put in "Athenry". About six versions of this song come up.

Bill



--------------------
TheCarolinaScotsman


Ya'll drive safe and come back soon.
PMEmail PosterMy Photo Album               
Top
0 User(s) are reading this topic (0 Guests and 0 Anonymous Users)
0 Members:

Reply to this topic Quick ReplyStart new topicStart Poll


 








© Celtic Radio Network
Celtic Radio is a TorontoCast radio station that is based in Canada.
TorontoCast provides music license coverage through SOCAN.
All rights and trademarks reserved. Read our Privacy Policy.








[Home] [Top]