Jump to content

cmgmyr

Members
  • Posts

    1,278
  • Joined

  • Last visited

    Never

Everything posted by cmgmyr

  1. Thanks, I just made some changes to the page after the last post. I will try and fix this shortly. Any ideas?
  2. Hey, not a problem, glad I could help you out! -Chris
  3. UPDATE: I got it to not extend the background all the way down, but the footer is still not going to the bottom of the screen if there isn't enough content to fill it.
  4. 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
  5. 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
  6. See what this does. I think you got a little mixed up  :) [code=php:0]<?php include('config.php'); $get_sql = "SELECT game.game_id, game.home_id, game.visitor_id, team.team_id, team.name FROM game LEFT JOIN team ON game.home_id = team.id" or die(mysql_error()); $get_que = mysql_query($get_sql); $get_fet = mysql_fetch_array($get_que); echo $get_fet['name']; ?>[/code]
  7. I agree, I would go with MySQL - WAY easy to manage
  8. 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
  9. It should be in there, just do a search for php.ini in your Windows directory then open the file and search for upload_max_filesize. Then Change that to what ever size you want (The default is 2M) -Chris
  10. 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
  11. I like it, it looks good. My only suggestion is to decide what to do with your main page. What do you want your site to be focused on? Music stuff? Computer Stuff? Sports? I would pick one thing to feature on the main page and keep the rest of it as is. -Chris
  12. Looks good, I like it
  13. I also have to agree with all of the above. Looks like you will have your work cut out for you :)
  14. Hey Procode! Welcome to the forum! There are a lot of good people on here and I'm sure we can help you :) -Chris
  15. How about just this: [code]<!DOCTYPE html PUBLIC "-//w3c//DTD XHTML 1.1 //EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <head> <title>Simple Welcome</title> </head> <body> <?php print "Welcome to my home page <br />"; ?> </body> </html>[/code] -Chris
  16. i like it, good job as usual ;)
  17. 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
  18. Is there any reason why you have the "|" 's in the albums? It would be a lot easier to take those out. Then you could use my original query...
  19. 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
  20. 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.
  21. Can you post the 2 records from the database that you are reading from and also the html output you are getting?
  22. Ok...Instead of selecting everything, just select the ones that you want to output... $media = mysql_query('SELECT albums.directory, files.file FROM files LEFT JOIN albums ON (files.album=albums.id) ORDER BY timestamp DESC LIMIT 0, 1');
  23. Try just: $media = mysql_query('SELECT * FROM files LEFT JOIN albums ON (files.album=albums.id) LIMIT 0, 1'); See what happens with that.
  24. yes, it should expand with the content
  25. If you are matching up the album names wouldn't it be: $media = mysql_query('SELECT * FROM files LEFT JOIN albums ON (files.album=albums.name) ORDER BY timestamp DESC LIMIT 0, 1'); ...what you should do is make another key in files (a_id) for album id then it can be (files.a_id=albums.id) which would make it a lot easier
×
×
  • 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.