Jump to content

Zane

Administrators
  • Posts

    4,362
  • Joined

  • Last visited

  • Days Won

    11

Posts posted by Zane

  1. @barand do you manually create those ascii chart/tables for db schemas or do you have some tool that does it?

     

    I always wondered the same thing

     

    I do it the laborious way. I have often thought of creating a tool (in fact every time I create a new diagram)

     

    Damn, that's a lot of work.  You must just be so used to it that you write it without thinking though.

  2. I'm looking for some side jobs, and by side jobs I mean not permanent.  I have extensive knowledge in web development, system administration, and system engineering.  Please feel free to PM me if you are interested.

     

     

    You think it, I make it.

  3. Moderation of first-time posts perhaps?

     

    That sounds like a PITA, but there is indeed a setting for it

     

    Moderate content of everyone in this group?

    YesNo   until   approved posts days since joining 

    Enter 0 or leave blank in second field to not limit by days/posts

  4. Use your datatypes the correct way.  Prices shouldn't be stored as a string, it will bite you in the ass in the future because you won't be able to order your queries correctly, much less query them correctly.  What happens when you want to search a range of prices?  You can't use the greater than less than symbols for strings, as far as I know.

     

    Anyway, the £ symbol has no purpose in a price column.  You can add that when you pull it out of the database.

    SELECT CONCAT('£', payRates) as payRates FROM yourTable

     

    Save yourself the frustration and use your datatypes.  It's so worth it!

  5. Give the anchor tag an id

     

     

    <a id='threelinks' href='#'>Open three tabs</a>

     

    then use jQuery (or Javascript )

     

     

    $("a#threelinks").on('click', function() {
     
         window.open('page1.php', 'first page');
         window.open('page2.php', 'secondpage');
         window.open('page3.php', 'third page');
         return false;
     
    });
    
×
×
  • 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.