Selecting a value from select using php

Question

I have a select input i need populate it from a db and select the value that matches a variable product. I have

while ($row=mysqli_fetch_array($result,MYSQLI_ASSOC)){
 echo "<option value='".$row['pname']."'>".$row['pname']."<?php
 if($row['pname']==$product) echo 'selected'</option>";

Select Entries are populated from pname and the option with name that equals $product should be selected. Im getting this error syntax error,

unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING) in

Show us the rest of that error message, the part that gives the line number, and indicate that line in the code. Although these errors usually arise because of errors in some line above it, this is the minimum required fro people to answer this question. — David Soussan
– David Soussan, Commented Mar 16, 2015 at 6:48

prava · Accepted Answer · 2015-03-16 06:49:05Z

1

Check this one -

while ($row=mysqli_fetch_array($result,MYSQLI_ASSOC)) {
    $selected = '';

    if ($row['pname'] == $product) {
        $selected = 'selected';
    }

    echo '<option value="' . $row['pname'] . '" ' . $selected . '>' . $row['pname'] . '</option>';
}

answered Mar 16, 2015 at 6:49

prava

3,9762 gold badges26 silver badges35 bronze badges

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

Comments

cyber_rookie · Accepted Answer · 2015-03-16 06:49:19Z

1

Try this

while ($row=mysqli_fetch_array($result,MYSQLI_ASSOC)) {
   echo "<option value='".$row['pname']."' ";
   if($row['pname']==$product) echo 'selected';
   echo ">".$row['pname']."</option>";
}

answered Mar 16, 2015 at 6:49

cyber_rookie

6655 silver badges9 bronze badges

Collectives™ on Stack Overflow

Selecting a value from select using php

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