[Lionel]

Originally Posted by KirbyDE

PHP Code:

$DB_site->query("SELECT songid, title, url FROM soundtracks WHERE title IN ('$extra1', '$extra2', '$extra3') AND active=1"); 


?

That does not return the other items (url and songid).
This is a non Vb script where I cannot do a normal eval for a templatebit.
when I do:

PHP Code:

 $extra1songsquery = $DB_site->query("SELECT songid, title, url FROM soundtracks WHERE WHERE title IN ('$extra1', '$extra2', '$extra3') AND active=1");
 
while($extra1songrow = $DB_site->fetch_array($extra1songsquery)) 
        {    
         $clip1=$extra1songrow['title'];
    $clip1id=$extra1songrow['songid'];
    $clip1url=$extra1songrow['url'];
    $extra1="<a href=\"showproduct.php?product=$product&do=main&mysong=$clip1id\">$clip1</a>"; 
        } 


and put in template:

$extra1

only the first one is returned. The others have no results.

Originally Posted by Boofo

Can't you do a:

can't do that. It's the WHERE clause that is giving me a hard time. Too many WHERE