Cod: Selectaţi tot
<META name="rating" content="General">
<META name="language" content="english, EN">
<META name="distribution" content="Global">
<META name="robots" content="INDEX,FOLLOW">
<META name="revisit-after" content="1 Day">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<style type="text/css">
a:link {color:#1E6E9C; text-decoration:none}
a:visited {color:#1E6E9C; text-decoration:none}
a:hover {color:#000000}
</style>
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body bgcolor="#ffffff" topmargin="0" background="bg.png">
<table align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="padding-bottom: 10px;">
<tr>
<td valign="top" align="center">
<table vspace="0" width="760" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td valign="top">
<?php
include("header.html");
?>
</td>
</tr>
</table>
<br />
<table width="750">
<tr>
<td width="750">
<?php include('content_up_index.html') ?>
</td>
</tr>
</table>
<table width="100%" cellpadding="0" cellspacing="0" height="25">
<tr>
<td background="http://music-master.org/pic/styles/new/images/colhead.png" align="left" height="25">
<font color="#ffffff" size="2"><b><center>Ultimele 30 de melodii adaugate pe site</center></b></font>
</td>
</tr>
</table>
<?php
echo '<table width="100%" cellpadding="1" cellspacing="1">';
echo '<tr>
<td align="center" width="35" height="20" bgcolor="#7D0552">
<font color="#ffffff" size="1"><b>Nr.</b></font>
</td>
<td align="left" width="570" height="20" bgcolor="#7D0552">
<font color="#ffffff" size="1"><b>Numele melodiei</b></font>
</td>
<td width="120" height="20" align="center" bgcolor="#7D0552">
<font color="#ffffff" size="1"><b>Data adaugarii</b></font>
</td>
<td align="center" width="35" height="20" bgcolor="#7D0552">
<font color="#ffffff" size="1"><b>Hits</b></font>
</td>
</tr> ';
$conn = mysql_connect("localhost", "stiumuzicaa", "stiumuzicaa")
or die("Unable to connect to MySQL");
$selectdb = mysql_select_db('stiumuzicaa');
$interogare = "SELECT `titlu`, `hits` FROM `melodie`";
$rezultat = mysql_query($interogare);
if (mysql_errno()) {
echo "<br />". mysql_errno(). " : ". mysql_error(). "<br />";
}
$nr_campuri = mysql_num_fields($rezultat);
if (mysql_num_rows($rezultat) == 0) {
echo '0 rezultate';
}
else {
while ($rand = mysql_fetch_assoc($rezultat)) {
echo '<tr>
<td align="center" width="35" height="20" bgcolor="#7D0552">
<font color="#FDEEF4" size="1"><b></b></font>
</td>
<td align="left" width="430" height="20" bgcolor="#7D0552">
<font size="1"><b><a class="link_mel" href="'.$rand['link'].'">'.$rand['titlu'].'</a></b></font>
</td>
<td width="140" height="20" align="center" bgcolor="#7D0552">
<font color="#FDEEF4" size="1"><b>'.$rand['data_ad'].'<font color="#f59518"></font></b></font>
</td>
<td align="center" width="35" height="20" bgcolor="#7D0552">
<font color="#FDEEF4" size="1"><b>'.$rand['hits'].'</b></font>
</td>
</tr>
';
echo '</table>';
echo '<br>';
}
}
?>
<table width="100%" cellpadding="0" cellspacing="0" height="25">
<tr>
<bhr>
</td>
</tr>
</table>
<table style="border:1px solid #7D0552" width="922">
<tr>
<td width="750">
<?php
include("content_down_index.html");
?>
</td>
</tr>
</table>
</td>
<?php
include("footer.html");
?>
</body>
</html>Aici e imaginea
Cum pot sa fac sa arate in tabel toate melodiile ???pls help, thxx
