# Count and Display number of imputs from DB

**URL:** <https://forum.wixstudio.com/t/count-and-display-number-of-imputs-from-db/15451>\
**Category:** Ask the community\
**Tags:** question, code\
**Created:** [March 29, 2019, 7:06am UTC](https://forum.wixstudio.com/t/count-and-display-number-of-imputs-from-db/15451 "2019-03-29T07:06:05Z")\
**Posts on this page:** 5\
**Page:** 2

<div class="post-metadata">

**Author:** ![nanami](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/nanami/32/1875_2.png) [@nanami](https://forum.wixstudio.com/u/nanami)\
**Post date:** [March 13, 2021, 2:45pm UTC](https://forum.wixstudio.com/t/count-and-display-number-of-imputs-from-db/15451/21 "2021-03-13T14:45:51Z")

</div>

@russian-dima  
Thank you for your reply.  
Yes my database name is “gckj2gyh”

 ![](https://us1.discourse-cdn.com/wix/original/3X/0/3/03f048c6be0a147524c87fc1501b89ca2ee5ef57.png)  
I want just count the number of rows.  
This pattern

 ![](https://us1.discourse-cdn.com/wix/original/3X/6/e/6e75e6bbb19136f882641f64afa5685c058557db.jpeg)

I want to display 3

Different from this post.  
[https://www.wix.com/velo/forum/community-discussion/i-want-to-display-the-total-of-columns](https://www.wix.com/velo/forum/community-discussion/i-want-to-display-the-total-of-columns)

---

<div class="post-metadata">

**Author:** ![CODE-NINJA](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/code-ninja/32/110588_2.png) [@CODE-NINJA](https://forum.wixstudio.com/u/CODE-NINJA)\
**Post date:** [March 13, 2021, 2:59pm UTC](https://forum.wixstudio.com/t/count-and-display-number-of-imputs-from-db/15451/22 "2021-03-13T14:59:19Z")

</div>

@nanami  
Then i think this should do it…

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

$w.onReady(async function() {  
    let myQuery = await wixData.query("gckj2gyh")
    console.log("Query: ", myQuery)
 
    myQuery.find().then((res) => {
        console.log("Results: ", res)
        $w('#text9').text= String(res.items.length);
    })
    .catch( (error) => {
        let errorMsg = error.message;
        let code = error.code;
    });
});

```

---

<div class="post-metadata">

**Author:** ![nanami](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/nanami/32/1875_2.png) [@nanami](https://forum.wixstudio.com/u/nanami)\
**Post date:** [March 13, 2021, 3:49pm UTC](https://forum.wixstudio.com/t/count-and-display-number-of-imputs-from-db/15451/23 "2021-03-13T15:49:40Z")

</div>

@russian-dima  
Thank you so much!!!  
It’s work!!!  
I was impressed！！！

---

<div class="post-metadata">

**Author:** ![CODE-NINJA](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/code-ninja/32/110588_2.png) [@CODE-NINJA](https://forum.wixstudio.com/u/CODE-NINJA)\
**Post date:** [March 13, 2021, 4:22pm UTC](https://forum.wixstudio.com/t/count-and-display-number-of-imputs-from-db/15451/24 "2021-03-13T16:22:13Z")

</div>

@nanami  
No problem. 😉  
Good luck & happy coding.

---

<div class="post-metadata">

**Author:** ![practicasistem4](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/practicasistem4/32/37973_2.png) [@practicasistem4](https://forum.wixstudio.com/u/practicasistem4)\
**Post date:** [July 8, 2023, 10:59pm UTC](https://forum.wixstudio.com/t/count-and-display-number-of-imputs-from-db/15451/25 "2023-07-08T22:59:03Z")

</div>

```javascript
Hello, thanks for your contributions.
I need to complete a filtered dropdown from the database

===============================================

    $w('#dataset3').onReady(() => {

        wixData.query(MiContenedor)
            .eq('idprofesor', xIdDatos)
            .find()
            .then((results) => {
                let food = results.items[0];

                for (let i = 0; i <= food; i++) {
                    console.log(results.items);
                    $w('#dropdown3' + i).value = results.items;
                }

            })
            .catch((error) => {
                console.log(error)
            });

    });

```

[Previous page](https://forum.wixstudio.com/t/count-and-display-number-of-imputs-from-db/15451.md?page=1)