PHP: Output data from MySQL columns

Question

I wanted to get all the rows in a given column and output them, but my code is just not working:

$result = mysql_query("SELECT Name,Number FROM Users WHERE Customer_ID = 1);
  if (!$result) {
    die("Query to show fields from table failed");
  }
$row = mysql_fetch_assoc($result);

echo $row['Name'];
echo $row['Number'];

^ This code is only displaying the first row, how can I list all the rows?

You are missing a " at the end of the first line for starters. — Andreas
– Andreas, Commented Sep 4, 2011 at 15:35

Eduard Luca · Accepted Answer · 2011-09-04 15:35:44Z

3

You have to loop through the rows. Getting the mysql_fetch_assoc 1 time, will only return you 1 row (the first one), so you have to do a mysql_fetch_assoc for each row in the result. Something like this would do:

while($row = mysql_fetch_assoc($result))
    echo $row['Name']." ".$row['Number'];

answered Sep 4, 2011 at 15:35

Eduard Luca

6,62218 gold badges89 silver badges143 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Mr. Banana Over a year ago

It worked, however, it's outputting the same data multiple times, although it's stored only in one row

Eduard Luca Over a year ago

then please check your query, maybe run it in phpmyadmin or mysql, to see what exactly it returns. the above code should work perfectly if the query is correct.

Mr. Banana Over a year ago

I'm sorry. It was from my SQL statment. Thank you!

netemp · Accepted Answer · 2011-09-04 15:39:51Z

0

In order to display all the rows, you need to use 'while' loop as following:

while($row = mysql_fetch_assoc($result)){

    echo $row['Name'];
    echo $row['Number'];
    echo '<br />';
}

Hope this helps.

answered Sep 4, 2011 at 15:39

netemp

4,18512 gold badges45 silver badges63 bronze badges

3 Comments

Mr. Banana Over a year ago

This helps too. Thanks. Is it possible to tell PHP to fetch identical rows only once? For example, I'm getting 50 'Number: 12345678'.

Eduard Luca Over a year ago

Maybe add a GROUP BY Number statement to the end of you MySQL query would help.

netemp Over a year ago

You can achieve this by using the keyword 'Distinct' in your query. This will make sure that all the records are unique.

Collectives™ on Stack Overflow

PHP: Output data from MySQL columns

2 Answers 2

3 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related