Help pulling in 'id' with "read more" link
Posted on
16th Feb 2014 07:03 pm by
admin
I'm trying to create snippets of my articles in the cms I'm creating, and then have them redirect to to a single
page entry of the article. Right now my snippets and "read more" links are dynamic and working fine, when I
click on the "read more" link it redirects to the 'single page entry' page, but it always pulls up the article
with id=1, even if the link is from id=23, and the adressbar reads articles.php?id=23.
How do I successfully pull up the corresponding id'd article?
any tips would be greatly appreciated!
Snippets:
Code: <?php
require("sources/connection.php");
$sql = "SELECT title, snippet, body_text, id FROM articles ORDER BY id DESC LIMIT 5" ;
$result = $conn->query($sql) or die(mysqli_error());
if($result){
while ($row = $result->fetch_object()){
echo "<h4>" . $row->title . "</h4>";
echo $row->snippet;
echo "</br>";
echo "<a href='/jquery/articles.php?id=" . "$row->id'";
echo ">< Read more ></a>";
}
}
?>
Articles:
Code: <?php
require("sources/connection.php");
$sql = "SELECT title, body_text, id FROM articles LIMIT 1" ;
$result = $conn->query($sql) or die(mysqli_error());
if($result){
$row = $result->fetch_object();
echo "<h4>" . $row->title . "</h4>";
echo $row->body_text;
}
?>
SQL:
Code: CREATE TABLE IF NOT EXISTS `articles` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`rel_id` int(20) NOT NULL,
`title` varchar(255) NOT NULL,
`snippet` longtext NOT NULL,
`body_text` longtext NOT NULL,
`who_id` varchar(50) NOT NULL,
`timestamp` int(20) NOT NULL,
`url` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
Thanks in advance!
No comments posted yet
Your Answer:
Login to answer
241 
44 
Other forums
Issue Parsing XML into table
Hello all,
Im a bit new to php and new to phpfreaks. But thanks in advance for the help!
<
tag inside php...
hi
Code: <?php
echo "<td width="$columnWidth%" align=&Renaming a file that a user uploads to site?
My site allows for registered users to upload images to the site under their own gallery. Currently present value of sequence?
Hi
Please help me to find out the present value of sequence?
Thanks How to write on database when a link is clicked?
Hi,
I have a list of products in a gridview. When the link is clicked currently it takes to an ext Mail Script Problems
I have created a PHP mail script. I am having a problem though. In $body i am trying to put two va COOIS - Saving Object Overview WIP Status layouts
COOIS - Would like to be able to save the layout of an Object Overview - WIP Status report. There i getting most records by count
Code: [Select]<?php
$connect = mysql_connect("localhost","dam Help with file_get_html
The following code gives the expected results:
<html>
<head&g scandir clients directory
hi,
how can i scandir the clients directory? i need a script that when i click a button it will u
| 
