[SOLVED] Q> Locating the position of records in the database using PHP

[merck_delmoro]

Example

Record in the DataBase:

• Cat
  
• Dog
  
• Mouse
  

 

I want to output :

The Dog is Located at # 2

[taith]

easiest way is to put an auto_increase'ing number in your table... basically every entery takes the next sequencial number...

[merck_delmoro]

I've done it by my self haha

 

this is the code I've made

 

$query=mysql_query("SELECT * FROM animals");

while($row = mysql_fetch_array($query) and $row['animal'] !="dog")

{

 

  $count+=1;

}

echo print "The Dog is Located at # ".$count+1;

[Ken2k7]

Does animals have an ID field?

 

Simpler and faster:

$result = mysql_query("SELECT id FROM animals WHERE animal = 'dog' LIMIT 1");
$row = mysql_fetch_assoc($result);
echo $row['id'];