Arise, awake

“Arise awake and stop not till the goal is reached.”

Swami Vivekananda

Advertisements

PHP : Create array from MySql recordset

This PHP code is to create array from MySql record set.

<?php
$sel=”SELECT * FROM table_name”;
$rs=mysql_query($sel);
$i=0;
while ($row = mysql_fetch_assoc($rs))
{
$array[$i] = $row;
$i++;
}
?>

India Won the Cricket World Cup 2011

It’ s party time for India…!!!

India beat Sri Lanka and Won the Cricket World Cup 2011 by 6 wickets.

Man of the Match – MS Dhoni

Man of the Tournament – Yuvaraj Singh

India beat Pakistan in World Cup 2011 Semi-Final

India beat Pakistan by 29 Runs in World Cup 2011 Semi-Final on 30th March 2011 played at Mohali.

MySql – Convert numeric field to string field in select statement


SELECT cast( numeric_field AS char ) FROM table_name

MySql – Conditional display order

This is the select statement in MySql to get records in order with parent and child view.

 

SELECT *, CONCAT( if(parent_id > 0,(select display_order from `table_a` C where C.id = P.parent_id),''), if(parent_id > 0,'-',''), display_order ) AS new_col FROM `table_a` P order by new_col

Anjaana Anjaani – Tu Na Jaane Aas Paas Hai Khuda – Lyrics

Movie : Anjaana Anjaani (2010)
Singer : Rahat Fateh Ali Khan
Lyricists : Vishal Dadlani, Shekhar Ravjiani
Music Director : Vishal Dadlani, Shekhar Ravjiani

This is a beautiful song. I like it too much.

Dhundhla jaayein jo manzilein
Ik pal ko tu nazar jhuka
Jhuk jaaye sar jahan wahin
Milta hai rab ka raasta
Teri kismat tu badal de
Rakh himmat bus chal de
Tere saath hi mere kadmon ke hai nishaan

Tu na jaane aas pass hai khuda… Tu na jaane aas paas hai khuda
Tu na jaane aas pass hai khuda… Tu na jaane aas paas hai khuda
Tu na jaane aas pass hai khuda… Tu na jaane aas paas hai khuda

Khud pe daal tu nazar
Haalaton se haar kar.. Kahan chala re
Haath ki lakeer ko.. Modta marodta
Hai hausla re
Toh khud tere khwabon ke rang mein
Tu apne jahan ko bhi rang de
Ke chalta hoon mein tere sang mein
Ho shaam bhi toh kya
Jab hoga andhera
Tab paayega dar mera
Uss dar pe phir hogi teri subah

Tu na jaane aas pass hai khuda… Tu na jaane aas pass hai khuda
Tu na jaane aas pass hai khuda… Tu na jaane aas pass hai khuda

Mitt jaate hai sabke nishaan
Bas ek woh mitt ta nahin hai haye
Maan le jo har mushkil ko marzi meri haye
Ho humsafar na tera jab koi
Tu ho jahan rahunga mein wahi
Tujhse kabhi na ik pal bhi mein judaa

Tu na jaane aas pass hai khuda… Tu na jaane aas pass hai khuda..
Tu na jaane aas pass hai khuda… Tu na jaane aas pass hai khuda..