- Details
- Written by: Stanko Milosev
- Category: MySQL
- Hits: 6095
Question is, how to get count records in union query?
For example, we have this query:
select count(*) from hdxbh_content
union all
select count(*) from jos_users
As a result, we will have two records:
count(*) |
---|
904ĂÂ |
1ĂÂ |
And we want to get result as one record, 905, how?
Like this:
select ((select count(*) from hdxbh_content) + (select count(*) from jos_users)) count
Taken from here.
- Details
- Written by: Stanko Milosev
- Category: HeidiSQL
- Hits: 5614
When I tried to export database with UTF8 characters in one big file, and then open it in the UltraEdit, I received strange characters like:
ĂŤ
Instead of letter:
Ä
Solution is to change the font, like it is describe it here, and then open it with UltraEdit but where you will choose:
Format: 1250
Open as: UTF-8
Same is when you are opening the file from HeidiSQL.
- Details
- Written by: Stanko Milosev
- Category: Joomla
- Hits: 4545
If you are receiving message like:
PHP Strict Standards: Declaration of ContentModelCategories::populateState() should be compatible with JModel::populateState() in \components\com_content\models\categories.php on line 19
Then in you PHP ini should be:
error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED
and restart your iis
- Details
- Written by: Stanko Milosev
- Category: Extensions
- Hits: 4767
Finally I've found how to put xml or html tags in the CodeHighlighter. Post has to be escaped,
So convert ">" into ">", "<" into "<" and so on...
I have found also good online tool with which this is much easier to achieve:
http://www.freeformatter.com/xml-escape.html#ad-output
If I am writing Joomla! article without any text editor and if I want to show ";gt;", then I should write it like "&gt;" :)