Displaying MySQL query in html select

Question

I am still a beginner with php and MySQL. I am having trouble getting rows from my database to display in an html select drop down box. I have researched it and it seems like my code should be good. The campaigns table as a row titled name. This is the row I am wanting to echo into the drop down. The drop down shows, however there is no content in it. Not sure what I am missing here...

Here is the code

<?php
$con=mysqli_connect("localhost","username","password","db_name");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$query = mysqli_query($con,"SELECT * FROM campaigns"); 

echo '<select name="campaignChange">';

while ($row = mysql_fetch_array($query)) {
    echo "<option value='" . $row['name'] ."'>" . $row['name'] ."</option>";
}

echo '</select>';

?>

jeroen · Accepted Answer · 2014-02-13 19:07:58Z

1

You are mixing mysql and mysqli syntax.

You should change:

$query = mysql_query($con,"SELECT * FROM campaigns");

to:

$query = mysqli_query($con,"SELECT * FROM campaigns");

and:

while ($row = mysql_fetch_array($query)) {

to:

while ($row = mysqli_fetch_array($query)) {

By the way, you should add error handling. If you add this to the top:

mysqli_report(MYSQLI_REPORT_ALL);

mysqli will throw exceptions so you will always know what goes wrong exactly. As long as you use mysqli functions of course...

edited Feb 13, 2014 at 19:07

answered Feb 13, 2014 at 19:02

jeroen

91.8k22 gold badges117 silver badges132 bronze badges

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

3 Comments

doriansm Over a year ago

Changed it to mysqli, still no luck.

doriansm Over a year ago

My bad, I also changed the fetch_array to be mysqli_fetch_array. That did the trick, ty!!!

doriansm Over a year ago

I will mark as answer as soon as it lets me. Thanks again :D

Collectives™ on Stack Overflow

Displaying MySQL query in html select

Here is the code

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Here is the code

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related