select multiple rows different value from same table

Question

This is my table "OPTIONS"

enter image description here

Here i need to get site_logo,facebook and twitter values only from single mysql query.

Thank you

you should have better taken efforts learn very basics of SQL before posting any question, this question only shows lack of efforts to just know what you want to achieve — Mahesha999
– Mahesha999, Commented Apr 18, 2014 at 7:40

Nambi · Accepted Answer · 2014-04-18 07:43:09Z

1

As simple as it is..

SELECT id,option_key,option_value FROM options

or

SELECT * FROM options

You can do like this Using PDO

    $dbh = new PDO("mysql:dbname=pages;host=localhost", "username", "password");
    $sth = $dbh->prepare('SELECT id,option_key,option_value FROM options');
    $sth->execute();

edited Apr 18, 2014 at 7:43

answered Apr 18, 2014 at 7:38

Nambi

12k4 gold badges40 silver badges50 bronze badges

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

Comments

Haseeb · Accepted Answer · 2014-04-18 07:38:00Z

0

try this

SELECT * FROM TABLENAME ;

answered Apr 18, 2014 at 7:38

Haseeb

2,2321 gold badge22 silver badges43 bronze badges

Comments

Andolasoft Inc · Accepted Answer · 2014-04-18 07:44:31Z

0

SELECT * FROM options` then, in the PHP:

while ($row=MySQLi_fetch_assoc($result))
{
    echo "<option value=\"".htmlspecialchars($row['option_value'])."\">".
    htmlspecialchars($row['option_key'])."</option>";
}

edited Apr 18, 2014 at 7:44

Andolasoft Inc

1,2961 gold badge7 silver badges16 bronze badges

answered Apr 18, 2014 at 7:38

Helpful

7064 silver badges17 bronze badges

1 Comment

Iłya Bursov Over a year ago

and don't forget to use htmlspecialchars for this approach

Collectives™ on Stack Overflow

select multiple rows different value from same table

3 Answers 3

Comments

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Linked

Related