Hi, i did make a search foir the possible of my problem with offset (well, i "think" thats the problem) and didnt find a solution.
So, i would apprecciate some help with the issue.
I have this member list: http://www.animerate.com/miembros.php (its a review community)
Click on any members name, and it will display the reviews the user has posted since the beggining. (actually, in the future i will need to display ALL reviews, for the moment i can only display 1 Review [ROW]).
In the page with the profile, you can see there's a date of when the reviews was post (that date is totally correct), BUT, when you go to the review (trhu that Complete Review >> link), the original date that was posted changes to today's date, i know it doesnt chenge for real, but when you browse trhu ALL the website, ALL review's dates change their display to today's date.
Here's my code:
<?php
require ( "config.php" );
require ( "common.php" );
require ( "includes/mysql.php" );
require ( "includes/interface.php" );
require ( "includes/inc_reviews.php" );
require ( "includes/functions.php" );
require ( "global_config.php" );
global $CONFIG_VAR;
//include_template ( $CONFIG_VAR['page_header_template'] );
// This creates the start of the main body table
//echo "<!-- Start of main body table -->\n\n";
//echo "<table width=\"" . $CONFIG_VAR['body_width_value'] . "\" align=\"center\" cellspacing=\"0\" border=\"0\" cellpadding=\"0\">\n";
//echo "<tr>\n";
// This creates the lefthand menu column
//include_template ( $CONFIG_VAR['left_column_template'] );
// This creates the middle table
//echo "<!-- Start of middle column -->\n\n";
//echo "<td valign=\"top\">\n";
// This creates the breadcrumb trail
//breadcrumbs( $page );
$query = "SELECT mnl_members.email,
mnl_members.reviews,
mnl_members.last_review_date,
mnl_members.date_registered,
mnl_reviews.review_score,
mnl_reviews.review_title,
mnl_reviews.reviewer_name,
mnl_reviews.date_added,
mnl_reviews.review_id,
mnl_items.cat_id ,
mnl_items.sub_cat_id ,
mnl_items.item ,
mnl_items.item_id ,
mnl_items.image_source
FROM mnl_members,mnl_reviews,mnl_items WHERE
mnl_reviews.reviewer_name = mnl_members.username and
mnl_items.item_id = mnl_reviews.item_id and
mnl_members.username='$username' ";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)) {
$username = $_GET['username'];
$offset = $_GET['offset'];
$date_registered = $row['date_registered'];
$reviews = $row['reviews'];
$review_score = $row['review_score'];
$review_title = $row['review_title'];
$date_added = $row['date_added'];
$email = $row['email'];
$last_review_date = $row['last_review_date'];
$image_source = $row['image_source'];
$item = $row['item'];
$item_id = $row['item_id'];
$cat_id = $row['cat_id'];
$sub_cat_id = $row['sub_cat_id'];
$review_id = $row['review_id'];
}
echo " User: <b>$username</b><br> \n";
echo " Member since: <b>$date_registered</b><bR> \n";
echo " Email: <b>$email</b><bR> \n";
echo " Total Reviews: <b>$reviews</b><br> \n";
echo " Last Review: <b>$item</b> <i>on $date_added</i><br>\n";
echo " Review title: <b> $review_title</> - <b>MY Score: </b>$review_score <img src=\"$image_source\" border=1 width=70 height=70 align=absmiddle><br> \n";
echo " <a href=\"review.php?review_id=" . $review_id . "&item_id=" . $item_id . "&cat_id=" . $cat_id . "&sub_cat_id=" . $sub_cat_id . "&offset=" . $offset ."\"><b>Complete Review >></b></a>\n";
//echo "</td>\n";
//echo "<!-- End of middle column -->\n\n";
// This creates the right hand menu column
//include_template ( $CONFIG_VAR['right_column_template'] );
// This ends the main body table
//echo "</tr>\n";
//echo "</table>\n";
//This creates the page footer
//include_template ( $CONFIG_VAR['page_footer_template'] );
?>
Any help would be aprecciate it.
P.D I opened this new thread because the other has different problem, same project... but different problem, so it will help in the future for searching purposes.
