ukscotth

sure. Basically it just pulls the data from the database and displays it : $texts= mysql_query("SELECT * FROM submittedtexts Order by id DESC LIMIT " . (($page - 1) * 6) . ", 6"); while ($got_texts = mysql_fetch_array($texts)){the code that simply displays the data}

Hi, Thanks, Ive been reading up about the date function but cant seem to get it working properly

Hi, I have a table that contains posts and each post has a datetime field. Im trying to work out how I can show entries from today, this week and this month so I can have a link that shows all posts from today or this month etc. Any one know how I can do this ? My current piece of code that pulls the data from the db looks like this : $texts= mysql_query("SELECT * FROM submittedtexts Order by id DESC LIMIT " . (($page - 1) * 6) . ", 6"); I want to add a bit that acts like : WHERE date = today Hope that makes sense, Im a bit of a newbie Thanks in advance, Scott

Solved. Thanks anyway.

Hi, Im trying to do this : <a class="good-night" href="#" onclick='voteup(<?php echo $got_texts['id'];?>)';>Go</a> But it wont seem to work. It doesnt see to like the php variable echo. Any ideas where I'm going wrong ? Many thanks, Scott

Hi, Anyone got any ideas to what I'm doing wrong with this piece of code ? function golink() { window.location.href('bumpbox.php?id=<?php echo $pageinfo['id'];?>\" class=\"bump\" rel=\"800-500'); } Many thanks in advance, Scott