Jump to content


  • Posts

  • Joined

  • Last visited


Posts posted by cmgmyr

  1. here is my top 10 rating query:


    SELECT rate.bandid, count(rate.bandid) as totalcount, avg( rate.rating ) as average, users.name FROM rate INNER JOIN users on (users.userid = rate.bandid) WHERE users . type = 'b' GROUP BY rate.bandid having totalcount >= 10 ORDER BY average DESC, users.name ASC LIMIT 10

  2. start off with 3 tables























    Take a look at my site: www.SyracuseBands.net you might get some other ideas too


    Hope this gets you started in the right direction

  3. don't get me wrong...I don't mind if the are here working and taking care of their family...just be a legal citizen and don't think that if you are a minority or alien that everyone else should conform to what you want and/or your culture.


    Prime example...Did you guys see the email going around? ...about some school in CA flying the mexican flag over the American flag PLUS flying the American flag upside down! If you didn't get it I think I still have it, I can post pics if you want, or PM me your email and I'll just forward it to you. But anyways...that should not be tolerated.

  4. No, sorry that had nothing to do with pay. I don't know if you get it in the news over there but we have been having some imigration problems lately. Like people just walking over and now suddenly they are "Americans". Thats all I was refering to :)

  5. very nice, I like it a lot. Just a new small things:


    - On your main nav (bubbles) on the hover I would make the text darker not lighter and I would make the red bullet a little brighter.

    - maybe a little more padding on the body text and in the right hand boxes.


    looks great though!

  6. I just started doing it full time a few months ago, but my projections for the first year (from the money I've already made) will be about $35K this year. As I've said in various other posts I usually charge a flat rate/project that comes out to about $40-$50/hr. The other point that I would like to make is that I DON'T work a full 40 hrs/week...which could be a good or bad thing...I think it's great! :)

  7. try this:

    $userid = 1;
    echo fill($userid,6);
    function fill($val,$properlen){
    $properlen = $properlen - $l;
    while ($i<$properlen)
    return $tmpstr;

  8. Well with the application layer you have your gui and actual program, transport brings it down to binary, network puts it into packets, link sends it over the physical.



    ...I think I got that right, it's been a while since i've done this

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.