Drop down list with data from database

Asked May 31 '17 at 18:14

Active Jun 04 '17 at 01:45

Viewed 98 times

First of all I would like to let you know that I tried every other solution that I found here regarding to my topic.. But nothing worked for me!

As the title says I want to create a drop down list with data from a database!

The connection with the database is right so I don't show you the code! I have tried many ways, one is below.

The only thing that I am getting is a blank list.Thanks!

<select name="Anaktisi">
  <?php 

  $query2="select name from books WHERE sub_ID=1";
  $result2 = mysqli_query($con,$query2);

  while ($row2 = mysqli_fetch_array($result2)) { ?>
      <option value="<?php echo $row2['name'];?>"> </option>
  <?php } ?>

</select>

edited Jun 04 '17 at 01:45

HDJEMAI

9,436
46
67
93

asked May 31 '17 at 18:14

Miltos Taramanidis

`` – JSONGagnon May 31 '17 at 18:20
1

Related, possibly duplicate: [Fetching data from MySQL database to html dropdown list](https://stackoverflow.com/questions/10009464/fetching-data-from-mysql-database-to-html-dropdown-list) – Wondercricket May 31 '17 at 18:22
1

Try: `` – JustBaron May 31 '17 at 18:23
@JustBaron I tried what you said but i get the same blank thing! – Miltos Taramanidis May 31 '17 at 18:36
@JSONGagnon you are right, but the result is the same..! – Miltos Taramanidis May 31 '17 at 18:36
@Wondercricket I tried that way too, but i got no result. – Miltos Taramanidis May 31 '17 at 18:37
@JustBaron has to correct syntax for displaying the name in the drop down itself and in the value. Try `` to see if it shows in the dropdown. If nothing shows after that, then there are probbaly no results being returned. – JSONGagnon May 31 '17 at 18:40
@JustBaron It shows nothing again! But I tried the query itself in the database and everything seems fine, it returns the correct results – Miltos Taramanidis May 31 '17 at 18:43
Did you check if this condition is Ok? $row2 = mysqli_fetch_array($result2) – RMH May 31 '17 at 20:06
@RMH well how do i check that? – Miltos Taramanidis May 31 '17 at 20:10
Your HTML contains the tag – RMH May 31 '17 at 20:37
@RMH after the – Miltos Taramanidis May 31 '17 at 21:08
Yesman, but I'm asking after you run your application. Your code only produce the – RMH May 31 '17 at 22:02
@RMH actually i found the problem. the database connection was closing too early! Thank you! you helped me a lot :D – Miltos Taramanidis May 31 '17 at 22:17
good job man!! That was my suspect!!! Your code was alright! – RMH Jun 01 '17 at 11:26

Drop down list with data from database

0 Answers0