doutangguan2460 2016-08-05 07:33
浏览 97
已采纳

如何从输入的数据中获取行号(sql和php)

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?

  • 写回答

3条回答 默认 最新

  • douqu2712 2016-08-05 07:46
    关注

    Here is a query example of how you can do it without adding another column for count:

    SELECT e.*,b.count FROM employee as e, (SELECT COUNT(*) as count FROM employee WHERE id <= 3) as b WHERE e.id = 3
    

    Using another select query to count all the rows with id smaller than the id requested

    Or if you only want the offset of the row without its data:

    SELECT COUNT(*) as count FROM employee WHERE id <= 3
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?