Pal скрипт (Страница 1 из 2)

 $db->open("SELECT * FROM songlist WHERE artist = '". $song["artist"]."' OR genre = '".$song["genre"]."' ");

while($song = $db->row()){
echo $song["artist"]; 
echo "тратата";
echo $song["title"];
}

function PutSongRow(&$song) 
{
 global $rc, $showpic, $darkrow, $lightrow, $showSiteRow, $showBuyRow;
 PrepareSong($song);
 
 $rc++;
 $bgcolor = $darkrow;
 if(($rc % 2)==0) $bgcolor = $lightrow;
 
?> 
 <tr bgcolor="<? echo $bgcolor; ?>">
    <td align="left" colspan="5">
<font size="3" color="#003366"><small><a href="/song=<? echo $song["songid"]; ?>" title='Информация о треке <? echo $song["combine"]; ?> скачать бесплатно и без регистрации'><? 
      echo $song["combine"];  
      ?></a></small></font></td>
<?
}//PutSongRow

/* ## ===================================================================== ## */
?>
<?
 require("config.php");
 $db->open("SELECT * FROM songlist  WHERE ID = $songid AND (songtype='S' OR songtype='V' OR songtype='C') AND (status=0)");
 $song = $db->row();
 $db->open("SELECT * FROM songlist WHERE artist = '". $song["artist"]."' OR genre = '".$song["genre"]."'AND (songtype='S' OR songtype='V' OR songtype='C') AND (status=0) ORDER BY RAND() LIMIT 7 ");
 PrepareSong($song);
?>

  <tr bgcolor="#002E5B">
    <td align="right" colspan="5" align="center" height="20" background="images/wmenu.gif">
      <p align="center"><font color="#FFFFFF" size="2"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Тебе это понравится!</font></b></font>
    </td>
  </tr>
    <?PHP
    $rc=0;
while($song = $db->row()){
echo $song["artist"]; 
echo "-";
echo $song["title"];
PutSongRow($song);
}
?>

 $db->open("SELECT * FROM songlist  WHERE songtype='S' OR songtype='C' AND status=0 AND artist = '". $song["artist"]."' AND genre = '".$song["genre"]."' ORDER BY rand() LIMIT 10 ");