[ diyabolic @ 31.01.2005. 15:25 ] @
| Ovako imam bazu rel_dj i u njoj 2 tabele deejay i discography. 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 ::."; } ?> |