# Echo just one item from database?

**URL:** <https://forum.kirupa.com/t/echo-just-one-item-from-database/186216>\
**Category:** programming\
**Created:** [April 19, 2006, 8:43pm UTC](https://forum.kirupa.com/t/echo-just-one-item-from-database/186216 "2006-04-19T20:43:46Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![skyler](https://avatars.discourse-cdn.com/v4/letter/s/ecae2f/32.png) [@skyler](https://forum.kirupa.com/u/skyler)\
**Post date:** [April 19, 2006, 8:43pm UTC](https://forum.kirupa.com/t/echo-just-one-item-from-database/186216/1 "2006-04-19T20:43:46Z")

</div>

I have this code. It echo’s everything from my database. i only want one item to showup from my database. And I want to be able to say which one i want to echo (using ‘id’)

here is my code.

```php
//the code to connect to database goes here
$i=1;
while($row = mysql_fetch_assoc($gettable)){
echo $row['title'];
$i++;
}

```

assume there are no errors and this works. Tell me how I would echo only one ‘id’ of my choice. hurry, this would be really helpful.

---

<div class="post-metadata">

**Author:** ![SlowRoasted](https://avatars.discourse-cdn.com/v4/letter/s/a698b9/32.png) [@SlowRoasted](https://forum.kirupa.com/u/SlowRoasted)\
**Post date:** [April 19, 2006, 8:49pm UTC](https://forum.kirupa.com/t/echo-just-one-item-from-database/186216/2 "2006-04-19T20:49:14Z")

</div>

You can specify it in your sql statement.

```php

$i = 1;
$query = "SELECT * FROM tablename WHERE id='$i'";
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result)){ 
echo $row['title'];
}

```

---

<div class="post-metadata">

**Author:** ![skOOb](https://avatars.discourse-cdn.com/v4/letter/s/8dc957/32.png) [@skOOb](https://forum.kirupa.com/u/skOOb)\
**Post date:** [April 19, 2006, 8:54pm UTC](https://forum.kirupa.com/t/echo-just-one-item-from-database/186216/3 "2006-04-19T20:54:37Z")

</div>

or

```php
$i = 1;
$result = mysql_fetch_array(mysql_query("SELECT * FROM tablename WHERE id=$i Limit 1"));
echo $result['title'];

```

thats if you know there will only be one result. both will work.

hth 🍺

---

<div class="post-metadata">

**Author:** ![SlowRoasted](https://avatars.discourse-cdn.com/v4/letter/s/a698b9/32.png) [@SlowRoasted](https://forum.kirupa.com/u/SlowRoasted)\
**Post date:** [April 19, 2006, 8:58pm UTC](https://forum.kirupa.com/t/echo-just-one-item-from-database/186216/4 "2006-04-19T20:58:04Z")

</div>

Yeah, only use limit one if id is not the primary key, otherwise it’s not necessary. Usually id is the primary key though.😛

---

<div class="post-metadata">

**Author:** ![skyler](https://avatars.discourse-cdn.com/v4/letter/s/ecae2f/32.png) [@skyler](https://forum.kirupa.com/u/skyler)\
**Post date:** [April 19, 2006, 9:17pm UTC](https://forum.kirupa.com/t/echo-just-one-item-from-database/186216/5 "2006-04-19T21:17:32Z")

</div>

HOORAY!!! Both seemed to work, but the first suggestion works better in my instance. Thank you both so much!