Sorry if I put my question here, but I haven't seen where to post ...
I have written a little fonction to call the last albums on my main page (I have dropped CpmFetch :))
Quote
<?php
$conn = mysql_Connect('localhost','xxxx','xxxx');
mysql_select_db('rbn.cpg11d_albums',$conn);
$sql = 'select aid, title from rbn.cpg11d_albums order by aid desc limit 0, 50';
$req = mysql_query($sql);
while($data = mysql_fetch_assoc($req))
{
echo '<a href="http://www.sortons.net/photos/thumbnails.php?album='.$data['aid'].'" onMouseover="ddrivetip(\'Test\', 400)"; onMouseout="hideddrivetip()">'.$data['title'].'</a><br /> ';
}
?>
I would like to exclude the last MEMBERS albums ... I don't know to do this, in php ... (I begin !)
Add a restriction so that the album's category is less than 10000
héhéhé ... yes yes ... but I BEGIN I don't know how to ... otherwise I don't post here :)
$sql = 'select aid, title from rbn.cpg11d_albums WHERE category < 10000 order by aid desc limit 0, 50';
THANX THANX THANX !
http://www.sortons.net/test-nucleus.html
It works perfectly :)