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?