> -----Original Message----- > From: Marcelo Wolfgang [mailto:marcelo@xxxxxxxxxxx] > Sent: 04 May 2007 14:37 > To: php-general@xxxxxxxxxxxxx > Subject: Selecting a special row from the database > > > 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 > If id is set, query the DB for this news article and put as the first element in an array. Then perform a second query WHERE ID != id and append the results to the array. If id isn't set, just perform the one query without any where clause. If you want to do it all in one query, if id is provided use SELECT... WHERE ID = id UNION (SELECT...WHERE ID != id ORDER BY id DESC) to get the ordering you want. If id isn't set just use SELECT ... ORDER BY id DESC. I'm not sure if there would be much difference in performance as I still think the database would perform two queries internally. Edward -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
