How to Obtain the Second Distinct Highest Record using SQL?
Question: Write a SQL query to get the second highest salary (distinct) from the Employee table. +----+--------+ | Id | Salary | +----+--------+ | 1 | 100 | | …
Category: sql
How to Display Blog Statistics at the Page Footer?
October 31, 2014
code, implementation, php, programming languages, sql, web programming, wordpress
No Comments
Almost every wordpress theme has a footer.php file that contains the layout for the page footer. You can insert the following PHP+MySQL code to display some statistics of the …
How to Create a WordPress Page that Shows Comment Statistics?
October 18, 2014
beginner, code, database, implementation, php, programming languages, sql, web programming
No Comments
WordPress is based on PHP and MySQL. So it is very flexible and powerful. This article will guide you how to create a page that shows the comment statistics …
How to Get the list of emails from the WordPress Comments?
Suppose you have a wordpress blog and you want to send a email to say ‘thank you’ to all the people who left good comments (you approved them). You …
How to Create a Ranking Page in WordPress Based On GD Star Rating Plugin?
October 10, 2014
implementation, php, programming languages, sql, web programming, webhosting, wordpress
No Comments
The GD Star Rating Plugin is a famous plugin that allows readers (without login or registration) to give scores to articles, posts, pages and even comments. Therefore, it might …