Advertisement
-
Google's PageRank : Explained and how to make the most of it
What is PageRank?
PageRank is a numeric value that represents how important a page is on the web. Google figures that when one page links to another page, it is effectively casting a vote for the other page. The more votes that are cast for a page, the more important the page must be. Also, the importance of the page that is casting the vote determines how important the vote itself is. Google calculates a page's importance from the votes cast for it. How important each vote is is taken into account when a page's PageRank is calculated.
PageRank is Google's way of deciding a page's importance. It matters because it is one of the factors that determines a page's ranking in the search results. It isn't the only factor that Google uses to rank pages, but it is an important one.From here on in, we'll occasionally refer to PageRank as "PR".
How is PageRank calculated?
PR(A) = (1-d) + d(PR(t1)/C(t1) + ... + PR(tn)/C(tn))
We can think of it in a simpler way:-
a page's PageRank = 0.15 + 0.85 * (a "share" of the PageRank of every page that links to it)
"share" = the linking page's PageRank divided by the number of outbound links on the page.
Ok so far? Good. Now we'll look at how the calculations are actually done.
Step 1: Calculate page A's PageRank from the value of its inbound links
Step 2: Calculate page B's PageRank from the value of its inbound links
1. They quote the same, published equation - but then change it
from PR(A) = (1-d) + d(......) to PR(A) = PR(A) + (1-d) + d(......)
It isn't correct, and it isn't necessary.
What can we do with this 'overall' PageRank?
For the examples, we are going to ignore that fact, mainly because other 'Pagerank Explained' type documents ignore it in the calculations, and it might be confusing when comparing documents. The calculator operates in two modes:- Simple and Real. In Simple mode, the calculations assume that all pages are in the Google index, whether or not any other pages link to them. In Real mode the calculations disregard unlinked-to pages. These examples show the results as calculated in Simple mode.
Let's consider a 3 page site (pages A, B and C) with no links coming in from the outside. We will allocate each page an initial PageRank of 1, although it makes no difference whether we start each page with 1, 0 or 99. Apart from a few millionths of a PageRank point, after many iterations the end result is always the same. Starting with 1 requires fewer iterations for the PageRanks to converge to a suitable result than when starting with 0 or any other number. You may want to use a pencil and paper to follow this or you can follow it with the calculator.
The site's maximum PageRank is the amount of PageRank in the site. In this case, we have 3 pages so the site's maximum is 3.
At the moment, none of the pages link to any other pages and none link to them. If you make the calculation once for each page, you'll find that each of them ends up with a PageRank of 0.15. No matter how many iterations you run, each page's PageRank remains at 0.15. The total PageRank in the site = 0.45, whereas it could be 3. The site is seriously wasting most of its potential PageRank.
Example 1Now begin again with each page being allocated PR1. Link page A to page B and run the calculations for each page. We end up with:-
Page A = 0.15
Page B = 1
Page C = 0.15Page A has "voted" for page B and, as a result, page B's PageRank has increased. This is looking good for page B, but it's only 1 iteration - we haven't taken account of the Catch 22 situation. Look at what happens to the figures after more iterations:-
After 100 iterations the figures are:-
Page A = 0.15
Page B = 0.2775
Page C = 0.15It still looks good for page B but nowhere near as good as it did. These figures are more realistic. The total PageRank in the site is now 0.5775 - slightly better but still only a fraction of what it could be.
NOTE:
Technically, these particular results are incorrect because of the special treatment that Google gives to dangling links, but they serve to demonstrate the simple calculation.
Example 2Try this linkage. Link all pages to all pages. Each page starts with PR1 again. This produces:-
Page A = 1
Page B = 1
Page C = 1Now we've achieved the maximum. No matter how many iterations are run, each page always ends up with PR1. The same results occur by linking in a loop. E.g. A to B, B to C and C to D. View this in the calculator.
This has demonstrated that, by poor linking, it is quite easy to waste PageRank and by good linking, we can achieve a site's full potential. But we don't particularly want all the site's pages to have an equal share. We want one or more pages to have a larger share at the expense of others. The kinds of pages that we might want to have the larger shares are the index page, hub pages and pages that are optimized for certain search terms. We have only 3 pages, so we'll channel the PageRank to the index page - page A. It will serve to show the idea of channeling.
Example 3Now try this. Link page A to both B and C. Also link pages B and C to A. Starting with PR1 all round, after 1 iteration the results are:-
Page A = 1.85
Page B = 0.575
Page C = 0.575and after 100 iterations, the results are:-
Page A = 1.459459
Page B = 0.7702703
Page C = 0.7702703In both cases the total PageRank in the site is 3 (the maximum) so none is being wasted. Also in both cases you can see that page A has a much larger proportion of the PageRank than the other 2 pages. This is because pages B and C are passing PageRank to A and not to any other pages. We have channeled a large proportion of the site's PageRank to where we wanted it.
Example 4Finally, keep the previous links and add a link from page C to page B. Start again with PR1 all round. After 1 iteration:-
Page A = 1.425
Page B = 1
Page C = 0.575By comparison to the 1 iteration figures in the previous example, page A has lost some PageRank, page B has gained some and page C stayed the same. Page C now shares its "vote" between A and B. Previously A received all of it. That's why page A has lost out and why page B has gained. and after 100 iterations:-
Page A = 1.298245
Page B = 0.9999999
Page C = 0.7017543When the dust has settled, page C has lost a little PageRank because, having now shared its vote between A and B, instead of giving it all to A, A has less to give to C in the A-->C link. So adding an extra link from a page causes the page to lose PageRank indirectly if any of the pages that it links to return the link. If the pages that it links to don't return the link, then no PageRank loss would have occured. To make it more complicated, if the link is returned even indirectly (via a page that links to a page that links to a page etc), the page will lose a little PageRank. This isn't really important with internal links, but it does matter when linking to pages outside the site.
Example 5: new pagesAdding new pages to a site is an important way of increasing a site's total PageRank because each new page will add an average of 1 to the total. Once the new pages have been added, their new PageRank can be channeled to the important pages. We'll use the calculator to demonstrate these.
Let's add 3 new pages to Example 3 [view]. Three new pages but they don't do anything for us yet. The small increase in the Total, and the new pages' 0.15, are unrealistic as we shall see. So let's link them into the site.
Link each of the new pages to the important page, page A [view]. Notice that the Total PageRank has doubled, from 3 (without the new pages) to 6. Notice also that page A's PageRank has almost doubled.
There is one thing wrong with this model. The new pages are orphans. They wouldn't get into Google's index, so they wouldn't add any PageRank to the site and they wouldn't pass any PageRank to page A. They each need to be linked to from at least one other page. If page A is the important page, the best page to put the links on is, surprisingly, page A [view]. You can play around with the links but, from page A's point of view, there isn't a better place for them.
It is not a good idea for one page to link to a large number of pages so, if you are adding many new pages, spread the links around. The chances are that there is more than one important page in a site, so it is usually suitable to spread the links to and from the new pages. You can use the calculator to experiment with mini-models of a site to find the best links that produce the best results for its important pages.
Examples summaryYou can see that, by organising the internal links, it is possible to channel a site's PageRank to selected pages. Internal links can be arranged to suit a site's PageRank needs, but it is only useful if Google knows about the pages, so do try to ensure that Google spiders them.
Inbound and Outbound linksExamples of these could be given but it is probably clearer to read about them (below) and to 'play' with them in the calculator.
QuestionsWhen a page has several links to another page, are all the links counted?
E.g. if page A links once to page B and 3 times to page C, does page C receive 3/4 of page A's shareable PageRank?
The PageRank concept is that a page casts votes for one or more other pages. Nothing is said in the original PageRank document about a page casting more than one vote for a single page. The idea seems to be against the PageRank concept and would certainly be open to manipulation by unrealistically proportioning votes for target pages. E.g. if an outbound link, or a link to an unimportant page, is necessary, add a bunch of links to an important page to minimize the effect.
Since we are unlikely to get a definitive answer from Google, it is reasonable to assume that a page can cast only one vote for another page, and that additional votes for the same page are not counted.
When a page links to itself, is the link counted?
Again, the concept is that pages cast votes for other pages. Nothing is said in the original document about pages casting votes for themselves. The idea seems to be against the concept and, also, it would be another way to manipulate the results. So, for those reasons, it is reasonable to assume that a page can't vote for itself, and that such links are not counted.
[TOP]
It may suit site functionality to link to pages that have no links going from them without losing any PageRank from the other pages but it would be waste of potential PageRank. Take a look at this example. The site's potential is 5 because it has 5 pages, but without page E linked in, the site only has 4.15.
Link page A to page E and click Calculate. Notice that the site's total has gone down very significantly. But, because the new link is dangling and would be removed from the calculations, we can ignore the new total and assume the previous 4.15 to be true. That's the effect of functionally useful, dangling links in the site. There's no overall PageRank loss.
However, some of the site's potential total is still being wasted, so link Page E back to Page A and click Calculate. Now we have the maximum PageRank that is possible with 5 pages. Nothing is being wasted.
Although it may be functionally good to link to pages within the site without those pages linking out again, it is bad for PageRank. It is pointless wasting PageRank unnecessarily, so always make sure that every page in the site links out to at least one other page in the site.
[TOP]
The linking page's PageRank is important, but so is the number of links going from that page. For instance, if you are the only link from a page that has a lowly PR2, you will receive an injection of 0.15 + 0.85(2/1) = 1.85 into your site, whereas a link from a PR8 page that has another 99 links from it will increase your site's PageRank by 0.15 + 0.85(7/100) = 0.2095. Clearly, the PR2 link is much better - or is it? See here for a probable reason why this is not the case.
Once the PageRank is injected into your site, the calculations are done again and each page's PageRank is changed. Depending on the internal link structure, some pages' PageRank is increased, some are unchanged but no pages lose any PageRank.
It is beneficial to have the inbound links coming to the pages to which you are channeling your PageRank. A PageRank injection to any other page will be spread around the site through the internal links. The important pages will receive an increase, but not as much of an increase as when they are linked to directly. The page that receives the inbound link, makes the biggest gain.
It is easy to think of our site as being a small, self-contained network of pages. When we do the PageRank calculations we are dealing with our small network. If we make a link to another site, we lose some of our network's PageRank, and if we receive a link, our network's PageRank is added to. But it isn't like that. For the PageRank calculations, there is only one network - every page that Google has in its index. Each iteration of the calculation is done on the entire network and not on individual websites.
Because the entire network is interlinked, and every link and every page plays its part in each iteration of the calculations, it is impossible for us to calculate the effect of inbound links to our site with any realistic accuracy.
[TOP]
Tips
Domain names and FilenamesExample: Go to my UK Holidays and UK Holiday Accommodation site - how's that for a nice piece of link text ;). Notice that the url in the browser's address bar contains "www.". If you have the Google Toolbar installed, you will see that the page has PR5. Now remove the "www." part of the url and get the page again. This time it has PR1, and yet they are the same page. Actually, the PageRank is for the unseen frameset page.
When this article was first written, the non-www URL had PR4 due to using different versions of the link URLs within the site. It had the effect of sharing the page's PageRank between the 2 pages (the 2 versions) and, therefore, between the 2 sites. That's not the best way to do it. Since then, I've tidied up the internal linkages and got the non-www version down to PR1 so that the PageRank within the site mostly stays in the "www." version, but there must be a site somewhere that links to it without the "www." that's causing the PR1.
Imagine the page, www.domain.com/index.html. The index page contains links to several relative urls; e.g. products.html and details.html. The spider sees those urls as www.domain.com/products.html and www.domain.com/details.html. Now let's add an absolute url for another page, only this time we'll leave out the "www." part - domain.com/anotherpage.html. This page links back to the index.html page, so the spider sees the index pages as domain.com/index.html. Although it's the same index page as the first one, to a spider, it is a different page because it's on a different domain. Now look what happens. Each of the relative urls on the index page is also different because it belongs to the domain.com/ domain. Consequently, the link stucture is wasting a site's potential PageRank by spreading it between ghost pages.
Adding new pagesThere is a possible negative effect of adding new pages. Take a perfectly normal site. It has some inbound links from other sites and its pages have some PageRank. Then a new page is added to the site and is linked to from one or more of the existing pages. The new page will, of course, aquire PageRank from the site's existing pages. The effect is that, whilst the total PageRank in the site is increased, one or more of the existing pages will suffer a PageRank loss due to the new page making gains. Up to a point, the more new pages that are added, the greater is the loss to the existing pages. With large sites, this effect is unlikely to be noticed but, with smaller ones, it probably would.
So, although adding new pages does increase the total PageRank within the site, some of the site's pages will lose PageRank as a result. The answer is to link new pages is such a way within the site that the important pages don't suffer, or add sufficient new pages to make up for the effect (that can sometimes mean adding a large number of new pages), or better still, get some more inbound links.
[TOP]
Listings in the ODP are free but, because sites are reviewed by hand, it can take quite a long time to get in. The sooner a working site is submitted, the better. For tips on submitting to DMOZ, see this this DMOZ article.
more
-
Monetisation Your Facebook’s
With the social safety net, test function, so that companies with an overview of 150 million members to find out their thoughts about the product or market, understand their lives, or try a new approach with them. In fact, he only want them to. And given the many number of Facebook profile information, target them in this study based on the location, gender, age, and almost all of them.
This company is to show the benefits of the new polling feature (called Egnagement ads) on sunday to some of the most influential business leaders in the World Economic Forum in Davos. He called for a number of questions on Facebook and members can answer back on the forum almost in real time. Engagement ads also are currently being tested in two companies: Career Builder, Global Graduate Recruitment Company, and AT & T.
If Randi Zuckerberg, Facebook, director of global market, to the Telegraph:
I have hundreds of people said: "This is very unusual for our company." It takes long to complete, and companies often do not have the luxury of time. I think they want to respond immediately.
We have in this blog about why Facebook does not like your online research. Facebook and other social networks, is not suitable for the depth of qualitative information to you through the online survey. We at this time:
Only in the research that you really believe the best of the discussion and debate [...] You have the right to reply, and the ability, in the same discussion with the members [.. .] You can build and analyze the profile data can be obtained from the members and contributions from big insurance and comments [and] a number of members who interact directly with the brand and support you
Perhaps some of the ad is a strong commitment to primary research online. With companies to buy and questions on a number of respondents with the selection criteria. Once again, there are some concerns about Facebook. Producers a lot of time screening panel participants. They hold the same data for all participants and is capable of respondents with fair and comprehensive. The problem with Facebook is that not only data in the same way. As a member, I can determine the information I have given them. I do not tell my age, location, or even my gender. So if someone want to survey, men aged 25-34 in London, England, Facebook may not be for me, although I meet all the criteria. Respondents were therefore prepared in the direction for the profile data, and not a fair sample.
Of course, Facebook has a significant advantage. Size. With 150 million members around the world, no matter whether a part (even most) havent 'filled with information and profile are excluded from the sample. There will be more than enough available for the respondent answers that they need. And to them quickly.
So, if Facebook is the use of involvement as the advertising market is not an on-line tuning of research. It is also not fully compete with the online service provider panel. But there is something new in the market - a large, fast response, and (possibly) a relatively inexpensive way of testing and advice given ideas of what a person. For a more in-depth information, but the company may have to rely on other sources
more
-
Simple Steps to Earn Money Blogging
So, the big question, how can I use SponsoredReviews to make money blogging?
It’s simple. First, you need a blog. At SponsoredReviews, quality counts, so your blog has to meet the following requirements:
1. Be at least three months old.
2. Must contain original content.
3. Must maintain regular content along with the paid posts.
Your next step is to register your blog with SponsoredReviews, get your free account here.
From there it’s easy. Once your blog is approved, you can start searching for opportunities to make money blogging. If it sounds simple, it is. How much you can make depends on a whole variety of factors. Let’s take a look at ways you can improve your blog and make more money for your paid posts.
Appearance counts, take a look at your blog.
* How does it look?
* Does it load quickly?
* Imagine you’re an advertiser - would you hire you?
* Clean up any visual clutter and create clear and easy to navigate archives.
You may love those falling hearts or shooting stars, but if you’re trying to make money blogging, you might want to skip those cutesy things.
Now that you’ve cleaned up your blog visually, it’s time to look at content.
Does your blog have a primary topic? What’s your readership? Those are the areas you’ll want to focus on when you start searching SponsoredReviews for opportunities.
Take time to make your posts, all of them, even the unpaid ones, really stand out. Create clear headlines that are search friendly. That means that cute play on words that’s funny, but has nothing to do with your post is a no-no.
Incorporate at least one key point into your title and think of your post’s title as a mini post. Spell check the post - then do it again and if grammar and spelling aren’t your strong suit, have a friend help.
Earn some money - finding the right opportunities
OK, you’ve upped the quality factor on your blog, it’s time to start making some money blogging. Log in to that SponsoredReviews account and start searching for opportunities. What? You don’t have an account yet? It’s free, sign up.
New bloggers are often frustrated when advertisers aren’t accepting their bids. Fine tune that blog like we've been talking about. Search for opportunities that match your blog's category and readership. Price your blog right - SponsoredReviews even offers tips based on your blog's stats and offer reasonable bids.
Really, it boils down to standing out from the crowd of other bloggers who are doing the same thing you are. When you register your blog:
* Make the title work for you.
o Include your category and descriptive terms.
* Use the description to sell you and your blog.
o Highlight key points.
o Link to your best paid posts.
o Brag about your readership.
o Show off your writing skills.
Make your words count - write quality posts
The other way to increase your chances, get more bids and make more money blogging is just this: write quality posts and great reviews.
Write a well researched, well thought out post and include relevant pictures. Make sure to use the appropriate tags on pictures and link those pics outside your blog if that’s appropriate. Quality writing is going to make you stand out and look more professional.
Get personal - create an "About Me" page
While you’re at all this work streamlining and creating a great looking blog, take a moment to make sure your blog has an “About Me” page and link to your SponsoredReviews profile, and even consider becoming a SponsoredReviews affiliate. Taking steps to increase your blog’s readership is another big way to improve your blog.
* Register your blog with directory sites.
* Network with other bloggers.
* Get your blog out there and visible in the blogoshpere.
Got all that? Great! You’re ready to head out and start earning money blogging! The best part about all this? Not only do you earn money, but by taking these steps to improve your blog, and focusing on quality, you’ll also be taking important steps to increasing your blog’s readership. Which is a key step to earning higher amounts with your paid posts. Stay tuned for future posts on ways you can improve your blog.
more
-
Giant List of Blog Directories
Are you looking to increase the traffic to your blog? Building links from directories will increase your link popularity, direct traffic, and search engine rankings.
There are several lists of “Blog Directories” around the Internet, but most of them feature only a hand full of directories, and they lack a ranking factor to make it easier for the reader to scan through the list.
Below you will find a very extensive list of Blog Directories, ordered according to their Alexa rank. We have also inserted the Pagerank of each directory on the list to make it more detailed. Enjoy!
Blog Directory Pagerank Alexa http://dir.yahoo.com/Internet/World_Wide_Web/Weblogs/ 5 1 http://dmoz.org/Computers/Internet/On_the_Web/Weblogs/ 6 316 http://www.blogcatalog.com/ 7 4821 http://blogflux.com/ 7 5350 http://blogs.botw.org/ 6 7501 http://www.geekyspeaky.com/links/ 5 13431 http://www.blogpulse.com/index.html 7 23826 http://www.blogdigger.com/index.html 7 29593 http://www.blogarama.com/ 7 33807 http://www.bloghop.com/ 6 46602 http://www.blogrankings.com/ 7 54862 http://www.blogtoplist.com/ 6 58187 http://www.findory.com/blogs/ 5 12610 http://www.bloggernity.com/ 6 46840 http://www.bloggeries.com/ 6 62276 http://www.bloghub.com/ 7 70000 http://www.lsblogs.com/ 6 72172 http://www.blog-search.com/ 6 74926 http://www.britblog.com/ 6 77798 http://www.weblogalot.com/ 6 80012 http://www.globeofblogs.com/ 6 83121 http://blogstreet.com/? 7 84667 http://www.bloguniverse.com/ 6 92205 http://www.top100bloggers.com/ 6 96308 http://www.getblogs.com/ 7 100052 http://www.delightfulblogs.com/ 6 118010 http://www.bloogz.com/ 6 104394 http://portal.eatonweb.com/ 7 118470 http://www.readablog.com/default.aspx 5 119470 http://www.iblogbusiness.com/ 5 122972 http://findingblog.com/ 6 134736 http://www.all-blogs.net/ 5 136386 http://www.bloglisting.com/ 5 165293 http://www.blogdup.com/ 5 174240 http://sportsblogs.org/ 6 181274 http://www.blogcode.com/index.php 5 200304 http://blogannounce.info/ 5 216210 http://www.blog-directory.org/index.php 6 231052 http://www.sarthak.net/blogz/index.php 5 231244 http://www.blogsweet.com/ 6 240401 http://www.blogdirs.com/ 5 243187 http://www.addurlblog.com/ 5 245137 http://www.5starblogs.com/ 5 246817 http://www.blogtagstic.com/ 5 253731 http://www.blogscanada.ca/directory/ 0 260041 http://www.industry-blogs.com/ 5 270163 http://www.blogbib.com/ 5 270449 http://www.kmax.ws/bloglinks.htm 5 304010 http://www.blogs-collection.com/ 5 313468 http://www.diarist.net/registry/ 6 314116 http://www.blogbunch.com/ 4 314157 http://www.blog-watch.com/ 5 314160 http://www.photoblogdirectory.net/ 5 319197 http://blogsforsmallbusiness.com/directory/ 5 325343 http://www.bloghints.com/ 4 361618 http://www.search4blogs.com/bloggers/index.php 6 381223 http://www.thevital.net/ 5 419847 http://www.highclassblogs.com/ 5 497951 http://emarketingblogs.com/listings/index.shtml 5 504610 http://jenett.org/ageless/ 5 515636 http://www.bestblogs.org/ 5 548901 http://www.misohoni.com/bba/ 5 559462 http://www.blogdust.com/blog-directory/ 4 622062 http://blogs.tomstopsites.com/ 5 629832 http://www.chinabloglist.org/ 5 632138 http://www.blogadr.com/ 4 715258 http://directory.etalkinghead.com/ 5 735127 http://www.topblogsites.net/ 5 751608 http://www.biggerblogger.com/ 4 768196 http://www.blogroll.net/ 4 814706 http://www.blogscholar.com/component/ 5 817622 http://www.blogpoint.com/ 4 883904 http://browseblogs.com/ 4 1039483 http://www.blogsrating.com/ 4 1078346 http://www.blogdir.co.uk/ 4 1098680 http://www.quickblogdirectory.com/ 4 2113555
more
-
SEO; Search engine optimization for Your Site
Search engine optimization (SEO) is the process of improving the volume and quality of traffic to a web site from search engines via "natural" ("organic" or "algorithmic") search results. Typically, the higher a site's "page rank" (i.e, the earlier it comes in the search results list), the more visitors it will receive from the search engine. SEO can also target different kinds of search, including image search, local search, and industry-specific vertical search engines.
As an Internet marketing strategy, SEO considers how search engines work and what people search for. Optimizing a website primarily involves editing its content and HTML coding to both increase its relevance to specific keywords and to remove barriers to the indexing activities of search engines.
The acronym "SEO" can also refer to "search engine optimizers," a term adopted by an industry of consultants who carry out optimization projects on behalf of clients, and by employees who perform SEO services in-house. Search engine optimizers may offer SEO as a stand-alone service or as a part of a broader marketing campaign. Because effective SEO may require changes to the HTML source code of a site, SEO tactics may be incorporated into web site development and design. The term "search engine friendly" may be used to describe web site designs, menus, content management systems and shopping carts that are easy to optimize.
Another class of techniques, known as black hat SEO or Spamdexing, use methods such as link farms and keyword stuffing that degrade both the relevance of search results and the user-experience of search engines. Search engines look for sites that employ these techniques in order to remove them from their indices.
more
-
How To: Rearrange WordPress Comments (Latest On Top)
A few days ago i had to make a minor change to my friend’s site, he wanted the latest comments to be right on top instead of the usual at the bottom of a page, so I had to re-arrange how the comments appeared and if for some reason you need this function all you have to do is a minor edit of /wp-includes/comment-template.php.
Original Code:
// TODO: Use API instead of SELECTs.
if ( $user_ID) {
$comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE comment_post_ID = '$post->ID' AND (comment_approved = '1' OR ( user_id = '$user_ID' AND comment_approved = '0' ) ) ORDER BY comment_date");
} else if ( empty($comment_author) ) {
$comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE comment_post_ID = '$post->ID' AND comment_approved = '1' ORDER BY comment_date");
} else {
$author_db = $wpdb->escape($comment_author);
$email_db = $wpdb->escape($comment_author_email);
$comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE comment_post_ID = '$post->ID' AND ( comment_approved = '1' OR ( comment_author = '$author_db' AND comment_author_email = '$email_db' AND comment_approved = '0' ) ) ORDER BY comment_date");
}Amazingly enough all you have to do is add a four letter word… DESC :
// TODO: Use API instead of SELECTs.
if ( empty($comment_author) ) {
$comments = $wpdb->get_results(”SELECT * FROM $wpdb->comments WHERE comment_post_ID = ‘$post->ID’ AND comment_approved = ‘1′ ORDER BY comment_date DESC“);
} else {
$author_db = $wpdb->escape($comment_author);
$email_db = $wpdb->escape($comment_author_email);
$comments = $wpdb->get_results(”SELECT * FROM $wpdb->comments WHERE comment_post_ID = ‘$post->ID’ AND ( comment_approved = ‘1′ OR ( comment_author = ‘$author_db’ AND comment_author_email = ‘$email_db’ AND comment_approved = ‘0′ ) ) ORDER BY comment_date DESC“);
}That’s it!
UPDATE: I fired up my Dreamwever and can confirm that you’ll find the code in just about line 290
From : WP_Design
more
