Ehsaan tera hoga mujpar – Junglee – Translation
Ehsaan tera hoga mujh par
Dil chahta hai woh kehne do
Mujhe tumse mohabbat ho gayi
Mujhe palkon ki chaaon mein rehne do
Ehsaan tera hoga mujh par...
You would be doing me a great favor
If you let me tell you what my heart desires
I have fallen in love with you
Please let me dwell in the shelter of your eyes
You would be doing me a great favor...
Tumne mujhko hansna sikhaaya
Rone kahoge ro lenge ab
Aansoo ka hamaare gham na karo
Woh behte hai to behne do
Mujhe tumse mohabbat ho gayii hai
Mujhe palkon ki chaaon mein rehne do
Ehsaan ...
Grouping records in one single row
There are times when you need to group records which are linked by a common field (a foreign key) together into one single row. For example if you wanted to group all orders associated with a customer into one single row, it causes a problem in mysql because you can easily achieve a similar but yet different resultset by listing all the records associated with the foreign key.
There's something which you can use in MySql to group the results together, it's called the group_concat function. For values which are short, ...
New default adsense fonts may decrease CTR
The new default adsense fonts will not necessarily increase your CTR. For my website, as soon as the new fonts were implemented, I saw a decrease in CTR and earnings. The reason for that is that if your ads don't blend nicely with the theme of your website, people will not click on the ads. On my website, I use Arial with 12px font size. However the adsense ads were in Verdana at 14px font size. So they were sticking out like a sore thumb and looked more like ads ...
Changing text content of a webpage
Beginning of August (1st or 2nd), I decided to change the text content on my of my webpage because it was not ranking at all for its keywords (I checked the first 2o result pages of google and it was not there!). I had a read through the body of the article and I wasn't quite pleased with the text, so I made considerable changes to the article and I would say at least 50% of the content was changed. Now this is a risk that you don't really want ...
When to change the title tag of a webpage?
If Google has already crawled and indexed your website and its webpages, then you shouldn't really change your title tags because the webpage will be sandboxed for some time (can be weeks or months). Therefore you will see a drop (could be massive) in rankings. The only excuse you have for changing your title tags is if they were really bad in the first place!
I have changed the title tags on the question part of my site so that the first letter of each word is capitalised. This is not ...
Google Link Units are not very effective
Two days ago, I decided to try Google Link Units. I've always been put off by them because you require two clicks on the link unit to earn money. Anyway, I thought I'd give them another go as I wanted to test whether I could get better targeted ads through the link units. Unpleasantly, I found out that my overall CTR for adsense had decreased which meant my earnings went down as well. My CTR decreased by as much as 4%!
My opinion on this is that visitors to my site ...
More changes to question/answer website
The previous changes that I made were successful and the CTR is now between 6-8% but the problem I am having is lack of targeted ads on the website. So I've decided to use google section targeting to emphasise which content I want ads to be pulled out from. I've focused on h1 tag, the content itself and added a weight=ignore tag to the navigation menu.
I've also fixed the problem with line breaks in the description meta tag (i was using an escape character "/" which was not needed in ...
MySQL Fulltext search problem
To enable fulltext search on a table inMySql, the following syntax is used:
ALTER TABLE your_table_name ADD FULLTEXT (Column_1, Column_2)
Fulltext on MySql will only work on MyISAM type tables.
You can issue a fulltext query as below:
SELECT * FROM your_table_name WHERE MATCH(Column_1, Column_2) AGAINST('your-search-query')
However for a small table with limited number of rows, you may not see the fulltext search results because of the following rule for fulltext:
"...words that are present in 50% or more of the rows are considered common and do not match"
To overcome this problem you can rewrite your ...