Jump to content

cmgmyr

Members
  • Posts

    1,278
  • Joined

  • Last visited

    Never

Posts posted by cmgmyr

  1. Hey, Try this out...

    The JS[code]<script>
    function textCounter(field, countfield, maxlimit) {
    if (field.value.length > maxlimit) // if too long...trim it!
    field.value = field.value.substring(0, maxlimit);
    // otherwise, update 'characters left' counter
    else
    countfield.value = maxlimit - field.value.length;
    }
    </script>[/code]

    The HTML[code]<textarea name="profile" cols="50" rows="10" id="profile" wrap="virtual" onKeyDown="textCounter(this.form.profile,this.form.remLen,300);" onKeyUp="textCounter(this.form.profile,this.form.remLen,300);"></textarea> *</div>
    <input readonly type=text name=remLen size=3 maxlength=3 value="300" ID="Text1">(characters left)[/code]

    Hope this helps you out.
    -Chris
  2. Hey everyone,

    Please take a look at:

    http://syracusecs.com/deluca/temp.html - No content
    http://syracusecs.com/deluca/temp2.html - Content
    http://syracusecs.com/deluca/css/style.css

    The problem that I'm having is that with the page with no content I can't get the footer to attach itself to the bottom of the page. If you look at the page with content you will see how I need this to look. The page that doesn't have content has a lot of overflow on the bottom. If I can get the 2 footers to attach to the bottom...problem solved.

    Please let me know how to fix this, or if you have any other ways I can do this, I'm pretty much open for anything as long as it looks like it supposed to look. Please let me know if you need anyother information or need to clarify anything.

    Thanks,
    -Chris
  3. I would start off by doing something like this:

    Players
    -------
    player_id
    fname
    lname
    team_id

    Teams
    -------
    team_id
    name
    coach

    Games
    -------
    game_id
    home_id
    visitor_id

    Stats
    -------
    stat_id
    game_id
    player_id
    more stat information...

    I hope this gets you going in the right direction. The main thing that you want to think about when working with databases is that you don't want duplicate information, like in the stats table you don't want the player name...you aleady have that in the players table.

    Please let me know if you have any other questions

    -Chris
  4. This might be a stupid question...but I'm asking it anyways...I've been asked to set up a website so that it shows up in overseas search engines. Would this be any different then US search engines? Would I need to register a co.uk domain? Does anyone have any insight to this?

    Thanks,
    -Chris
  5. What was the error?

    Try and see what this does:
    $media = $turbo->get_all("SELECT files.file AS file,
    files.album =".ereg_replace($bars, $removebars, files.album)." AS album,
    files.timestamp AS timestamp,
    albums.id AS id,
    albums.directory AS directory,
    FROM files LEFT JOIN albums ON files.album=albums.id
    GROUP BY files.album ORDER BY files.timestamp DESC");

    Prob won't work, but worth a try
  6. 1.  Would you expect this be an efficient database design?  If not what is a better way?

    - Yes, the only thing that I see that is not totall efficient is that you have the category id in the product table. Since you can do a query with the sub category to get the main category this is not totally needed. BUT I think I would keep it just because it would be easier to make queries and to connect data together without having to do a bunch of joins.

    2.  What having meta description data and page titles in a database the best way to handle these items?

    - Yes, this is a very good way to keep track of meta data with your items. If you want you could make another table to meta data, but I would keep it how it is.

    3.  What is the best way to build site navigation based on this design?  Just pull from category tables and loop through an array?  Also can DHTML menus be used if I pull my navigation from a database?

    - Pull from the category/sub-category tables with a loop, use CSS to format them :)

    Good job on the layout, you have a great start.

    -Chris
  7. Ok, I think part of your problem is "|1763|" does not equal "1763".

    Try this:
    First find the record that has the latest timestamp, get the "album", strip out the 2 "|" 's
    Then, have a second query to get all of the stuff from the album table

    This might be a little more bulky, but it will work for you.
×
×
  • 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.