cmgmyr
-
Posts
1,278 -
Joined
-
Last visited
Never
Everything posted by cmgmyr
-
Thanks, I just made some changes to the page after the last post. I will try and fix this shortly. Any ideas?
-
You have "x" amount of characters remaining?
cmgmyr replied to Solarpitch's topic in Javascript Help
Hey, not a problem, glad I could help you out! -Chris -
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.
-
You have "x" amount of characters remaining?
cmgmyr replied to Solarpitch's topic in Javascript Help
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 -
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
-
Help with designing the perfect football/soccer player stats database
cmgmyr replied to JJohnsenDK's topic in PHP Coding Help
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] -
[SOLVED] Message system, mysql or txt files?
cmgmyr replied to ted_chou12's topic in PHP Coding Help
I agree, I would go with MySQL - WAY easy to manage -
Help with designing the perfect football/soccer player stats database
cmgmyr replied to JJohnsenDK's topic in PHP Coding Help
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 -
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
-
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
-
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
-
Looks good, I like it
-
I also have to agree with all of the above. Looks like you will have your work cut out for you :)
-
Hey Procode! Welcome to the forum! There are a lot of good people on here and I'm sure we can help you :) -Chris
-
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
-
i like it, good job as usual ;)
-
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
-
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...
-
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
-
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.
-
Can you post the 2 records from the database that you are reading from and also the html output you are getting?
-
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');
-
Try just: $media = mysql_query('SELECT * FROM files LEFT JOIN albums ON (files.album=albums.id) LIMIT 0, 1'); See what happens with that.
-
yes, it should expand with the content
-
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