Loop when fetching COUNT in mysql

Question

$query_count="SELECT COUNT(*) FROM table";
$result_count = mysql_query($query_count);
$final_count=mysql_fetch_array($result_count);
echo $final_count[0];

This cause the website to "loop" (page never loads, browser runs out of memory). any idea how to do it?

Your website "loops?" What do you mean? Does the page never load? — Jon Gauthier
– Jon Gauthier, Commented Jul 31, 2011 at 1:01

Sabeen Malik · Accepted Answer · 2011-07-31 01:05:48Z

1

I think it should be :

$query_count="SELECT COUNT(*) FROM table";
$result_count = mysql_query($query_count);
$final_count=mysql_fetch_row($result_count);
echo $final_count[0];

answered Jul 31, 2011 at 1:05

Sabeen Malik

10.9k4 gold badges37 silver badges51 bronze badges

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

2 Comments

Chris Hepner Over a year ago

There's nothing in the original code that will 'loop', but in the original code $final_count would be an array and echo $final_count would simply print 'Array'. @Blackie123: Are you sure there aren't any infinite loops elsewhere in your script?

Sabeen Malik Over a year ago

@Blackie123 I simply used mysql_fetch_row as we always expect one row, you can continue to use mysql_fetch_array if you want. The main difference is the last line. Chris is correct in pointing out that there is nothing in this part of the code which would cause the the page to go into an infinite loop, something else seems to be an issue.

Yahia · Accepted Answer · 2011-07-31 01:07:13Z

0

try replacing echo $result_count; with echo $final_count;

EDIT - another option:

$query_count="SELECT COUNT(*) FROM table";
$result_count = mysql_query($query_count);
$final_count=mysql_fetch_field($result_count, 0);
echo $final_count;

edited Jul 31, 2011 at 1:07

answered Jul 31, 2011 at 1:01

Yahia

70.5k9 gold badges117 silver badges147 bronze badges

1 Comment

Blackie123 Over a year ago

that one causes the loop but how shall I find out the count other then that?

Eduardo Reveles · Accepted Answer · 2011-07-31 01:27:42Z

0

Try:

$query_count="SELECT COUNT(*) FROM table";
$result_count = mysql_query($query_count);
echo mysql_result($result_count, 0, 0);

answered Jul 31, 2011 at 1:27

Eduardo Reveles

2,17517 silver badges14 bronze badges

Collectives™ on Stack Overflow

Loop when fetching COUNT in mysql

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related