Selecting a special row from the database
| From: | Marcelo Wolfgang | Date: | Fri, 04 May 2007 13:36:32 +0000 |
| Subject: | Selecting a special row from the database | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-254406@lists.php.net to get a copy of this message | ||
Hi all,
I'm building a news display page for a website, and since the user has 2 ways to arrive there, I want to know if this is possible:
1) the user arrive at news.php
I will run a query at the db, and get the latest news to be the main one (full display) and display the others news in a list
2) the user arrived from a link to a specific news to news.php?id=10
It should display the news with id = 10 as the main news and get the latest ones to display in a list of other news
I've so far was able to add a dinamic WHERE to my query ( if I have or not the id GET parameter ) and if I don't have it, I'm able to display the latest result as the main news, but when I have an id as a GET parameter, I have a where clause in my query and it will return only the main news and not build up the news list
what I want is to separate the news that the user want to see ( the id=XX one ) from the others rows, can someone advice me ?
Here is the code I have so far, I hope it serve as a better explanation than mine!
<?
$newsId = $_GET['id'];
if (isset($newsID)){
$whereClause = 'WHERE auto_id ='.$newsId;
} else {
$whereClause = '';
}
mysql_connect("localhost",$user,$pass) or die (mysql_error());
mysql_select_db ($db_table);
$SQL = "SELECT * FROM tb_noticias $whereClause ORDER BY auto_id DESC";
$news_Query = mysql_query($SQL);
$recordCount = mysql_numrows($news_Query);
mysql_close();
?>
TIA
Marcelo Wolfgang