View Single Post
  #1 (permalink)  
Old 06-10-2008, 10:21 AM
chandrika's Avatar
chandrika chandrika is offline
WebProWorld Veteran
 
Join Date: Oct 2005
Location: Cambridge, UK
Posts: 376
chandrika RepRank 4chandrika RepRank 4chandrika RepRank 4chandrika RepRank 4
Default Selecting certain results from SQL table

Code:
<?

$sql = "SELECT * FROM webref_rss_details limit 15";

$result = mysql_query($sql);

while($row = mysql_fetch_assoc($result)){

?>
The above query returns all the results from the webref_rss_details table.

If I want to only return results from that table that have say a "1" in the "bestsellers" column, is that quite simple, can I do some select from...where query?

If anyone knows a tutorial how to filter the results there, would be helpful..

thanks
__________________
2009 Hairstyles - Pictures of 2009 hairstyles and a virtual hairstyler demo.
Price Comparison Site - Compare prices of well known brands and products.
Reply With Quote