Location: PHPKode > projects > Music and Discography Database > music_db/db.php
<?
require("common_funcs.php");
connectSQL();
query("SELECT album_id, musicans_id FROM album, musicans WHERE musicans_id=ANY(musicans)");
$t = $nur;
for($i=0;$i<$t;$i++) {
    $r = next_row();
    #sqlcmd("INSERT INTO nexus (albumid,musid) VALUES ($r[0],$r[1])");
    #print  "INSERT INTO nexus (albumid,musid) VALUES ($r[0],$r[1]);";
}
query("SELECT album_id FROM album WHERE musicans='{}'");
$t = $nur;
for($i=0;$i<$t;$i++) {
    $r = next_row();
    #sqlcmd("INSERT INTO nexus (albumid) VALUES ($r[0])");
    #print "INSERT INTO nexus (albumid) VALUES ($r[0]);";
}
closeSQL();
?>
Return current item: Music and Discography Database