Forgot to say in need newest album at the top

what you mean the "all album picture page"...? which page is that?

Sorry for the bad explanation, probably easier to just give you the link. At the moment the albums are showing in order of upload, is it possible to change the order to that of the album date created with latest album in first position…..many thanks

http://markhandley.rocks/index.php?option=com_muscol&view=artists&layout=detailed&Itemid=319

oh ok. well you would need to open file /components/com_muscol/models/artist.php and, about line 118, you would need to add your own ORDER BY clause.

Can I please get a little help sorting this out as I am still very new to code, I am building the site for a friend and we are trying to get it finished by the weekend.

If you are too busy to help could you please at least show us how to get the latest album uploaded into first position and oldest uploaded into last position. At least that way we can re-upload in correct order.

Many thanks

Just in case you can help... line 118

function getRelated(){

if (empty( $this->_related )) {
//busquem primer els related creuats
$query = ' SELECT id '.
' FROM #__muscol_artists '.
' WHERE related LIKE "%,'.$this->_data->id.',%"'.
' OR related LIKE "'.$this->_data->id.',%"'.
' OR related LIKE "%,'.$this->_data->id.'"'.
' OR related LIKE "'.$this->_data->id.'"'
;
$this->_db->setQuery( $query );
$cross_related = $this->_db->loadResultArray();

$related = explode(",",$this->_data->related);
if($related[0] == "") $related = array();

for($i = 0; $i < count($cross_related); $i++){
$related[] = $cross_related[$i];
}
$related = array_unique($related);
//print_r($related);die();
$array_related = array();
foreach($related as $index => $valor){
$query = ' SELECT id,artist_name '.
' FROM #__muscol_artists '.
' WHERE id = '.$valor.
' LIMIT 1 ';
$this->_db->setQuery( $query );
$array_related[] = $this->_db->loadObject();
}
$this->_related = $array_related;
$this->_related_ids = $related;
}
return $this->_related;

sorry I misspelled the file you need to edit, it's:

/components/com_muscol/models/artists.php

(notice it's ARTISTS, with an S at the end, not ARTIST)

that's the one, in line 118.

Ok i found it and changed it to 'ORDER BY al.year DESC' this has done what was required, but is this the correct way?
Many thanks

mark handley, which plugin you are using to view youtube videos in articles?