doutangguan2460 2016-08-05 07:33
浏览 97


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:

$query="SELECT COUNT(*) from employee where id like '%$id%'";
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 = 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
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
  • doucao8982 2016-08-05 08:06
    1. At first, you should select * from the employee table

    2. Then parse the result to array,

    3. Scan the above array (step2) and find your value (11113)

    4. If (3) is found, then you can return array index.

  • doulan8054 2016-08-05 08:46

    First thing: You're using old PHP-method for database, use PDO

    If you wan't to get the last insert ID, it's possible to catch it with PDO

    And I don't understand your SQL, because you want to get an ID, by filtering with the ID? And when your ID is an INTEGER/NUMBER, than your statement is senseless.




  • ¥15 jsp,如何使用户名输出为中文(语言-javascript)
  • ¥20 文件读写,但中文乱码
  • ¥15 PowerBI中如何做到按数值向下取数
  • ¥15 设计quartus maxⅡ :Verilog-FPGA(0
  • ¥15 windows server 2022 datacenter安全策略配置 没有权限问题
  • ¥20 寻找dspace有偿技术支持
  • ¥30 深度学习的模型融合问题
  • ¥20 数电实验Verilog编程
  • ¥15 机器人MATLAB仿真示教占内存过大
  • ¥15 JSR233已经使用但是仍无法将csv数据放到一个list里显示出来,如何解决?