Thank you

I got that far, and that's where I got stuck.

I don't know how "SELECT SQL" works

My database is called hardcorewillneverdie

It's got 3 tables - archive, mixes and flyer

archive has 7 rows (artist, title, label, cat, year, scan, play)

Do I enter a query for each row? or is it simply

SELECT * from archive

You can enter the next query:



PS: is "archive" table located in Joomla! database?

Regards,
ARI Soft

No, the database is held on my server with powweb

In this case set "SQL -> Choose DB type" parameter to "External database" and enter connection parameters in "SQL -> Choose DB type -> External database" parameters section. If something doesn't work, set "SQL -> Debug" parameter to "Yes" to investigate a problem.

Regards,
ARI Soft

Progress

1. The request SELECT * FROM archive throws up the following error message

Fatal error: Allowed memory size of 18874368 bytes exhausted (tried to allocate 2343789 bytes) in /hermes/waloraweb063/b468/pow.cfavager/htdocs/joomla/plugins/system/sef/sef.php on line 34

archive contains 2,800+ entries - is this what's causing the problem, if so, can I fix it?

2. The request SELECT * FROM mixes does work (only 1,100 entries here) and the Data Table works too

The only issue here is some of the data needs to be displayed as acitve links. Eg

h**p://hardcorewillneverdie2.com/mixes/newDD/MF_Topbuzz_Eclipse.ram should be Side One

1. Try to use "PHP Settings" plugin to increase value of "memory_limit" PHP option.

2. Are links stored in a database or you want to generate links based on data from database?

Regards,
ARI Soft