Count rows in database?

Question

I have tried using this to access the database:

return $db->execute('SELECT `id` FROM `main_games` WHERE `id`=?', array($this->getSubdomain));

I am not sure if that worked, as it doesn't even comes up with anything. I have checked that the data should exist but my function always comes up false. Do I have to do another command to return the number of rows?

sounds like you haven't made a connection to the db first. why not verify that first? — thescientist, Oct 23 '12 at 19:39

score 2 · Accepted Answer · answered Oct 23 '12 at 19:38

2

I don't know exactly what you are trying to do. But to get the number of rows in a table, say my_table, you can do this in SQL:

SELECT COUNT(*) FROM my_table

answered Oct 23 '12 at 19:38

Omid Kamangar

5,768
9
40
69

+1 but i would always use `count(1)` instead. it's faster. – user428517 Oct 23 '12 at 19:41
There's no difference between `COUNT(*)` or `COUNT(any_constant)` – Vincent Savard Oct 23 '12 at 19:42
@sgroves that is a fallacy -- http://stackoverflow.com/questions/1221559/count-vs-count1 – Taryn Oct 23 '12 at 19:42
Tjanks a ton.. That worked for me. – Marko Livendo Oct 23 '12 at 20:01

Count rows in database?

1 Answers1