Hi i am new to php and i am currently trying to develop a latest blog page with a read more link. However when i enter the following:
echo "<a href='posts.php?id=" .$row_post['id']."'>Read More....</a>;
it keeps returning the wrong id, the query has been done using a left join on users table id= author_id.
I need the blog_post id, but it returns the author id. Please help i ve been trying to crack this for ages, going slightly crazy!!!
<?php require_once("Connections/myblog.php"); ?>
<?php
$maxRows_post = 5;
$pageNum_post = 0;
if (isset($_GET['pageNum_post'])) {
$pageNum_post = $_GET['pageNum_post'];
}
$startRow_post = $pageNum_post * $maxRows_post;
mysql_select_db($database_myblog, $myblog);
$query_post = "SELECT *, DATE_FORMAT (`datePosted`,'%d-%m-%y')as newdate FROM blog_posts LEFT JOIN users ON users.id = author_id ORDER BY blog_posts.datePosted DESC";
$query_limit_post = sprintf("%s LIMIT %d, %d", $query_post, $startRow_post, $maxRows_post);
$post = mysql_query($query_limit_post, $myblog) or die(mysql_error());
$row_post = mysql_fetch_assoc($post);
if (isset($_GET['totalRows_post'])) {
$totalRows_post = $_GET['totalRows_post'];
} else {
$all_post = mysql_query($query_post);
$totalRows_post = mysql_num_rows($all_post);
}
$totalPages_post = ceil($totalRows_post/$maxRows_post)-1;
?>
And then on the page the php is:
<?php include ("includes/config.php");
do {
echo "<h2>" .$row_post['title']."</h2>";
echo "<div class='publish'> Posted By". " ".$row_post['username']. " " .$row_post['newdate']."</div>";
echo "<div class='blog'>";
echo "<p>" .$row_post['introtext']. "</p>";
echo "</div>";
echo "<a href='posts.php?id=" .$row_post['id']."'>Read More..</a>";
echo "<div class='blog_line'></div>";
}
while ($row_post = mysql_fetch_assoc($post));
?>
url,varibles and left join
Moderator: General Moderators
Re: url,varibles and left join
Try putting users.id AS `id` in the select clause.
Re: url,varibles and left join
do you mean blog_post.id as id?
Re: url,varibles and left join
Sorry, yeah, I didn't read your post properly 
Re: url,varibles and left join
trying that and it tells me unknown coloumn blog_post.id
Re: url,varibles and left join
Your a star, got it!! I have been playing with this for ages and could t figure it out!!
Thanks
Thanks
Re: url,varibles and left join
Cool, nice one. No problem 
Re: url,varibles and left join
This is an inappropriate use of do-while. If there are no rows returned by the query, this code will throw "undefined index" errors.
Use just while instead.
Edit: This post was recovered from search engine cache.
Code: Select all
$row = mysql_fetch_assoc($result);
do {
echo $row['field'];
} while ($row = mysql_fetch_assoc($result));Code: Select all
while ($row = mysql_fetch_assoc($result)) {
echo $row['field'];
}