e_i_pi's Profile User Rating: *****

Reputation: 782 Master
Group:
Mentors
Active Posts:
1,663 (0.87 per day)
Joined:
30-January 09
Profile Views:
46,318
Last Active:
User is online 40 minutes ago
Currently:
Viewing Topic: Select starting a point sort by ...

Previous Fields

Country:
AU
OS Preference:
Windows
Favorite Browser:
FireFox
Favorite Processor:
AMD
Favorite Gaming Platform:
Playstation
Your Car:
Mitsubishi
Dream Kudos:
75
Expert In:
Databases

Latest Visitors

Icon   e_i_pi has set their status

Posts I've Made

  1. In Topic: Select starting a point sort by radius

    Posted 16 Apr 2014

    I'll assume you're not using spatial data types, but simply storing your latitude and longitude in DECIMAL type columns. In that case, you should be using Pythagoras' Theorem, with the latitude and longitude being the sides of the triangle, and the radius being the hypotenuse.

    Your predicate should look something like this:
    WHERE SQRT(POWER(latitude - $lat, 2) + POWER(longitude - $lng, 2)) <= $radius
    
    
  2. In Topic: Jquery sending multiple network requests

    Posted 8 Apr 2014

    Every time one of your functions runs that has an event binder (e.g. .click() ) it binds another event handler. Look into using a more modern version of jQuery and use .off('click').on('click', function() {...}) instead. That will ensure handlers don't keep stacking up, and solve your multiple request problem I think.
  3. In Topic: Query only returning one record.

    Posted 8 Apr 2014

    Your SQL isn't valid, if you use an aggregate clause like COUNT then you need to use the GROUP BY aggregating clause on your non-aggregated fields (I'd, name, cost)
  4. In Topic: Art of War website officially released

    Posted 12 Feb 2014

    Thanks Lemur, I'll look into resolving those issues. I prefer the sidebar text to be centre aligned for aesthetics, that might just be me. I think it could do with padding/margin top and bottom on each to help with readability, and yes the font size is a touch too small. The background opacity can be fixed easy enough - all the background art is published via the project module I put in, so it's just a matter of adjusting the settings and redeploying the individual background projects. As for the text/padding. I was more concerned with getting text in there that described the site well, I'll try trimming it down some and laying it out a bit better. Thanks again, much appreciated.
  5. In Topic: JQuery- Do developers need it?

    Posted 31 Jan 2014

    The last place I worked for used their own in-house Javascript libraries (don't worry, this is on topic, read on). I asked why we didn't use jQuery. The boss said jQuery sucked. When I asked a co-worker, we said that the boss got burnt by jQuery when it was in early development, and has hated it ever since. The result for the company? Javascript that worked in IE8, sometimes worked in IE9, and borked in everything else. The dev team didn't have time to get it cross browser compliant, so the customers were told to use outdated versions of browsers and suck it up.

    The big benefit I see to using jQuery (apart from the ubiquity) is that the jQuery is very cross browser compliant. If I write a line of code in jQuery, there's a very strong chance that I don't need to hack in some shitty code in order to get it working in Version Old of XYZ Browser (read: IE). I'm sure people can come up with examples where I'm wrong - I'm not saying jQuery is the magic bullet, but it does make life a lot easier.

My Information

Member Title:
= -1
Age:
39 years old
Birthday:
June 24, 1974
Gender:
Location:
Australia
Years Programming:
4
Programming Languages:
HTML, XML, jQuery, PHP, SQL, MySQL, VBA, VBScript, PostgreSQL

Contact Information

E-mail:
Private
Website URL:
Website URL  http://www.artofwar.cc/

Comments

Page 1 of 1
  1. Photo

    cupidvogel Icon

    09 Jun 2012 - 11:30
    Ha ha, I really liked your "if(navigator.appName == 'Microsoft Internet Explorer')" theme!
  2. Photo

    Duckington Icon

    04 Apr 2012 - 00:57
    It's not live yet, still developing and then going into beta test. I haven't actually decided on a name yet, so no domain for it.
  3. Photo

    modi123_1 Icon

    13 Mar 2012 - 06:56
    Ha.. well good luck with it.. it's always a good butt of a joke.
  4. Photo

    RudiVisser Icon

    08 Mar 2012 - 15:20
    You know, I only just worked out what your avatar is. Love it!
  5. Photo

    RudiVisser Icon

    06 Sep 2011 - 00:37
    Thank you very much :-D
  6. Photo

    RudiVisser Icon

    06 Sep 2011 - 00:37
    Thank you very much :-D
  7. Photo

    e_i_pi Icon

    05 Sep 2011 - 22:15
    Ah thank you :) I'm a fan of minimalism, so I wwanted something nice and simple, plus you just can't go past red and black!
  8. Photo

    no2pencil Icon

    05 Sep 2011 - 19:52
    Love your avatar!
  9. Photo

    Sayid Ahmed Icon

    13 Jul 2011 - 14:02
    thanks for the add.
  10. Photo

    Dormilich Icon

    17 Feb 2011 - 13:25
    just wanted to congratulate for the funny thread title "OOP, PDOs, pain, tears".
Page 1 of 1