croys

enta assim oh:

$sql_album = mysql_query("SELECT * FROM album WHERE album_bandas_id = '$banda_id'");
while($a = mysql_fetch_array($sql_album)){
echo "<b>$a[album_nome] / $a[album_ano]<b>"
$sql_letra = mysql_query("SELECT * FROM letras WHERE letras_album_id = '$a[album_id]'");
while($l = mysql_fetch_array($sql_letra)){
echo "
<a href=\"index.php?rockland=letras&mletra=$l[letras_id]&id=$banda_id\">$l[letras_nome]</a><br>";
}}

Croys

<!-- #include file="config.asp" -->

<% 

Dim conn,query



path = Request.ServerVariables("Path_Translated")

since = Date()



Set conn = Server.CreateObject("ADODB.Connection")

conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & database & ""



Set query = conn.Execute("SELECT * FROM counter WHERE path='" & path & "'")



If query.EOF Then

conn.Execute("INSERT INTO counter (path,visits,since) VALUES ('" & path & "',1,'" & since & "')")

End If



If Not query.EOF Then

visits = cInt(query("visits"))+1

since = query("since")

Else 

visits = 1

since = date()

End If



If showcounter = "since" Then

Response.Write "<b>" & visits & "</b> visitors since " & since

ElseIf showcounter = "no" Then

Response.Write " "

Else

Response.Write visits

End If



'******** Session pra nao contar d novo *************

If not Session("Contador") = 1 Then

conn.Execute("UPDATE counter SET visits='" & visits & "' WHERE path = '" & path & "'")

Session("Contador") = 1

End if

'************************************************



conn.close

Set conn = Nothing

Set query = Nothing

%>

tenta:

sql = "UPDATE enquete SET liberado='"&liberar&"' WHERE idenquete="& id

ah, sei la... essas perguntas repetidas, geralmente ja estao respondidas em algum lugar, eh falta de procurar mesmo...

tutoriais basico, tao cheio na net, coisas mais especificas sao mais dificeis de se achar...

Croys

estou esperando com ansiedade...