call list of albums in a category

[fangweile]

Hello there,

i am trying to create a custom page to display all albums in specific category in text link only.
for example

category 1                     category 2                        category 3
--> album 1 here            ---> album 1 here               ---> album 1 here 
--> album 2 here            ---> album 2 here               ---> album 2 here 
--> .....                        --->...                              ---> album ....

I used this code earlier and I manually listing all albums in a category. And it really take me a hard time doing it manually.

Code Select Expand

<?php
define('IN_COPPERMINE', true);
require('include/init.inc.php');
pageheader('Album List (A-Z)');
starttable('Welcome');
?>
<div>
Album List Content here
</div>
<?php
endtable();
pagefooter();
ob_end_flush();
?>

I have attached the screenshot how the list is being displayed..

[Αndré]

Do you know your way around with SQL? It's done with some quite easy SELECT queries.

[fangweile]

i am not that adept with sql and php coding and only knows some basic html coding. I am still learning about it and i think its getting me crazy lol   

[Αndré]

Use a code like

Code Select Expand

$result = cpg_db_query("SELECT aid, title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category = 13");
$rowset = cpg_db_fetch_rowset($result);
mysql_free_result($result);
foreach ($rowset as $album) {
    echo '<a href="thumbnails.php?album='.$album['aid'].'">'.$album['title'].'</a><br />';
}
for each category list.

[fangweile]

Thanks a lot Αndré  , it works really great.

[Αndré]

Then please:

tag your answer as "solved" by clicking on the "Topic Solved" button on the bar at the left hand side at the bottom of your thread.