cturner Posted October 20, 2006 Share Posted October 20, 2006 Can someone please tell me how I can do what is in the subject? Thanks in advance.Here is the code that I am working with:[code]require "config2.php";// display each article title with the date// get the current day$currentday = date("j",mktime());// get the current month$currentmonth = date("F",mktime());// get the current year$currentyear = date("Y",mktime());// select the current article//$currentquery = mysql_query("SELECT * FROM `items` ORDER BY STR_TO_DATE(CONCAT(selectDay, selectMonth, selectYear), '%d%M%Y') DESC");$currentquery = mysql_query("SELECT * FROM `items`");while($row = mysql_fetch_array($currentquery)) { echo "<br /><br /><a href=article.php?articleid=".$row['articleid'].">".$row['selectMonth']." ".$row['selectYear']."</a>";}// display the current article//while($row = mysql_fetch_array($currentquery)){ //echo "<br /><br />".$row['selectDay']." ".$row['selectMonth']." ".$row['selectYear']."<br />"; //echo "<a href=article.php?articleid=".$row['articleid'].">".$row['articletitle']."</a>";//}mysql_close();[code][/code][/code] Quote Link to comment Share on other sites More sharing options...
cturner Posted October 21, 2006 Author Share Posted October 21, 2006 Anyone please help urgent? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.