PHP PDO result from query

Question

I am trying to do a query in PHP PDO where it will grab a simple result. So like in my query I need it to find the row where the column group is 'Admin' and show what ever is in the group column. I know that we already know what it should be [Should be admin] but just need to get the query to work. Its only grabbing 1 row from my table, so will I need forsearch?

If I change WHERE group = 'Admin' to WHERE id = '1' it works fine. But I need it so it can be where group = 'admin'

$sql2 = "SELECT * FROM groups WHERE group = 'Admin'";
$stm2 = $dbh->prepare($sql2);
$stm2->execute();
$users2 = $stm2->fetchAll();

foreach ($users2 as $row2) {
    print ' '. $row2["group"] .' ';
}

Thanks

@Bonzo prntscr.com/2sbr51 & for the structure prntscr.com/2sbr83 — user3219007
– user3219007, Commented Feb 14, 2014 at 7:41

Yang · Accepted Answer · 2014-02-14 09:30:22Z

1

group is a reserved word in MySQL, that's why it's not working. In general it's a bad idea to use reserved words for your column and table names. Try using backticks around group in your query to get around this, so:

$sql2 = "SELECT * FROM groups WHERE `group` = 'Admin'";

Also you should really use placeholders for values, because you're already using prepared statement it's a small change.

Edit: just to clarify my last remark about the placeholders. I mean something like this:

$sql2 = "SELECT * FROM groups WHERE `group` = ?";
$stm2->execute(array('Admin'));

edited Feb 14, 2014 at 9:30

Yang

8,7408 gold badges35 silver badges61 bronze badges

answered Feb 14, 2014 at 7:46

Ruben

5,0952 gold badges27 silver badges49 bronze badges

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

Comments

Vainglory07 · Accepted Answer · 2014-02-14 07:46:24Z

0

try to use wildcard in your WHERE Clause:

$sql2 = "SELECT * FROM groups WHERE group LIKE '%Admin%'";

Since the value in your table is not really Admin but Administrator then using LIKE and wildcard would search the records which contains admin.

answered Feb 14, 2014 at 7:46

Vainglory07

5,32310 gold badges47 silver badges79 bronze badges

Collectives™ on Stack Overflow

PHP PDO result from query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related