Hi there, Wonder if someone could help me, I have not touched PHP in a while now so a little rusty.
What i have is a news page now the news story is disaplayed when someone clicks the item from the home page, which then loads a news page, but the problem I am having is when the news page loads it has the links down the left with the other news stories, all with the correct id numbers appended to the link, but the news item on the page is loading as the last one, and when you click the links it does not load the correct item. Now I know this is something to do with having two sql queries on the same page, and the id number being fetched. Here is the code for the two sql statements on the same page, if someone could help it would be most appreciated. <? //start query code $sql= "SELECT * FROM news WHERE 'Corporate' = division "; $sql_result = mysql_query($sql); if (mysql_num_rows($sql_result) ==0) { echo (" \n"); } else { while ($row = mysql_fetch_array($sql_result)){ $title = $row["title"]; $id = $row["id"]; echo ("<tr> \n"); echo ("<td width=\"13%\" class=\"body\"><p> </p></td> \n"); echo ("<td width=\"87%\"><p><a href=\"news.php?id=$id\">$title</a></p></td> \n"); echo ("</tr> \n"); }} ?> <? //start query code $sql= "SELECT * FROM news WHERE ('$id' = id) "; $sql_result = mysql_query($sql); if (mysql_num_rows($sql_result) ==0) { echo (" \n"); } else { while ($row = mysql_fetch_array($sql_result)){ $division = $row["division"]; $title = $row["title"]; $date = $row["date"]; $content = $row["content"]; $link = $row["link"]; echo ("<h3>$title</h3> \n"); echo ("<p>" . date ('F jS Y',strtotime($date)) . " </p> \n"); echo ("<p>$content</p> \n"); echo ("<p> </p> \n"); }} ?> There is html code inbetween these two statements, and the id number is passed from the index page with the news item listed. Hope someone can help me in the right direction. Thanks Barry Zimmermn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php