|
|
<%
Set db=Server.CreateObject("ADODB.Connection")
db.open "DRIVER={MySQL ODBC 3.51 Driver};Server=localhost;Database=redlightningrecords;UID=redlightning;PWD=mmPScwbr;OPTION=3;"
set rs1=server.createObject("ADODB.Recordset")
rs1.open "select * from artists WHERE id='" & request("id") & "'", db
if NOT rs1.eof then
%>
<%=rs1("artist")%> <%=rs1("description")%>  |
|
Albums
<%
rs2.movenext
loop
else
response.write "No albums found for this artist."
end if
rs2.close
set rs2=nothing
%>
<%
else
response.write "The requested artist was not found in the database. Please check the URL and try again."
end if
rs1.close
db.close
set db=nothing
%>Kahnawake
|
<%
set rs2=server.createObject("ADODB.Recordset")
rs2.open "select * from albums WHERE artistid='" & request("id") & "'", db
if NOT rs2.eof then
do while NOT rs2.eof
%>
"> " border="1">
"><%=rs2("title")%>
 |
|
World Singing "Northern Style"
Champions, Battle River have been winning contest Pow Wow's all over Canada and
the USA. Another high-caliber group from Red Lake, Minnesota (home of Eyabay and
Kingbird Singers), Battle River have been making their mark on the Pow Wow Trail
with their unique and powerful style of singing. Best known for their "Straight"
Songs, Battle River is blending a traditional style with a contemporary approach.
This long awaited release "Couple for the Road" contains 11 of Battle
River's newest songs.
Singers:
Mack Kingbird - Keveon Kingbird - Kevin Kingbird
- Don Kingbird - Gerald Kingbird - Mike Thunder - Mike Roy - Jon Prentice - Bob
Barrett - Pibbs Baker - Elliot Cloud - Terry Sengoles - Justin Smith - Frank Graves
- Greg Thomas - Monica Prentice - Cecil Nepoose - Willy Strong
|
|
|
|
The
songs
01. Straight
02. Fish Box
03. Intertribal
04. Grassdance
05. Straight
06. Intertribal
07. Straight
08. Grassdance
09. CB's
10. Devin's Boogie
11. Little Shell |