PHP and MySQL: Number of rows returned

Question

How can I see how many rows the following query returns?

mysql_select_db($database_aoldatabase, $aoldatabase);

$query1 = "select * from sale where secid  = $invoiceno ";
$query2 = "select * from sale where secid  = $invoiceno ";


$maxa = mysql_query ($query1)
    or die ("Query '$query' failed with error message: \"" . mysql_error () . '"');
$maxa2 = mysql_query ($query2)
    or die ("Query '$query' failed with error message: \"" . mysql_error () . '"');

$row = mysql_fetch_array($maxa);
$row2 = mysql_fetch_array($maxa2);

Eduard7 · Accepted Answer · 2011-02-28 10:01:13Z

7

Like Michiel said, mysql_num_rows() do the job. But if you want to work with more than one rows using an array, you can use count() too.

$data = array();
while($row = mysql_fetch_array($maxa, MYSQL_ASSOC)) {
  $data[] = $row;
}
$count1 = mysql_num_rows($maxa);
$count2 = count($data);

answered Feb 28, 2011 at 10:01

Eduard7

7467 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2023-11-17 20:08:53Z

5

Use the function mysql_num_rows()

Have a look at: https://www.php.net/manual/en/function.mysql-num-rows.php

edited Nov 17, 2023 at 20:08

CommunityBot

11 silver badge

answered Feb 28, 2011 at 9:44

Michiel Pater

23.2k5 gold badges47 silver badges58 bronze badges

1 Comment

Shikiryu Over a year ago

$numrows = mysql_num_rows($maxa); :) +1

Collectives™ on Stack Overflow

PHP and MySQL: Number of rows returned

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related