the self-discovery adventure of brett taylor
Mmm… don’t you like the What’s Playing section on the sidebar? It’s powered by What’s Playing plugin for Winamp 3. Here’s the PHP script I’m using here on glutnix.com.
What’s Playing (the way I’m using it) sends the id3 details of the last n songs to a php script. This script then takes those details and writes a bit of html which you then include in your page. What’s Playing can also upload an HTML file to your FTP server if that’s how you would rather do it.
SELECT ``. * , `regions`.`regionname` ,
MATCH (
``.name_first, ``.name_last, ``.address1, ``.address2
)
AGAINST (
' runner '
) AS relevance
FROM `regions`
INNER JOIN `` ON ( `regions`.`id` = ``.`region_id` )
WHERE (
(
``.businessflag = 0 AND ``.name_last
LIKE 'runner'
)
) OR (
(
``.businessflag = 1
) AND
MATCH (
``.name_first, ``.name_last, ``.address1, ``.address2
)
AGAINST (
'runner'
) > 0
)
HAVING relevance > 0
ORDER BY relevance DESC
OK, maybe not the mother of all SQL statements, but maybe the PHP will convince you otherwise:
W00t! I just got a call from Jonquil from Dev-zone, and I have the job! Wow! I was not expecting a same-day reply! I would just like to say that I believe that God set me up this job, and I want to just publicly say thanks to Him for his blessings. Cheers to all my friends who prayed for me and those who supported me!
My first day at Dev-zone is on March 10! w00ta!
I been working. 😛 Trying to fix this damned graph/chart making actionscript in flash. I finally got it working so yay! Now I get to take xml data from a .NET service and put it into this flash… should be easy. After that I get to make it into a component. Exciting? Yes and no. Turning it into a component will be a task and a half of full cream coffee. Anyway, better get back to work. Mental note: blog more often.
Yup. A client of ours has flown Mufasa and myself to Hamilton in the Waikato. For you overseas ppl, Hamilton is a 1.5 hour drive south of Auckland. We’re in a building that I think is right next to the Waikato River. Well, I think it’s the Waikato… there’s no signs and I don’t have enough guts to ask anyone just yet. Mind you, the coffee was good… better than the swill on the Air New Zealand flight in. Plans are to go see Hillary, my friend in Auckland tonight, maybe even crash out at her place. We’ll see. Better dash, pizza is here!
