I've encountered this problem for a while and I can't seem to find the right answer on google. I don't know if maybe I'm just unlucky.
Anyway, how can I get row number from a specific record I input from a PHP text field, for example:
ID NAME
11111 john
11112 roger
11113 ellis
11114 jack
11115 wendy
So if I input 11113, the output will be like "this ID is at number 3".
Here is my code:
$id=$_POST['id'];
$query="SELECT COUNT(*) from employee where id like '%$id%'";
$num=mysql_query($query);
echo "this ID is at number $num";
Can anyone point out where did I go wrong?