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.