Hard Light Productions Forums
Off-Topic Discussion => General Discussion => Topic started by: Kazan on August 09, 2005, 05:53:20 pm
-
So for the last month i've been a contractor writing php/mysql code - well effective monday i become a full time employee with benefits - 38K/year :D
gratz me!
-
Congradulations!
-
Good job. Does this mean you'll be less moody? ;)
Of course, that's what I get to do itinerant tech support. I think I might be overpaid. :D
-
Congrats Kazan! Another small inspiration for a kid like me to better myself. :D
-
Congrats, sir. :nod: :yes:
-
Congrats Kaz!
-
:yes:
-
ty all :D
-
38k year ? as in 38 k with tax deduction?
-
Congrats Kazan!
-
ashrak before taxes
-
congrats dude!
38k a year...that's what, 3.1k a month? dude, sw33t!
-
[color=66ff00]It's still only about £12.85.
*cough*
[/color]
-
that's ~$19.79
-
'atta boy Kaz.
-
Cushty
-
:yes:
-
:yes:
-
Hooray for Kaz.
Don't spend all of your money on beer.
-
i dont drink
-
Even better.
-
Don't spend all your money on EverQuest then. :D
-
rotfl :D i'm actually kidna growing tired of everquest.. i play it like once per week
-
'grats! As far as income drain goes, watch out for SOs too. ;)
-
heh.. blair isn't a very big of an income drain
this is a brain drain
SELECT DISTINCT
count(f.`fid`) as c,
e1.`name` as start_text,
e2.`name` as end_text
FROM forms as f
LEFT OUTER JOIN grantees as g ON `f`.`project_number`=`g`.`ed_id`
LEFT OUTER JOIN employment as e1 ON f.`entry_head_employlvl`=e1.`ed_id`
LEFT OUTER JOIN employment as e2 ON f.`exit_head_employlvl`=e2.`ed_id`
WHERE
f.`entry_head_employlvl` IS NOT NULL AND
f.`exit_head_employlvl` IS NOT NULL AND
f.`entry_head_employlvl` != f.`exit_head_employlvl` AND
(enroll > STR_TO_DATE('2004-01-01', '%Y-%m-%d') OR
exitdate > STR_TO_DATE('2004-01-01', '%Y-%m-%d')) &&
(exitdate < STR_TO_DATE('2005-01-01', '%Y-%m-%d') OR
enroll < STR_TO_DATE('2005-01-01', '%Y-%m-%d')) AND
(g.`name` LIKE '%Iowa%' OR
fadss_spec LIKE '%Iowa%')
GROUP BY
f.`entry_head_employlvl`, f.`exit_head_employlvl`
that's a query i wrote for work
-
Nice job. PHP and MySQL are incredibly easy, and fun.
-
yeah... except when you write skull-splitting sql queries :D