# How to count the numbers of your database (display on site)

**URL:** <https://forum.wixstudio.com/t/how-to-count-the-numbers-of-your-database-display-on-site/24398>\
**Category:** Ask the community\
**Tags:** code, question\
**Created:** [March 18, 2018, 8:52pm UTC](https://forum.wixstudio.com/t/how-to-count-the-numbers-of-your-database-display-on-site/24398 "2018-03-18T20:52:31Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![bsk-amsterdam](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/bsk-amsterdam/32/2559_2.png) [@bsk-amsterdam](https://forum.wixstudio.com/u/bsk-amsterdam)\
**Post date:** [March 18, 2018, 8:52pm UTC](https://forum.wixstudio.com/t/how-to-count-the-numbers-of-your-database-display-on-site/24398/1 "2018-03-18T20:52:31Z")

</div>

For example I have 20 babysitters in New York and I want to count the numbers (20) and put it on my site so everyone can see there are 20 babysitters in new york

Please help me!

---

<div class="post-metadata">

**Author:** ![\_or](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/_or/32/1004_2.png) [@\_or](https://forum.wixstudio.com/u/_or)\
**Post date:** [March 19, 2018, 3:46pm UTC](https://forum.wixstudio.com/t/how-to-count-the-numbers-of-your-database-display-on-site/24398/2 "2018-03-19T15:46:23Z")

</div>

Hi,  
Basically you need to use [query](https://www.wix.com/code/reference/wix-data.html#query) and count the number of results you get. This should be modified to your needs( for example if you want to get the results with “location” field that equals to “new york”, use “.eq”)

Good luck 🙂

---

<div class="post-metadata">

**Author:** ![bsk-amsterdam](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/bsk-amsterdam/32/2559_2.png) [@bsk-amsterdam](https://forum.wixstudio.com/u/bsk-amsterdam)\
**Post date:** [March 19, 2018, 7:13pm UTC](https://forum.wixstudio.com/t/how-to-count-the-numbers-of-your-database-display-on-site/24398/3 "2018-03-19T19:13:51Z")

</div>

Do you have a full writtten code? 🙂

---

<div class="post-metadata">

**Author:** ![\_or](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/_or/32/1004_2.png) [@\_or](https://forum.wixstudio.com/u/_or)\
**Post date:** [March 20, 2018, 3:32pm UTC](https://forum.wixstudio.com/t/how-to-count-the-numbers-of-your-database-display-on-site/24398/4 "2018-03-20T15:32:43Z")

</div>

Hi,  
The code should look like this (modify it to match your needs):

```javascript
import wixData from 'wix-data';

// ...

wixData.query("myCollection")
  .eq("status", "active")
  .count()
  .then( (num) => {
    let numberOfItems = num;
  } )
  .catch( (error) => {
    let errorMsg = error.message;
    let code = error.code;
  } );

```

for more information - [https://www.wix.com/code/reference/wix-data.WixDataQuery.html#count](https://www.wix.com/code/reference/wix-data.WixDataQuery.html#count)

Good luck 🙂

---

<div class="post-metadata">

**Author:** ![bsk-amsterdam](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/bsk-amsterdam/32/2559_2.png) [@bsk-amsterdam](https://forum.wixstudio.com/u/bsk-amsterdam)\
**Post date:** [March 20, 2018, 5:05pm UTC](https://forum.wixstudio.com/t/how-to-count-the-numbers-of-your-database-display-on-site/24398/5 "2018-03-20T17:05:28Z")

</div>

Yes i know but i want text! How can i connect this code with the text that shows how many

---

<div class="post-metadata">

**Author:** ![debugslife](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/debugslife/32/8045_2.png) [@debugslife](https://forum.wixstudio.com/u/debugslife)\
**Post date:** [January 14, 2019, 1:41pm UTC](https://forum.wixstudio.com/t/how-to-count-the-numbers-of-your-database-display-on-site/24398/6 "2019-01-14T13:41:51Z")

</div>

// For full API documentation, including code examples, visit [http://wix.to/94BuAAs](http://wix.to/94BuAAs)  
**import** wixData **from** ‘wix-data’;  
// …

$w.onReady( **function** () {  
//TODO: write your page related code here…

wixData.query(“VehicleListDB”)  
.eq(“vehicleStatus”, “Available”)  
.find()  
.then( (results) =\> {  
**if** (results.items.length \> 0) {  
**let** items = results.items;  
**let** firstItem = items[0];  
**let** totalCount = results.totalCount;  
**let** pageSize = results.pageSize;  
**let** currentPage = results.currentPage;  
**let** totalPages = results.totalPages;  
**let** hasNext = results.hasNext();  
**let** hasPrev = results.hasPrev();  
**let** length = results.length;  
**let** query = results.query;

```
  $w("#TextCount").text = totalCount.toString();      
} **else** { 

```

// handle case where no matching items found  
}  
} )  
. **catch** ( (error) =\> {  
**let** errorMsg = error.message;  
**let** code = error.code;  
} );

---

<div class="post-metadata">

**Author:** ![debugslife](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/debugslife/32/8045_2.png) [@debugslife](https://forum.wixstudio.com/u/debugslife)\
**Post date:** [January 14, 2019, 1:45pm UTC](https://forum.wixstudio.com/t/how-to-count-the-numbers-of-your-database-display-on-site/24398/7 "2019-01-14T13:45:00Z")

</div>

import wixData from ‘wix-data’; ----\> Allow usage of wixdata API  
$w(" [#TextCount](https://www.wix.com/code/home/forum/search/posts%3Fquery=.num.extCount) ").text = totalCount.toString(); ----\> set textbox id property to TextCount

 ![](https://us1.discourse-cdn.com/wix/original/3X/6/0/604446b23298b6cf61acf05fae928f641bc21087.jpeg)  
you can do this by right click + view properties (only available on Developers Mode: On)

---

<div class="post-metadata">

**Author:** ![Shan](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/shan/32/106059_2.png) [@Shan](https://forum.wixstudio.com/u/Shan)\
**Post date:** [January 25, 2020, 3:11pm UTC](https://forum.wixstudio.com/t/how-to-count-the-numbers-of-your-database-display-on-site/24398/8 "2020-01-25T15:11:48Z")

</div>

@pranavasagarvarthi Please do not bump year old threads. Follow our [community guidelines](https://www.wix.com/corvid/forum/community-discussion/corvid-community-guidelines) on making a post in the forum.