Hello, I have a very simple need but I haven't had to do any SQL work in years so I am very out of practice. I have a field in my Joomla database called "fgfg_akeebasubs_customfields"
where I want to only display a user's value that is stored in id 16.

This is what I want to do:

SELECT *
FROM `sdcv_akeebasubs_customfields`
WHERE `akeebasubs_customfield_id` = '16'

but it doesn't seem to work when I enter it into the SQL query window. Can you tell me what I need to do? Thank you.

Hello,

Try the following SQL query:

SELECT *
FROM `#__akeebasubs_customfields`
WHERE `akeebasubs_customfield_id` = '16'

If it doesn't help could you send an SQL dump for akeebasubs_customfields table by email?

Regards,
ARI Soft