# mySQL/PHP show all info?

**URL:** <https://forum.kirupa.com/t/mysql-php-show-all-info/159008>\
**Category:** Uncategorized\
**Created:** [August 13, 2005, 8:14pm UTC](https://forum.kirupa.com/t/mysql-php-show-all-info/159008 "2005-08-13T20:14:05Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![pbrollwitme](https://avatars.discourse-cdn.com/v4/letter/p/439d5e/32.png) [@pbrollwitme](https://forum.kirupa.com/u/pbrollwitme)\
**Post date:** [August 13, 2005, 8:14pm UTC](https://forum.kirupa.com/t/mysql-php-show-all-info/159008/1 "2005-08-13T20:14:05Z")

</div>

hi,  
i’m new to mySQL and PHP, i have a mySQL database and i’m using php to extract the information from it. Its working fine except i can only view one row.  
For example i have 3 rows as follows:

Name,email,password  
name,email,password  
etc,etc,etc

i can view the first row but the other two i cannot. I know its something to do with my php…I’m pretty sure it should look something like the following:

$result = mysql\_query(“SELECT \* FROM users”,$db);

echo???

what would i echo??

Thanks everyone, i’m sure its an easy solution for those of you who know what you’re talkin about!