Echo Option from 1 single column

Question

Hello guys I have this table :

ID| NUM_Slides |P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12
3 | 2          |1  | 1  | 0  | 0  | 0  | 0  | 0  | 0  | 0  | 0   | 0   | 0

I want to select the values only from P1,P2,P3,P4,P5,P6,P7,P8,P9,P10,P11 and P12 and insert them into a <option> tag

I got this so far but dont work

<?php
$query = "SELECT P1,P2,P3,P4,P5,P6,P7,P8,P9,P10,P11,P12 FROM slider_settings_img where slider_settings_img.ID = $ID";
$result1 =$connect->query($query);
$resultado = $result1->fetch_all();
?>

<select name ="selectedValue" id="selected" >
<?php while($row1 = mysqli_fetch_array($result1)):;?>
<option value=""<?php echo $row1[1];?>"><?php echo $row1[1];?>"</option>
<?php endwhile;?>
</select>

because my query only return 1 array I want the Options to be display 1,1,0,0,0,0,0,0,0,0,0

can some 1 help me

@Fred-ii- Did you mean that the extraneous `;` was causing the problem? I don't think that matters when using the alternate loop syntax. — Don't Panic, Jun 06 '17 at 16:23
@Don'tPanic Ummm... I'm pretty sure it does ;-) it ends that statement. Here http://php.net/manual/en/language.basic-syntax.instruction-separation.php pretty sure you've seen that ;-) — Funk Forty Niner, Jun 06 '17 at 16:24
@Don'tPanic try out their code then, am pretty sure *the buck will stop there* — Funk Forty Niner, Jun 06 '17 at 16:26

Don't Panic · Accepted Answer · 2017-06-06T16:40:35.397

2

There are several problems.

$resultado = $result1->fetch_all(); You can't fetch any more rows in your while loop if you've already fetched them all.
while($row1 = mysqli_fetch_array($result1)):; Your query selects one row. You don't need to use a while loop at all.
That while loop is set up to iteratively fetch rows from a query result, but you need to fetch one row and iterate over its columns.
Couple of important typos.

<?php
$query = "SELECT P1,P2,P3,P4,P5,P6,P7,P8,P9,P10,P11,P12
          FROM slider_settings_img where slider_settings_img.ID = $ID";
$result1 = $connect->query($query);
$row = mysqli_fetch_assoc($result1);    // fetch one row
?>
<select name ="selectedValue" id="selected" >
<!-- iterate over each column of the row -->
<?php foreach ($row as $col): ?>
    <option value="<?php echo $col ?>"><?php echo $col ?></option>
<?php endforeach ?>
</select>

edited Jun 06 '17 at 16:40

answered Jun 06 '17 at 16:15

Don't Panic

41,125
10
61
80

`` => `` as an FYI, will end *lol* – Funk Forty Niner Jun 06 '17 at 16:25
well that is quite odd – Funk Forty Niner Jun 06 '17 at 16:30
@Fred-ii- it's waiting for the endforeach. It sees the `;` as just another statement before that. – Don't Panic Jun 06 '17 at 16:31
oh wait a minute; that may be true for a `foreach`, but not for a `while` loop – Funk Forty Niner Jun 06 '17 at 16:31
Just tried it @Fred-ii- Its ugly but the while works with the `;` – RiggsFolly Jun 06 '17 at 16:35
I mean, don't get me wrong. The `;` shouldn't be there. It just doesn't do anything in this case. It messes things up if it comes before a brace because it separates the loop definition from the body, but with the alternate syntax it's just another statement inside the loop. – Don't Panic Jun 06 '17 at 16:37
@Don'tPanic It "work's but I need to have only 12 options with this code I have 24 the double you know why? – Rafael Sousa Jun 06 '17 at 16:37
(`C#` (and php)) https://stackoverflow.com/q/8706139/1415724 --- http://php.net/manual/en/control-structures.while.php – Funk Forty Niner Jun 06 '17 at 16:39
@RafaelSousa Ah, probably because no fetch style was specified in `mysqli_fetch_array`, and it's using `MYSQLI_BOTH` by default. – Don't Panic Jun 06 '17 at 16:39
@RafaelSousa try using `mysqli_fetch_assoc` instead. I updated the answer. – Don't Panic Jun 06 '17 at 16:41
@Fred-ii- That Q is using braces, though. – Don't Panic Jun 06 '17 at 16:46
@Don'tPanic what braces? to me, braces are `{...}` did you mean parentheses `(...)`? I'm getting rather confused by everything *lol!* – Funk Forty Niner Jun 06 '17 at 16:52
@Fred-ii- lol sorry, I'm not doing a great job expressing what I think the reason is. One more attempt: https://3v4l.org/h1YRd – Don't Panic Jun 06 '17 at 17:01
@Don'tPanic No worries. I'm just wondering about the OP here and what's the status of the question. – Funk Forty Niner Jun 06 '17 at 17:41

score 0 · Answer 2 · answered Jun 06 '17 at 16:11

0

How about this?

<select name ="selectedValue" id="selected" >
<?php while($row1 = mysqli_fetch_array($result1)) 
{
    for($i=2; $i<13; $i++) {
        echo '<option value="'.$row1[$i]'">'.$row1[1].'</option>';
    }
} 
?>
</select>

answered Jun 06 '17 at 16:11

Oleg Dubas

2,320
1
10
24

Echo Option from 1 single column

2 Answers2