to com esse scriptrodando com register_global on e quando mudo no servidor para off nao funciona, alguem poderia me ajudar
<html> <head> <style type="text/css" media="all"> @import url("css/musicas.css"); </style> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head> <? $anime = $_GET['anime']; include("conn.php"); $res = DBcadastro_connect(); if (!$res) { echo("Erro de conexão ".mysql_error()."\n"); } else { // Seleciona os cards por colecao em ordem alfabetica $sql = " select * from mp3 where anime = '$anime' order by data desc, titulo asc "; $sql_result = mysql_db_query("BANCO","$sql",$res) or die("Impossível consultar registros. ".mysql_error()); $total = mysql_num_rows($sql_result); if ($total!=0) { ?> <body bgcolor="#FFFFFF" link="a3602c" vlink="a3602c" alink="a3602c" leftmargin="0" topmargin="5" marginwidth="0" marginheight="0"> <br> <table width="470" border="0" cellpadding="0" cellspacing="1"> <tr bgcolor="#B56931"> <td width="140" bgcolor="#B56931"> <div align="center"><font face="Arial, Helvetica, sans-serif" size="2" color="fcca8f"><b>Titulo</b></font></div></td> <td width="90" bgcolor="#B56931"> <div align="center"><font face="Arial, Helvetica, sans-serif" size="2" color="fcca8f"><b>Autor</b></font></div></td> <td width="62"> <div align="center"><font face="Arial, Helvetica, sans-serif" size="2" color="fcca8f"><b>Tamanho</b></font></div></td> <td width="49"> <div align="center"><font face="Arial, Helvetica, sans-serif" size="2" color="fcca8f"><b>Tempo</b></font></div></td> <td width="53"> <div align="center"><font face="Arial, Helvetica, sans-serif" size="2" color="fcca8f"><b>Cliques</b></font></div></td> <td width="69"> <div align="center"><font face="Arial, Helvetica, sans-serif" size="2" color="fcca8f"><b>Download</b></font></div></td> </tr> <? while ($valor = mysql_fetch_array($sql_result)){ ?> <? $data_banco = $valor['data']; $data_atual = date("Y").'-'.date("m").'-'.date("d"); $basedata = strtotime($data_banco); $data1 = strtotime ("+ 3 days" , $basedata); $vencimento = date("Y-m-d", $data1); ?> <tr bgcolor="<? echo ($vencimento >= $data_atual ? "fcca8f" : "fde7d1");?>"> <td width="140" height="2"> <div align="center"><b><font face="Arial, Helvetica, sans-serif" size="2" color="a3602c"> <?echo $valor['titulo'];?></font></b></div></td> <td width="90" height="2"> <div align="center"><b><font color="a3602c"> <?echo $valor['autor'];?></font></b></div></td> <td width="62" height="2"> <div align="center"><b><font face="Arial, Helvetica, sans-serif" size="2" color="a3602c"> <?echo $valor['tamanho'];?></font></b></div></td> <td width="49" height="2"> <div align="center"><b><font face="Arial, Helvetica, sans-serif" size="2" color="a3602c"> <?echo $valor['tempo'];?></font></b></div></td> <td width="53" height="2"> <div align="center"><b><font face="Arial, Helvetica, sans-serif" size="2" color="a3602c"> <?echo $valor['downloads'];?></font></b></div></td> <td width="69" height="2"> <div align="center"><b><font face="Arial, Helvetica, sans-serif" size="2" color="a3602c"><a href=download.php?&idcliques=<?echo $valor['id'];?>>Baixe!</a></font></b></div></td> </tr> <? }//---End While ?> </table> <? }//---End if else { echo "<a href=index.php>Voltar</a>"; } } ?> </body> </html>
Quando coloco off e clico no link "BAIXE" aparece essa mensagem
isso Impossível consultar registros. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1