Mysql num rows

//number of rows retrieved from a query
<?php

$link = mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("database", $link);

$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);

echo "$num_rows Rows\n";

?>

Source: php.net

Row number mysql

SELECT row_number() over ( order by firstName) RowNumberSqeuence,FirstName from rowNumberDemo
 order by FirstName;

Source: tutorialspoint.com

Mysql row_number() example

SET @row_number = 0; 
SELECT 
    (@row_number:=@row_number + 1) AS num, 
    firstName, 
    lastName
FROM
    employees
ORDER BY firstName, lastName    
LIMIT 5;

Source: mysqltutorial.org

Similar codes

7 votes198 views5 answers
Wordpress get post by id
PHP
0 vote180 views6 answers
The requested URL was not found on this server. Apache/2.4.47 (Win64) OpenSSL/1.1.1k PHP/7.3.28 Server at localhost Port 80 error in laravel
PHP Laravel
1 vote139 views2 answers
How console log laravel
PHP
1 vote144 views2 answers
Scheduling in laravel in custom cron
PHP
-2 votes128 views1 answer
Laravel trait command
PHP
0 vote182 views4 answers
Installing bootstrap on laravel8
PHP Laravel
0 vote192 views1 answer
Wordpress disable php update required
PHP Wordpress
0 vote170 views1 answer
Set cookie on button click php or js
PHP
0 vote161 views1 answer
Thousand seperator php
PHP
0 vote143 views1 answer
Laravel search and return record with pagination
PHP