Make Select Selected with php

Question

Possible Duplicate:
How to make <option selected=“selected”> set by MySql and PHP?

I have made a select in my page. This Select draw the options from a database. The Select is:

<select name="name" id="name">
<?php
$pelatisquery="SELECT onoma_pelati FROM pelates_onoma";
$pelatisresult=mysql_query($pelatisquery) 
or die ("Query to get data from firsttable failed: ".mysql_error());
while ($pelatisorow=mysql_fetch_array($pelatisresult)) {
$onoma_pelati=$pelatisorow[onoma_pelati];
echo "<option>
$onoma_pelati
</option>";
}
?>
</select>

This select is in my main page. So in the Edit page I want to retrieve this Select with one option Selected from the database. So my Edit page is:

include_once "../../db_connection.php";
if (isset($_GET['id']) && is_numeric($_GET['id']) && $_GET['id'] > 0)
{
$id = $_GET['id'];
$result = mysql_query("SELECT id,pelatis FROM poliseis WHERE id=$id")
or die(mysql_error());
$row = mysql_fetch_array($result);
if($row)
{
$pelatis = $row['pelatis'];
}
}

So if the Select had options I will use this code:

<?php if($pelatis== "James") { echo 'selected = "selected"'; } ?>

But now how to make <option selected="selected"> ? Thank you in advance for your answers

I tried reading your question, but I just couldn't understand it properly. Can you edit it? — Kneel-Before-ZOD, Dec 14 '12 at 00:18
All you really need to know is the last sentence to understand. — bobthyasian, Dec 14 '12 at 00:27
Sorry for the confusion. I edit my post. I hope it's more understandable now. — James Fourikis, Dec 14 '12 at 01:02
I found the solution! The code is: {$onoma_pelati}"; } ?> Thank you all! — James Fourikis, Dec 14 '12 at 01:35
@Waleed Khan I think that bobthyasian means the line that I edit. — James Fourikis, Dec 14 '12 at 01:37

score 1 · Answer 1 · answered Dec 14 '12 at 00:14

1

Google is your friend.

<option value="" selected="selected"></option>

<option value="" selected></option> //works too but less cross-browser friendly

answered Dec 14 '12 at 00:14

bobthyasian

945
5
17

Sorry for the confusion. I edit my post. I hope it's more understandable now. – James Fourikis Dec 14 '12 at 01:01
I found the solution! The code is: {$onoma_pelati}"; } ?> Thank you all! – James Fourikis Dec 14 '12 at 01:35

Make Select Selected with php

1 Answers1