PHP Combobox from MySQL

Question

I'm doing my homework and we're supposed to do registration, and i'm stuck at combobox, it does show something but it shows a blank , we're prohibited to use mysql_query, and any other object than PDO.

$query = "SELECT * FROM tbltypkon";
    $result = $db->query($query);
    while($row=mysql_fetch_array($result, MYSQL_ASSOC)){                                                 
       echo "<option value='".$row['ID_TYPKON']."'>".$row['TYPKONTAKTU']."</option>";
    }

Also turn on error reporting in php or web server to see where is the problem — gorgi93
– gorgi93, Commented Apr 5, 2014 at 10:44

akirk · Accepted Answer · 2014-04-05 10:44:25Z

1

Instead of

$row = mysql_fetch_array($result, MYSQL_ASSOC)

you should use

$row = $result->fetch(PDO::FETCH_ASSOC)

see PDOStatement::fetch in the PHP Manual.

answered Apr 5, 2014 at 10:44

akirk

6,8972 gold badges37 silver badges59 bronze badges

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

12 Comments

akirk Over a year ago

Check the HTML source if there is any option or error message?

akirk Over a year ago

so where does it stop? do you see the </select>? Is there anything in the table at all? Are the field names correct? Try a print_r($row); in the loop.

akirk Over a year ago

Yes. But if there is no data it cannot display anything.You only showed the table layout

user3478311 Over a year ago

there is data, 4 Types of contact.

akirk Over a year ago

Sorry, to clarify: when you look at the page and use the View Document Source function of your browser. You need to look at the output of PHP that you get via HTTP

|

akirk · Accepted Answer · 2014-04-05 11:27:09Z

1

You need to define the $db variable, i.e. connect to the database

answered Apr 5, 2014 at 11:27

akirk

6,8972 gold badges37 silver badges59 bronze badges

Collectives™ on Stack Overflow

PHP Combobox from MySQL

2 Answers 2

12 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

12 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related