ÿþ<input type="submit" value="Inserir novo Banner" name="submit" onClick='javascript: window.open("insere.php","","width=450,heigth=100,toolbar=no");'>

<?php

include("config.php");



$conn = mysql_connect($host, $user, $pass);

mysql_select_db($database);



if (isset($submit)) {

$delete = "DELETE FROM banner WHERE codigo = $id";

mysql_query($delete, $conn);

}



$query = "SELECT * FROM banner ORDER by codigo ASC";

$consulta = mysql_query($query, $conn);



while ($linha = mysql_fetch_row($consulta)) {

?>

<p> </p>

<table border="1" bordercolor="#000000" cellspacing="0" cellpadding="0">

<tr>

<td width="100%">

<p align="left">Código : <?php echo $linha[0]; ?>

<p>Link : <a href="<?php echo $linha[1]; ?>"><?php echo $linha[1]; ?> </a></p>

<p>Imagem :<img border="0" src="<?php echo $linha[2]; ?>" width="468" height="60"></p>

<p>Exibições :<?php echo $linha[3]; ?></p>

<p>Clicks :<?php echo $linha[4]; ?> </p>

<p>Porcentagem(Clicks por exibições) : 

<?php echo round(($linha[4]/$linha[3])*100,2); ?>%</p>

Data de criação :<?php echo $linha[6]; ?>

<p>Status :<?php if ($linha[5] != 0) { ?>Ativo<?php } else { ?>Inativo<?php } ?></p>

<form method="POST" action="admin.php?id=<?php echo $linha[0]; ?>">

<center>

<input type="submit" value="Remover" name="submit">

</center>

</form>

</td>

</tr>

</table>

<?php

}

mysql_close($conn);

?>