0
Hello!
Since today I am using the recently added module on my homepage (www.madonna.nl see on the left side).
It is showing the title and the year.
As you can see there is an empty space between the title and year.
There I want to have the format name from that title..
This is how my file looks (modules/mod_muscol_recently_added/tmp/default.php
What am I doing fron? Is '?album->format_name' not the right thing?
Since today I am using the recently added module on my homepage (www.madonna.nl see on the left side).
It is showing the title and the year.
As you can see there is an empty space between the title and year.
There I want to have the format name from that title..
This is how my file looks (modules/mod_muscol_recently_added/tmp/default.php
name; ?>
format_name; ?>
year;?>
What am I doing fron? Is '?album->format_name' not the right thing?
Responses (3)
-
Accepted Answer
-
Accepted Answer
0hello!!
sorry for the delay
you need to change a bit the MySQL query to do this.
I tell you how to do it, but please do it only if you know what you're doing!!
the current query is:
$query = ' SELECT al.*,ar.artist_name FROM #__muscol_albums AS al '.
' LEFT JOIN #__muscol_format AS f ON f.id = al.format_id '.
' LEFT JOIN #__muscol_artists AS ar ON ar.id = al.artist_id '.
$where_clause .
' ORDER BY al.added DESC '.
' LIMIT '. $limit;
(its on the HELPER.PHP file, line 41 approx)
you need to replace ask for the format name, too, like this:
$query = ' SELECT al.*,ar.artist_name, f.format_name FROM #__muscol_albums AS al '.
' LEFT JOIN #__muscol_format AS f ON f.id = al.format_id '.
' LEFT JOIN #__muscol_artists AS ar ON ar.id = al.artist_id '.
$where_clause .
' ORDER BY al.added DESC '.
' LIMIT '. $limit;
and then you'll be able to print this value
you know what I mean? -
Accepted Answer
Your Reply
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »