mysql query select multiple rows where column value is same

Question

i have this table

Column_1        Column_2
1                 value1
2                 value1
3                 value2

My php query is

$query = "SELECT * FROM `table` WHERE `Column_1` = 'value1' ";
print_r($query);

This returns only the 1st row. I am looking to display row 1 and 2. When I run the SQL in phpmyadmin it returns row 1 and 2. However, the php script only returns row 1... I also did an

echo count($query);

But it returns only 1. What am i doing wrong?

value1 is in Column_2. And your where clause is on Column_1. Your query doesn't seem coherent with the sample data given. — Raphaël Althaus
– Raphaël Althaus, Commented Apr 16, 2014 at 7:54
Your source code does not do anything with the database. You have to actually send the query to the database and iterate over the result set. — Oswald
– Oswald, Commented Apr 16, 2014 at 7:55

hoangvu68 · Accepted Answer · 2014-04-16 08:01:22Z

2

$query = "SELECT * FROM `table` WHERE `Column_2` = 'value1' ";
$res = mysql_query($query);
if(mysql_num_rows($res)!=0) {
    while($rowData = mysql_fetch_array($res)) {
        var_dump($rowData);
    }
}

Use mysql_num_rows to count number of results.
Use mysql_fetch_array or mysql_fetch_assoc to fetch data.

answered Apr 16, 2014 at 8:01

hoangvu68

8632 gold badges13 silver badges29 bronze badges

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

1 Comment

Derek Lim Over a year ago

Thanks hoangvu68, your solution is detailed and perfect

Alexey Palamar · Accepted Answer · 2014-04-16 07:56:09Z

1

$query = "SELECT * FROM `table` WHERE `Column_1` = 'value1' ";
$res = mysql_query($query);
while($row = mysql_fetch_assoc())
print_r($row);

You need add fetch in cycle.

answered Apr 16, 2014 at 7:56

Alexey Palamar

1,4301 gold badge10 silver badges16 bronze badges

1 Comment

Derek Lim Over a year ago

Thanks Alexey, your answer hit the nail... except that you missed out $res in while($row = mysql_fetch_assoc($res)) and it's WHERE Column_2 = 'value1' "; but thaks anyway...

Vishwanath Tadahal · Accepted Answer · 2014-04-16 08:01:13Z

0

Use mysql_fetch_array() function
 $query = "SELECT * FROM `table` WHERE `Column_1` = 'value1' ";
 $res = mysql_query($query);
 while($row = mysql_fetch_array($res))
   {
       echo $row['Column_1'];
       echo $row['value_1'];
   }

answered Apr 16, 2014 at 8:01

Vishwanath Tadahal

1141 gold badge1 silver badge11 bronze badges

Collectives™ on Stack Overflow

mysql query select multiple rows where column value is same

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related