Chicken Little

Try using CURDATE, this should get you yesterday SELECT * FROM users WHERE DATE( joindate ) <= DATE_ADD( CURDATE( ) , INTERVAL -1 DAY ) ORDER BY joindate DESC

Ok. If your field is called end you can use SELECT * FROM test WHERE DATE( end ) = DATE_ADD( CURDATE() , INTERVAL +1 DAY ) ORDER BY end DESC

Assuming your table has a date field (here called date_created) you can use SELECT * FROM test WHERE DATE(date_created) >= DATE_ADD( CURDATE( ) , INTERVAL +1 DAY) ORDER BY date_created DESC

Try using JOIN.

Does the users table exist? Add the following to the $result query or die(mysql_error()); If it does, it will need the username and password so you can login. Also, try changing if(mysql_num_rows($result)!='0'){ to if(mysql_num_rows($result) > '0'){ and in the form action change to <?php $_SERVER['PHP_SELF']; ?>

I've gotten this to work with a similar database. You may be able to modify where needed. $result = mysql_query("SELECT * FROM games ORDER BY games.game_id DESC LIMIT 5",$link); while($row = mysql_fetch_assoc($result)) { $result2 = mysql_query("SELECT * FROM players WHERE game_id='{$row['game_id']}'",$link); $nrows=mysql_num_rows($result2); echo "Game Number: " .$row['game_id']. "</br>"; echo "A " .$row['gf']. "-" .$row['ga']. "-" .$row['winner']. "<br/>"; echo "Scorers:<br/>"; echo "<center><table border='1' width='100%' bordercolor='#413326'> <tr> <th align='center' BGCOLOR='#413326'><FONT COLOR='#FFFFFF' size='3'>Lastname</font> <th align='center' BGCOLOR='#413326'><FONT COLOR='#FFFFFF' size='3'>Goals</font> <th align='center' BGCOLOR='#413326'><FONT COLOR='#FFFFFF' size='3'>Assists</font> <th align='center' BGCOLOR='#413326'><FONT COLOR='#FFFFFF' size='3'>Points</font></tr>"; if($nrows >0) { while($row2 = mysql_fetch_assoc($result2)) { echo "<tr>"; echo "<td width='7%'>" .$row2['lname']. "</td>"; echo "<td width='7%'>" .$row2['lnameg']. "</td>"; echo "<td width='7%'>" .$row2['lnamea']. "</td>"; echo "<td width='7%'>" .$row2['lnamep']. "</td>"; echo "</tr>"; } echo "</table></center>"; } }

Very nice. Maybe decrease the height of the "OurSponsors" section or move it just below the "FeaturedMatch" section.

Are these colors the adopted colors of the crew? or should there be some hint of BSA colors? Maybe change the green to spruce-green and the black to charcoal gray? Home: Need more content to welcome the visitors. Consider a smaller "vote" image. Font size changes by page. Check your CSS. Calendar: The page is actually a schedule of events. Consider renaming the page to events or schedule or something. Or develop a calendar. Past Events: Nice gallery. Maybe add a caption to each image? About: Exceptional content. Contact: Consider replacing the email text with an image. Or develop a contact form. Gray on black is hard to see in footer.

Too many links in the nav section at top. Consider placing the login and register into a section box and position the box above the quick links. Move the legal and copyright to the bottom, in a footer. Add year to copyright. Place W3C icon in footer. The quick links section is redundant. Remove or replace with relevant quick links (such as popular forum posts, or faq, or a neat tool). The other section is also redundant. Users prefer regular caps rather than all caps for news titles.

The color scheme seems all wrong. It should reflect what the site is about and what you are offering. The white background does little for this. Try looking at some gaming sites and some CMS sites and merge the schemes. Is it ClanSystem or Clan System? Home: Needs a bit more elaboration for the first two paragraphs (spelled achieve, not acheivce). Ditto the news section. Suggest moving the GameServers image into the header. Move the copyright into a footer. What's the PayPal image for? Move the online support lower in the page and make image smaller. About: Need to add more content. Give some examples of what you do and some future concepts. Any testimonials? Features: Should this be the Smarty templating engine? The copyright and PayPal obscure some text. Contact: I get the following error when trying to access the page Fatal error: Cannot redeclare db_connect() (previously declared in /home/publicwa/clan-system.com/includes/functions.php:3) in /home/publicwa/clan-system.com/includes/functions.php on line 3 Demo: Nice images. Purchase: Like the features page, the copyright and PayPal obscure some text.

The Google ad is the first thing I see. Move it to the bottom, make it vertical and move to the side, or get rid of it. I viewed a few templates and started making some notes but soon got lost with the various changes. Some of the templates resulted with faulty pages (I'm using IE 7). I suggest you stick with one structural template but offer a selection of colors and/or font sizes based on accessibility (i.e vision/color challenged users).

You should normalize your table, put the games into one table and the players into another. You then do a JOIN for the data you need. Also, if you want to see the last five your sql should DESC LIMIT 5.

It should be faster and more efficient. For more info see http://dev.mysql.com/doc/refman/5.1/en/fulltext-search.html

Add some monkeys to the banner!? I'm not a fan of black backgrounds but the contrast with the image borders and the white font works. Would the navigation section work better on the left? or below the banner? Needs an intro to the site and what you are trying to present. Move the stories to a separate page and enable image click to view posted story. Increase image resolution for larger images. Move your bio stuff that repeats on each page to the portfolio page and beef up your portfolio with more than just images. The contact page does not load. Increase font size in username field for login form. Ditto for username and email fields in register form. Needs a better redirect for login when errors occur. Enforce username to have more than 5 and less than 15 characters. Make these alphanumeric or allow some other special characters. Enforce the password to be at least 8 characters, alphanumeric, case sensitive, and allow only certain non-alphanumeric characters. Some typos.

Maybe develop a home page with a brief intro. Right now the home page is the About Us page and the links at the bottom seem redundant. Three of the image links on the right of the about us page are redundant and are found in the tab portion at the top or the navigation on the left. I'm not too keen on your use of the navigation section on the left as they change from page to page or are non existent on some. The navigation needs some consistency. By the way, it's spelled puzzle and not puzzel.

Straightforward, easy to read and navigate. Not being from the area I wasn't sure what the maple leaf was supposed to represent. Perhaps changing this to look like the leaf is in flowing water?

Maybe add some of the header starry effect to the content or the content pattern to the header to better tie in the two visually. Adding a background image with both starry effect and pattern might work better than the single color. The navigation text font reminds me of the old Atari screen text (choppy). Try to match the navigation and content font. Consider adding a contact form. Consider beefing up your registration form.

There needs to be a better contrast in color (background vs. content) to make your info stand out a bit better. As seen in IE 7 the background is white. The header banner doesn't jump out very well. Consider moving the text closer to the center and/or adding an icon. Separate the register and login to display on different pages. Align the error message(s) closer to the center and change font color to red. With this many fields you might consider some client side validation. Enforce username, first name, and last name to have more than 5 and less than 15 characters. Make these alphanumeric or allow some other special characters. Question: Is there a way to restrict the day select when some months have less than 31 days? Or maybe have a server side script do the check? The year should be a select box rather than allowing the user to enter their own. The year 1111 allowed a successful registration. Enforce the password to be at least 8 characters, alphanumeric, case sensitive, and allow only certain non-alphanumeric characters. After correctly registering and logging in the user is taken to an intermediate page then after a brief moment taken to the home page. Skip the intermediate page. Once back at the home page there is no sign that I am actively logged in except the "logout" text in the navigation bar and the very small (and hard to see) note in the footer. Can you add to the log in header something that shows the user is logged in. Sort of like done in this forum where the user is shown at the top like "Hello Chicken Little". I was unable to load a picture in the profile section. After logging out skip the intermediate page.

Are you sure it is a Smarty problem? Do you have error reporting turned on?

Try using Notepad.

Open your Smarty.class.php and scroll down to where it says something like "this enables template caching" and check if var $caching = 0, 1, or 2;

in the php.ini file set the following display_errors = Off

Simple and to the point. However, the banner is too simple and takes up too much space. Consider adding more text to the banner, maybe some text in italics, some in other fonts, something to fill in the banner. Maybe add some more content to the home page to entice the user to visit the other pages. Example for the Humor link ..."Did you hear the one about the chicken and the crow that went fishing"...Do the same for the Games link sort of like ..."Was Leif really lucky on his voyage??? This game has the answer..." Probably nix the About Me link on the home page since you have a page devoted to yourself already. Games page: Consider adding a caption for the games so the user knows the title of the game. Humor/catz:Nice collection of catz! Maybe turn the images into a gallery so the user isn't scrolling down.

Can you try a cascading delete from the parent table? (i.e. set table structure to allow this)

A quick comment: Should $loginName = mysql_real_escape_string($_POST['usrnme']); be $loginName = mysql_real_escape_string($_POST['username']); note 'username' versus 'usrnme' and further down header("Location: $_GET[ret]"); be header("Location: $_GET['ret']"); note the single quotes for ret