U tabeli deejay imam kolone id, name, biogrphy genre a u discogrphy imam disc_id (id svake pesme), Albums, Released, Label i did (id koji odgovara dj-u).
Kad se konektujem na bazu i odradim sve....ne ispisuje mi prvi unos pesme kod svakog dj...
znaci prva pesma kod svakog dj je zanemarena, ispis pochinje od druge.
Code:
<?php
$id=$_GET['id'];
$q="select deejay.*,discography.* from deejay,discography where discography.did='$id' AND id='$id'group by Albums order by Released";
$do=mysql_query("$q");
$row=mysql_fetch_array($do);
if($_GET['id']) {
print "<table width=\"450\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
print "<tr><td><font color=white>Name:</font></td></tr>";
print "<tr><td><font class=big>$row[Name]</font></td></tr>";
print "<tr><td><br><font color=white>Genre:</font></td></tr>";
print "<tr><td><font class=big>$row[Genre]</font></td></tr>";
print "<tr><td><br><font color=white>Biography:</font></td></tr>";
print "<tr><td><font class=tekst>$row[Biography]</font></td></tr>";
print "<tr><td><br><font color=white>Discography:</font><br></td></tr>";
while($row=mysql_fetch_array($do)){
print "<tr><td><font class=tekst color=#005C96>$row[Albums] - $row[Label] ($row[Released])</td></tr>";
}
print "<tr><td align=center><br><a href=\"addnew.php\" class=\"l\"> Add New Releases To Database</a> </td></tr>";
print "</table>";
} else {
print "<br><font class=big>Click On The Name From The List To See More Information About Deejay<br><br>.:: CLubbing Culture ::.";
}
?>
<?php
$id=$_GET['id'];
$q="select deejay.*,discography.* from deejay,discography where discography.did='$id' AND id='$id'group by Albums order by Released";
$do=mysql_query("$q");
$row=mysql_fetch_array($do);
if($_GET['id']) {
print "<table width=\"450\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
print "<tr><td><font color=white>Name:</font></td></tr>";
print "<tr><td><font class=big>$row[Name]</font></td></tr>";
print "<tr><td><br><font color=white>Genre:</font></td></tr>";
print "<tr><td><font class=big>$row[Genre]</font></td></tr>";
print "<tr><td><br><font color=white>Biography:</font></td></tr>";
print "<tr><td><font class=tekst>$row[Biography]</font></td></tr>";
print "<tr><td><br><font color=white>Discography:</font><br></td></tr>";
while($row=mysql_fetch_array($do)){
print "<tr><td><font class=tekst color=#005C96>$row[Albums] - $row[Label] ($row[Released])</td></tr>";
}
print "<tr><td align=center><br><a href=\"addnew.php\" class=\"l\"> Add New Releases To Database</a> </td></tr>";
print "</table>";
} else {
print "<br><font class=big>Click On The Name From The List To See More Information About Deejay<br><br>.:: CLubbing Culture ::.";
}
?>