Please Log in to join the conversation.
SELECT `username` FROM `#__users`
<div>[column_username]</div>
Please Log in to join the conversation.
krileon wrote:
We can't really help you with debugging custom queries on non-CB and non-Joomla tables as we've no mean of testing and confirming your query (we are not going to setup custom tables to match your environment, sorry). The below for example works fine.
SET @bil=0;
SELECT @bil:=@bil +1 as bil, cb_companyname as companyname, cb_address01 as add01, cb_address02 as add02, cb_postcode as pcode, cb_city as city, cb_state as state, cb_record as record
FROM `myprefix_comprofiler`
WHERE cb_companyname='[cb_companyname]' AND cb_record='Active'
ORDER BY cb_companyname ASC
SET @bil=0;
SELECT @bil:=@bil +1 as bil
Please Log in to join the conversation.
Please Log in to join the conversation.