retrive from mysql by searching on date and another column

[anujphp]

Hello

I have a table with 4 fields like

table name=profile

name,address,category,date

 

the category column have 7 different value and i am required to fetch the most recent entry in each category

 

 

THANK YOU IN ADVANCE

[chronister]

<?php
$query1 = "SELECT distinct('category') as cat FROM profile"; // should get unique category names

$result = mysql_query($query1);
while($row = mysql_fetch_object)
{
  $cat = $row->cat;
  $query = "SELECT * FROM profile WHERE category = '$cat' ORDER BY date LIMIT 1";
   $result = mysql_query($query);
   while($row2 = mysql_fetch_object($result))
   {
      // do what you want with the data received here...
      $name = $row2->name;
      $address = $row2->address;
      $category = $row2->category;
      $date = $row2->date;
   }
}
?>

 

I think that should work. I am sure there is a better way ,but it is 3 am and my brain is tired... so thats the best I got right now.

 

Nate

[anujphp]

Thank you chronister/Nate

your code works fine,i was lookign for something liek that,THANK YOU ONCE AGAIN