6 replies to this topic

[welton122]

hi all,

okay this seems really basic mysql but I cannot seem to get it to work.
I am trying to count the number of rows in a database

My code goes like this:

$q = "SELECT COUNT(*) FROM `test` WHERE `Type` = \'1\' LIMIT 0, 30 "; 

$count_tst = mysqli_query($dbc, $q);

echo "$count_tst";

And I know this works because when I run it in the PHPMyAdmin utility it runs perfectly.

Am I missing something here?

Any help??

Many Thanks,
J

P.s i forgot to say that the problem is there is nothing being echoed out of the variable $count_tst and i am already connected to the database, i just haven't pasted the code (it defo connects right as i link to the connection page with a require_once(); which works correctly on other pages I've done.)

[Orjan]

Yes, you need to fetch the result too.

$q = "SELECT COUNT(*) FROM `test` WHERE `Type` = \'1\' LIMIT 0, 30 ";  

$count_tst = mysqli_query($dbc, $q);

$count = mysqli_fetch_array($count_tst);

echo $count[0];

but you shouldn't have a limit when you're counting rows...

[welton122]

I have tried your code butit dosent seem to work.

I get the error

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given on line 28

Line 28 is this line

$count = mysqli_fetch_array($count_tst); 

any ideas?

Thanks

[maximilianos]

can you send me the script on my email to give you a solution my email is maximilianos1985@hotmail.com

[welton122]

sorry but i no longer need to, i finally got the code working.

Thanks for the help

The problem was the \ in the \'1\'. Not sure why it caused this problem but its fixed it :D

Thanks again

[maximilianos]

welcome welton122 anytime you need help you can email me

[welton122]

Thanks maximilianos