My earlier post works ok now to display I have been working on how to transfer the info to be displayed on another page. I can't get it to work in theory i thik it should be working can anyone give me an idea what I have done wrong.

on the display page I call data from the data base it explodes on echo and displays 9 news headlines. the ["newsTit"] is the whole news article headline ["newsMn"] is the main news article text.

here is the code i have put on the display page.

<p>
<table cellspacing="0" cellpadding="2" border="0">
<form name="news" method="post" action="news.php">

<? 
$sql = "SELECT * FROM tblnewsdetails order by intnewsID desc"; 
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
$tradeaid = $row["intnewsID"];
$accountid = $row["intAccountID"];
$stitle = $row["newsshTit"];
$mtitle = $row["newsTit"];
$nmain = $row["newsMn"];
$updated = $row["dtAddedOn"];

echo'<input name="tradeaid" type="hidden" id="tradeaid" value="<?=tradeaid?>">';
echo'<input name="mtitle" type="hidden" id="mtitle" value="<?=mtitle?>">';
echo'<input name="nmain" type="hidden" id="nmain" value="<?=nmain?>">';
echo '<tr><td width="90% align=left"><a onclick="submit();">'. $stitle. '</s></td></tr>';


}
?>

</table>
</form>


</p>

displays ok it also goes to the news.php when the article is clicked on but when the news.php opens it remain blank here is the code which i have used on many other pages and it works and displays posted data ok but not in this case why???

<? 
session_start();
error_reporting(PCT);
include("secure/global/connection.php");

$tradeaid		=   stripslashes($_POST["tradeaid"]);
$mtitle		=	stripslashes($_POST["mtitle"]);
$nmain		      =	stripslashes($_POST["nmain"]);

?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
</head>

<body>

<p><b><?=$ntitle?></b></p>
<p><?=$nmain?></p>

</body>
</html>

echo'<input name="tradeaid" type="hidden" id="tradeaid" value="<?=tradeaid?>">';
echo'<input name="mtitle" type="hidden" id="mtitle" value="<?=mtitle?>">';
echo'<input name="nmain" type="hidden" id="nmain" value="<?=nmain?>">';

missing $ in the values.

ok i tried that made no change still doesn't work ti now looks like this

<p>
<table cellspacing="0" cellpadding="2" border="0">
<form name="news" method="post" action="news.php">

<? 
$sql = "SELECT * FROM tblnewsdetails order by intnewsID desc"; 
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
$tradeaid = $row["intnewsID"];
$accountid = $row["intAccountID"];
$stitle = $row["newsshTit"];
$mtitle = $row["newsTit"];
$nmain = $row["newsMn"];
$updated = $row["dtAddedOn"];

echo'<input name="tradeaid" type="hidden" id="tradeaid" value="<?=$tradeaid?>">';
echo'<input name="mtitle" type="hidden" id="mtitle" value="<?=$mtitle?>">';
echo'<input name="nmain" type="hidden" id="nmain" value="<?=$nmain?>">';
echo '<tr><td width="90% align=left"><a onclick="submit();">'. $stitle. '</a></td></tr>';


}
?>

</table>
</form>


</p>

second page is still the same and also doesn't work

<? 
session_start();
error_reporting(PCT);
include("secure/global/connection.php");

$tradeaid = stripslashes($_POST["tradeaid"]);
$mtitle = stripslashes($_POST["mtitle"]);
$nmain = stripslashes($_POST["nmain"]);

?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
</head>

<body>

<p><b><?=$ntitle?></b></p>
<p><?=$nmain?></p>

</body>
</html>

Try this.

echo'<input name="tradeaid" type="hidden" id="tradeaid" value="'.$tradeaid.'">';
echo'<input name="mtitle" type="hidden" id="mtitle" value="'.<$mtitle.'">';
echo'<input name="nmain" type="hidden" id="nmain" value="'.nmain.'">';
echo '<tr><td width="90% align=left"><a onclick="submit();">'. $stitle. '</s></td></tr>';

I think its a bad practice to use <?=$varname instead of <?php echo $varname; ?>

Edit: And please use code tags while posting your code. It really helps.

mmm tried that everything in the echo displays everything all the news articles not just the headlines like before on the 1st page doesn't even submit to the news.php using that.
I think my submit is in the wrong place as when it did submit it is trying to submit all the echos and can't distinguish one of them so displays nothing????

i will try this with the script in [] tags i think that is what you meant.

I have almost solved it the following works in that it diplays a news ad headline and main text on the news.php just as i want it to the problem is it does not display the news ad i click on or want to display it always displays the last one in the list.

here is my new revised code on the main page it does not seem to seperate the 9 displayed artices and will always link to the last one if i change the desc to asc it displays the first one not quite what i wanted but almost i want it to post the one i click on any ideas?

<table cellspacing="0" cellpadding="2" border="0">
<form name="news" method="post" action="news.php">

