Write Forums

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

241 44 Tweet

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
my login script page is not working on remote computers 
hi my login is working on my computer, but when i tried 2 computers from 2 different locations, they
Help building / using array 
First - this is a cross-posting, if this is wrong I apologise! What started out as a MySQL query que
question about stripslashes and real_escape_string 
im cleaning up an old app that I wrote fixing some of the vulernabilities from attacks.

I hav
Company Code for Vendors created through Business Partners 
Hi, experts!



I'm trying to set up the integration between Business Partner (BP) and Vendo
Bit manipulation program with binary operations 	 
My homework is to create a program to scan in and add binary numbers and print them like so

mails going in spam?? 
The mails I sent to folks in my database using mail(function) are going in spam??

Any idea ho
Production of mango in processing industry 
Hi,



We have one scenario ,company is in process industry,they are manufacturing MANGO pul
Do While statement 
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const