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 tera hoga mujh par…
You were the one who taught me how to laugh
Now, if you ask me to cry, I will
Don’t be hurt by my tears
They’ve already started to flow, so let them fall.
Because I’ve fallen in love with you
Let me dwell in the shelter of your eyes
You would be indulging me…
Chaahe bana do chaahe mitaa do
Mar bhi gaye to denge duwaayen
Udd udd ke kahegi khaak sanam
Yeh dard-e-mohabbat sehne do
Mujhe tumse mohabbat ho gayi hai
Mujhe palkon ki chaaon mein rehne do
Either make it or destroy it
Even if it kills me, I will sing your praises
Flying around, the ashes will say,
“Let me bear the burdens of love.”
For I have fallen in love with you
Let me dwell in your eyes forever
Ehsaan tera hoga mujh par
Dil chahta hai woh kehne do
Mujhe tumse mohabbat ho gayi hai
Mujhe palkon ki chaaon mein rehne do
Ehsaan tera hoga mujhe par…
You would be doing me a great favor
If you let me tell you what’s in my heart
I have fallen in love with you
Please let me dwell in your eyes
You would be indulging me…
Month: August 2009
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, this will work fine in its default mode. However if you’re trying to concatenate long text values, the result will get truncated because by default it allows 1024 bytes of data. You can set the maximum to be something like 65000 bytes which will give you roughtly 5 whole pages of MS Word documents’ worth.
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 than blend in with the content of the website. Result – decreased CTR and earnings. I’ve changed it back to what it was before – Arial at 12px and I’m hoping everything will get back to normal now.
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 to take because when Google crawls your webpage again, it will find that the content differs significantly from what it was before and this could get you removed completely from the index and unranked for an unknown amount of time.
I took the risk because I couldn’t be worst off (c’mon not ranked among the 1st 20 pages!) and I speculated that my rankings will come back within at least 2 weeks. I checked rankings for the keywords for that page nearly everyday after making the change and today (after nearly 2 weeks), I’m listed on Page 4 of the search results at Position 38.
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 really a big change as the title tag will be exactly the same it was before but will be just more pleasant to the eyes. I found that when searching on google, title tags which have the first letter of each word capitalised are more easy to read, which means that it could draw in more visitors for me. Hence I’m making this change today and if the effects are positive, I will implement it to the rest of the site.
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 saw the link units which were better targeted than the actual adsense ads and clicked on them instead. However link units will display a list of related ads on the category which has been clicked and the results page for these ads are not very pretty at all – it’s like google search results page which is nothing like the theme of my site. Therefore the visitors couldn’t be bothered to click on the ads again which meant my earnings were affected.
All in all, I really think that Link Units are a waste of time unless you put them down your webpage as an exit point.
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 the php regular expression code).
I’ve also added a new link unit to the navigation and I’m curious to see how this will now perform. I’m hoping to will drive category related ads to the question being asked but I can’t be sure until I’ve tested it.
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 query as follows:
You can issue a fulltext query as below:
SELECT * FROM your_table_name WHERE MATCH(Column_1, Column_2) AGAINST(‘your-search-query’ IN BOOLEAN MODE)
This will give you the results you are expecting. You can also try adding more rows to your table. If you have just 2 rows, adding a 3rd one might solve the problem because the 50% rule will be avoided.
To delete fulltext index:
ALTER TABLE your_table_name DROP INDEX your_index_name
To see the index on a table (including fulltext index):
SHOW INDEXES FROM your_table_name