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
Edição feita por: wildbrn, 05/03/2006, 22:54.
