Print an article to screen

[dagger2002]

I have my database and it connects to my site.
I was wondering how to print the information on a specific article when i give it the id.

heres the connection string

<?
	$ntouquery = "SELECT id, title, text, date FROM stories WHERE include = 1 AND supe = 0 ORDER BY date DESC";
	$ntouresult = mysql_query($ntouquery) or die("Error with the query.");
	$num_ntou_rows = mysql_num_rows($ntouresult);
	while ($row = mysql_fetch_array($ntouresult)) {
		echo "<li><a href=\"$thisURL/comm_newsPR.php?id=$row[0]\"> $row[1]</a></li>";
//		<a href=\"$thisURL/comm_newsPR.php?id=$ntourows[0]\">$ntourows[1]</a>
	}
?>

thanks
David

 

[steven290]

what do you mean by print

- print to screen
- or print to printer

 

[dagger2002]

print to screen.

 

[Vragabond]

What seems to be the problem? In comm_newsPR.php you should open a query that reads the information from the database that contains the message of the article. Something in the likes of

$query = "SELECT id, title, text, date FROM stories WHERE id = " . $_GET['id'];

From there on it is just outputting the result (same as the aforementioned page) and styling the information. If you have specific question about any of those, let us know.

 

[dagger2002]

HOW DO I PRINT IT?

how to print the information on a specific article

 

[DRJ478]

print $row['text'];
# or
echo $row['text'];

 

[dagger2002]

that didn't work got the same thing.

nothin
but ty

 

[DRJ478]

I'm sorry, but there must be some part of the communication getting lost or there must be some misunderstanding.
Here are the steps:
1. Page is built the first time, list of anchors is produced.
2. The anchor leads to the script itself now with a GET parameter appended that indicates the link clicked on.
3. Script looks if there is a value in the GET param and uses Vragabnod's SQL to retrieve the row.
4. The text is printed using echo or print.

These are the steps; skeleton code:

if (isset($_GET['id'])){
   $ SQL =  "SELECT id, title, text, date FROM stories WHERE id = " . $_GET['id'];
    $result = mysql_query($SQL) or die("Error with the query.");
    $row = mysql_fetch_array($result));
   print $text;
}

 

[thenewa2x]

F.Y.I it's dangerous to just use $_GET or any other variable similair to it without processing it first.

---------------------------------------

http://www.visualactive.net/