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

0 vote122 views1 answer
Php check if variable is true or false
PHP
1 vote143 views2 answers
Re migrate laravel
PHP Laravel
0 vote134 views1 answer
How to merge 2 laravel eloquent records
PHP Laravel
4 votes115 views1 answer
Php pakistan time zone
PHP
1 vote120 views1 answer
Get file each line in php
PHP
0 vote253 views1 answer
Jpeg nach und nach laden
PHP
1 vote127 views1 answer
Php dom add class to element
PHP
3 votes130 views3 answers
Php replace spaces with dash
PHP
1 vote125 views1 answer
How to use old for select in blade laravel
PHP
1 vote208 views1 answer
Laravel stoage link brakes when pushed on production
PHP