This Blog Reach Page Rank 3

Actually, it was very hard work to increase Google Page Rank. But very succesfull way to get Page Rank is nice Article and Posting. People visit our blog usually search for important and usefull information.

Beside nice post and good type content, I consider Link Exchange is very sucessful way to get High Page Rank. How many site linking our site or blog. This affect how Important our blog in the web.

I consider that my site traffic is low (usually average 20 visitors a day). I focussed the visitor came from the search engine without ignore direct or referring site. The only ways to do this is produce nice article.


Because of low blogwalking activity Alexa Rank is down drastically. Busy of another activity and daily life.


I hope with this all condition do not stop me to write and write every day.

SQL Commands for Displaying Random Record

Have you ever seen the applications that displays a random tips, messages or informations? For example, displays messages, advice or tips on web pages. Every time with or without refresh, the page displays the message, the message appears change at random.

Displaying Random Record can be made only by using SQL statement, without your hard-work to write a script or program. There is in the SQL function RAND (). This function can generate random numbers.

By default, this function will result in real numbers range from 0 - 1.

Example usage: SELECT RAND ();




Above statement will produce output random real numbers range from 0 - 1.

Function RAND () in the example above is placed in the SELECT. But you can also put it in the ORDER BY.

Example usage: SELECT * FROM table ORDER BY RAND ();

Well ... if the above statement will show a record that will be selected at random among all the records in the table.

You may then ask, what if you want to select N records at random from all that is in the table? The way that is easy enough just by adding a LIMIT command N.

Example usage: SELECT * FROM table ORDER BY RAND () LIMIT 3;



Statement on the record will show random 3.

You can also use the WHERE, as in the following statement SELECT * FROM table WHERE conditions ORDER BY RAND () LIMIT 3;

Miraculously ... let's say you choose N random records with a SQL statement above, then the N records are not the same.