Proverbian
treasured junkyard
JOIN same table
May 6th
I have a table structure where two different rates are stored in the same table, and will be fetched in a single array of data. I tried to research for some forum, the I found one website that mentioned about joining the same table, so i tried to to have a query, and it works.. the query goes like this.
SELECT a.rate from rates a left join subjects b on b.rateid = a.id left join rates c on c.id = b.labid
the data is like this:
subject name rateid labid rate laboratory
english 1 2 200 500
math 3 4 250 550
then actual data is in :
fees table
id rate
1 200
2 250
3 500
5 550
Dreamweaver CS5 Won’t Start | Problem
Mar 23rd
This is for mac.
Just found a fix when your adobe dreamweaver won’t start after opening.
this is the link of the fix.
Adobe Update
If you want to download the fix directly, here is the link:
UPDATE
Change Character Encoding
Oct 12th
To change the charset, insert this code inside your head tag, just like this..
<head>
<meta http-equiv=’Content-Type’ content=’text/html; charset=ISO-8859-7′>
</head>
cant connect to mysq instance mac osx
Aug 31st
http://www.fischerlaender.net/web-20/mac-os-x-trouble-with-mamp-mysql
Running ps -awwx | grep mysql showed, that mysqld had been started by MAMP with the option –socket=/Applications/MAMP/tmp/mysql/mysql.sock, whereas the mysql tool and WordPress assume the socket file here: /tmp/mysql.sock.
With this information the solution is easy:
sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock /tmp/mysql.sock
Backward Sorting of Data in Array
Jun 29th
rsort( ) – Sorts a Scalar array in reverse order
arsort( ) – Sorts the Values in an Associative array in reverse order
krsort( ) – Sorts the Keys in an Associative array in reverse order
source:
http://www.homeandlearn.co.uk/php/php6p6.html
We Are The World 25 For Haiti Lyrics
Mar 19th
We Are The World 25 For Haiti Lyrics
[Justin Bieber]
There comes a time
When we heed a certain call
[Nicole Scherzinger & Jennifer Hudson]
When the world must come together as one
[Jennifer Hudson]
There are people dying
[Jennifer Nettles]
And it’s time to lend a hand to life
The greatest gift of all
[Josh Groban]
We can’t go on
Pretending day by day
[Tony Bennet]
that someone, somehow will soon make a change
[Mary J Blige]
We are all a part of
God’s great big family
And the truth, you know love is all we need
Ezra Band
Mar 2nd
Ezra Band
from Davao del Sur impressed the three judges of Pilipinas Got Talent.
There’s something special about Ezra band. This band from Davao del Sur has a girl vocalist named Kaaye and a differently-abled keyboard player. Their soulful rendition of “Wonderful Tonight†wowed the judges.
Kris Aquino said “Sa acoustic we look for soul. Hinahanap natin ung depth of emotions, yung madadala ka ng kanta. You made us feel wonderful tonight.â€
Ai Ai delas Alas said “…Nabilib ako sa inyo, lalong lalo na sa kanya [referring to the keyboard player] kasi hindi hadlang at napakagaling niya mag-keyboard.â€
Freddie Garcia said “This is definitely extra-ordinary!â€
Watch the video below:
[youtube=http://www.youtube.com/watch?v=NhWs5zz5dfo]
content source: http://www.starmometer.com/2010/03/01/ezra-band-wows-the-judges-of-pilipinas-got-talent/ and
video source: http://kapamilyanewsngayon.blogspot.com/2010/03/ezra-band-pilipinas-got-talent.html / youtube.com