brown2005

SELECT * FROM events ORDER BY events_date ASC is what I have at the moment, but I want to change that to only include dates today and in the future..

Selecting two tables in a mysql query.. or selecting one table and using functions to get individual values from other tables.

lonewolf217 - yours does not seem to work Mardoxx - all yours works.. which moves me onto my next question.. which one should I use? which is better practice? which is faster? Thanks

i have $_GET['county']; and $sql = mysql_query("SELECT * FROM comps ORDER BY date DESC"); now what i want to do is say if $_GET['county']; is null $sql = mysql_query("SELECT * FROM comps ORDER BY date DESC"); and if not null $sql = mysql_query("SELECT * FROM comps WHERE county='$_GET['county']' ORDER BY date DESC"); what is the easiest way to do this please.

http://www.allinthissite.co.uk/index/index.php?page=home that is the site, so you can see what i mean. where it says welcome, there should be a space of 6px as underneath the box the welcome text is in.

Hi, can you take a look at.... http://www.fantasy-comps.com/index/index.php?page=home I have a featured content glider. but its not working.. when you click on next event.. it does nothing.. but click on welcome after. it works.. thanks

I have sorted it now thanks.. i removed the height: 100% from container tag and added overflow: hidden instead of auto

sorry. now try the above link. had taken the site down for a minute. and just put it all back up.

http://www.fantasy-comps.com/index/index.php?page=terms as you can see the white main part has not strecthed with the writing. how can i make this do this. i tried overflow: auto; in the content div. but that puts a scroll bar in the div, which I dont want. Thanks

Hi, I find it easier writing all my code in php, but will this make my website more slower?

Hi, I want to creat a tree menu, but using bars instead of the tree icons.. any tutorials anybody knows about?

http://www.robotstxt.org/orig.html

hi, thanks for the replies, would you be able to show me the code for this please as I am very new to arrays and have not really used them. thanks

I have 20 players player1, player2, etc, etc. and 20 teams team1, team2, etc, etc. I would like to randomly assign the teams to the players. how can I do this please?

what i mean is at the start the menu will be... <ul> <li class='active'>Home<li> <li>Page1<li> <li>Page2<li> </ul> if i click on page1 then it will be <ul> <li>Home<li> <li class='active'>Page1<li> <li>Page2<li> </ul> and so on.... what I want to know is; what can I do to automatically remove the class from one page and put it onto another, when the page is selected.

hi i have a class .active { } and the menu <ul> <li class='active'>Home<li> <li>Page1<li> <li>Page2<li> </ul> When I select a new page how can I chagne the active part to the appropiate page? Thanks in advance

http://www.stumbleupon.com/toolbar/#url=http%2525253A//letsbefriends.blogspot.com/ look at that website.. and look at the scroll bar on the right. the bottom arrow is missing as the frame has gone 100% of browser window. not the div... how can i correct this. (this is not my website but its the same problem)

thank you very much. I thought I tried that, but obviously I did not do it correctly.

echo'<span id="stats">'. echo CountProfiles(); .'</span>'; how can i get that to work please?

can you show me what you mean? link?

how can I get this iframe to have the bottom arrow in as well and not disappear under the browser. thanks

thank you. works perfectly.

I have a table emails emails_id emails_email and what I want to do is delete records that have multiple emails_email in. any help please? and before anyone says stop this on registration, I have now done this, but just want to get rid of the duplicates I already have. Thank you in advance

#network { position: absolute; top: 0px; left: 0px; overflow: auto; width: 100%; height: 30px; line-height: 30px; } * html #network { height: 30px; } #networkleft { float: left; background: url(left.bmp) !important; width: 115px; height: 30px; } #networkcenter { float: left; background: url(center.bmp); width: 500px; height: 30px; } #networkright { float: right; background: url(right.bmp) !important; width: 15px; height: 30px; } when i change networkcenter to width:100% it goes all wrong, how can I change the css code to make the middle image repeat as much as is avalible. thanks

http://www.allinthissite.co.uk/ I have done the code to show you the layout I am looking for. What I want to do is take some results from mysql; topics_name and use this to set the layout as seen on the website above. It will only display the letter if there is a result in the table that has that letter, so topics_name first letter sets this header. any help please on the code I would need to achieve this layout. Thanks in advance.