Finding a Row...

[GraveDigger]

I have this query which has around 80 rows and I need to find out the row number where id 47 stands

<?php
$query = mysql_query("SELECT id, title FROM reviews ORDER BY title ASC");
$num[] = mysql_fetch_assoc($query);
?>

thanks

[cgraz]

Do you only want to pull that row out of the datbase, or, out of the rows returned, you want to do something different w/that particular row?

For option 1, change your query to

$query = mysql_query("SELECT id, title FROM reviews WHERE id='47' ORDER BY title ASC");

For option 2, run an if statement

// query here

while($row = mysql_fetch_assoc($query)) {
   if($row["id"] == 47) {
      echo "This is row 47";
   } else {
      echo "this is not row 47";
   }
}

Cgraz