<? 
$sql = "SELECT * FROM tblnewsdetails order by intnewsID desc"; 
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
$tradeaid = $row["intnewsID"];
$accountid = $row["intAccountID"];
$stitle = $row["newsshTit"];
$mtitle = $row["newsTit"];
$nmain = $row["newsMn"];
$updated = $row["dtAddedOn"];
?>


<?
echo '<tr><td width="90% align=left"><a onclick="submit();">'. $stitle. '</a></td></tr>';
}
?>

<input name="mtitle" type="hidden" id="mtitle" value="<?=$mtitle?>">
<input name="nmain" type="hidden" id="nmain" value="<?=$nmain?>">
</table>
</form>

When i change desc to asc it stops showing headlines it shows headlines and whole news articles?

got this script to a state where when i hover over each headline it gives me the links as having id numbers associated eample news.php?id=4 for the 4th headline id=5 for the 5th now I need to know how to carry the data to the news.php

here is my new script

<table cellspacing="0" cellpadding="2" border="0">


<? 
$sql = "SELECT * FROM tblnewsdetails order by intnewsID desc limit 9"; 
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
$tradeaid = $row["intnewsID"];
$accountid = $row["intAccountID"];
$stitle = $row["newsshTit"];
$mtitle = $row["newsTit"];
$nmain = $row["newsMn"];
$updated = $row["dtAddedOn"];
?>


<?

echo '<tr><td width="90% align=left"><a href=news.php?id='. $tradeaid. '>'. $stitle. '</a></td></tr>';
echo '<input name="mtitle" type="hidden" id="mtitle" value="<?=$mtitle?>">';
echo '<input name="nmain" type="hidden" id="nmain" value="<?=$nmain?>">';
}
?>


</table>

In news.php, request id's value and fetch the data from the table for that particular id.
For example, news.php?id=4

//news.php
//db connection
$id = mysql_real_escape_string($_GET['id']);
$query = "select * from newstable where id = '$id'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
print_r($row); //display the news for id = 4
?>

hi do i put that i the head or body as i keep gettig this error message

mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E: with

<? 
session_start();
error_reporting(EWO);
include("secure/global/connection.php");

$id = mysql_real_escape_string($_GET['id']);
$query = "select * from tblnewsdetails where id = '$id'"; 
$result = mysql_query($query);
$row = mysql_fetch_array($result);
print_r($row); //display the news for id = 4
?>

Change the table name (and column name) !

almost there only problem is it displays like this???

Array ( [0] => 7 [intnewsID] => 7 [1] => [intAccountID] => [2] => Ecuador offers to buy out oil companies [newsshTit] => Ecuador offers to buy out oil companies [3] => Ecuador offers to buy out oil companies [newsTit] => Ecuador offers to buy out oil companies [4] => Sat May 17, 7:32 PM ET 
President Rafael Correa says Ecuador wants to buy out private oil companies unwilling to negotiate new deals with his government.
Correa has asked companies now suing over an October decree that slashed their share of windfall oil profits to 1 percent to drop their lawsuits.
Ecuador on Friday offered to boost those companies' share of soaring windfall profits to 30 percent. If companies aren't happy with that offer, Correa says his government will buy their assets at "a fair price."
France's Perenco Gabon SA, U.S.-based Murphy Oil Corporation and ConocoPhillips-subsidiary Burlington Resources are among those to file claims against Ecuador.
Windfall profits are unexpected earnings on oil sold for more than the price fixed in a company's contract.
[newsMn] => Sat May 17, 7:32 PM ET 
President Rafael Correa says Ecuador wants to buy out private oil companies unwilling to negotiate new deals with his government.
Correa has asked companies now suing over an October decree that slashed their share of windfall oil profits to 1 percent to drop their lawsuits.
Ecuador on Friday offered to boost those companies' share of soaring windfall profits to 30 percent. If companies aren't happy with that offer, Correa says his government will buy their assets at "a fair price."
France's Perenco Gabon SA, U.S.-based Murphy Oil Corporation and ConocoPhillips-subsidiary Burlington Resources are among those to file claims against Ecuador.
Windfall profits are unexpected earnings on oil sold for more than the price fixed in a company's contract.
[5] => 2008-05-18 [dtAddedOn] => 2008-05-18 )

Yes. It displays everything it fetches for that particular id. You can limit your output by choosing what to print. As you can see, $row is an array. $row will have 7, $row will have "Ecuador offers to buy out oil companies" and so on.. Check this out.
http://nl3.php.net/mysql_fetch_array
This is how you can print only newsTit value.

//news.php
//db connection
$id = mysql_real_escape_string($_GET['id']);
$query = "select * from newstable where id = '$id'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
print $row['newsTit'];
?>
commented: Good work, well done +8

cheers awsome thanx 4 the assistace

You are welcome :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.