I’m trying to change the way my blog displays posts on the main page. Currently it just shows all the entries from the most recent day I posted, but I want to change it to show any entries from the last 7 days. The challenge has been to get it to echo a box with the date once for each day, rather than once for each entry. I have it ALMOST working, but when I implement the changes, my sidebar disappears!
This is my test page and the pages which are required on the test page (except config.php, which is just db login info). Everything seems to work except the sidebar.
test.php:
[code]<?
$level = ‘5’;
require(“config.php”);
#######################################################
// functions
#######################################################
// opens a box
function open_box()
{
echo "
|
";
}
// opens a bordered box
function open_b_box()
{
echo "
|
";
}
// creates a box that displays the title of the domain, plus a variable page title or date
function title_box($domain_title, $page_title)
{
// makes the domain title global
global $domain_title;
// opens bordered box
open_b_box();
// echos domain title and variable page title
echo "<h1>$domain_title</h1><h2>- $page_title</h2>";
// closes bordered box
close_b_box();
}
function title_box2($page_title)
{
// opens bordered box
open_b_box();
// echos domain title and variable page title
echo "<h2>$page_title</h2>";
// closes bordered box
close_b_box();
}
// replaces names with links to photos
function photo($timestamp,$entry,$name1,$name2)
{
$sql = “SELECT * FROM gallery WHERE timestamp<’$timestamp’ AND $name1=‘1’ ORDER BY src DESC LIMIT 4”;
$result_photo = mysql_query($sql);
while($row_photo = mysql_fetch_array($result_photo))
{
$photo = $row_photo[‘id’];
}
$entry = str_replace(' '.$name2,' <a href="http://gallery.usr-bin-mom.com/gallery.php?id='. $photo . '&filter=' . $name1 . '" target="_blank">' . $name2 . '</a>',$entry);
return $entry;
}
open_db();
// start code for copying
require(“header.php”);
$num_entries = ‘0’;
$title_box = ‘0’;
// THIS IS THE WHILE LOOP THAT IS A PROBLEM!
while($num_entries<‘7’)
{
$last_date = date(“l F d Y”,strtotime("$num_entries days ago"));
// select entries from this day
$result = mysql_query("SELECT * FROM journal WHERE security<$level AND FROM_UNIXTIME( timestamp, '%W %M %d %Y' ) = '$last_date' ORDER BY timestamp DESC") or die (mysql_error());
if ($row = mysql_fetch_array($result))
{
if($title_box=='0')
{
// title box
title_box($domain_title, $last_date);
}
else
{
// title box
title_box2($last_date);
}
$title_box++;
}
// select entries from this day
$result2 = mysql_query("SELECT * FROM journal WHERE security<$level AND FROM_UNIXTIME( timestamp, '%W %M %d %Y' ) = '$last_date' ORDER BY timestamp DESC") or die (mysql_error());
// for these entries...
while ($row = mysql_fetch_array($result2))
{
extract($row);
// gets time
$time = date("h:i a",$timestamp);
// opens bordered box
open_b_box();
$entry = photo($timestamp,$entry,'Mark','mark');
$entry = photo($timestamp,$entry,'Aryanna','aryanna');
$entry = photo($timestamp,$entry,'Aryanna','anna');
$entry = photo($timestamp,$entry,'Aoghdan','aoghdan');
$entry = photo($timestamp,$entry,'Seamus','seamus');
$entry = photo($timestamp,$entry,'Hamish','hamish');
$entry = photo($timestamp,$entry,'Sinead','sinead');
// title and entry
echo "<h3>$title</h3><br>$entry";
// if there is a prayer...
if ($blessing)
{
// prayer icon and prayer
echo "<br><br><img src="images/prayer.gif"> $blessing";
}
// time posted
echo "<br><br>posted @ $time -- ";
// creates comment link
$result_nineteen = mysql_query ("SELECT id FROM comments WHERE entry=$id");
$num_rows = mysql_num_rows($result_nineteen);
if($num_rows)
{
echo "<a href="index.php?page=entry&id=$id">comments ($num_rows)</a>";
}
else
{
echo "<a href="index.php?page=entry&id=$id">comments</a>";
}
// closes bordered box
close_b_box();
}
$num_entries++;
}
require(“footer.php”);
?>[/code]
header.php:
[code]
<? global $usrbinmom_layout_cookie; if(!$usrbinmom_layout_cookie) { open_db(); $result=mysql_query("SELECT skin AS usrbinmom_layout_cookie FROM users WHERE id='1'"); while($row=mysql_fetch_array($result)) { extract($row); } } function header_middle() { print" "; } if($usrbinmom_layout_cookie == "cebu") { // stylesheet print" #!/usr/bin/mom: song of the cebu td { font-family : Verdana,Geneva,Arial,sans-serif; font-size : 10px; text-align : justify; TEXT-TRANSFORM: lowercase;} h1 { margin : 0px; font-size : 16px;} h2 { margin : 0px; font-size : 10px;} h3 { margin : 0px; font-size : 10px;} A.footer { color:#cccccc; } .footer { color: #cccccc; } .box1 { background-color : #e6d8d4; border : 1px solid #000000; text-align : justify; TEXT-TRANSFORM: lowercase;} .box2 { font-family : Verdana,Geneva,Arial,sans-serif; font-size : 10px; text-align : justify; TEXT-TRANSFORM: lowercase;} .box3 { font-family : Verdana,Geneva,Arial,sans-serif; font-size : 10px; text-align : justify; TEXT-TRANSFORM: lowercase;} "; header_middle(); // begin layout print"";
}
elseif($usrbinmom_layout_cookie == "nobody")
{
$year_for_link = date('Y');
// stylesheet
print"
#!/usr/bin/mom: my friend's name is nobody
td,form { font-family : Verdana,Geneva,Arial,sans-serif; font-size : 10px; text-align : justify; TEXT-TRANSFORM: lowercase;}
h1 { margin : 0px; font-size : 16px;}
h2 { margin : 0px; font-size : 10px;}
h3 { margin : 0px; font-size : 10px;}
A.footer { color:#cccccc; }
.footer { color: #cccccc; }
.box1 { background-color : #ffffff; border : 1px solid #000000; text-align : justify; TEXT-TRANSFORM: lowercase;}
.box2 { font-family : Verdana,Geneva,Arial,sans-serif; font-size : 10px; text-align : justify; TEXT-TRANSFORM: lowercase;}
.box3 { background-color : #ffffff; border : 1px solid #000000; text-align : justify; TEXT-TRANSFORM: lowercase;}
";
header_middle();
// begin layout
print"
|