Drop down list SELECTED ???

[jonsof]

I have the following code

<option value="">Chose a category</option>
<option value="">----------------------</option>
<? mysql_connect("localhost");mysql_select_db(db_name);
$result1=mysql_query("SELECT categoryid, category FROM categories");
 while($row=mysql_fetch_assoc($result1)) {
 if($row['categoryid']==$post_element['categoryid']) {
 echo "<option value=".$row['categoryid']."selected>".$row['category']."</option>";}
else {echo "<option value=".$row['categoryid'].">".$row['category']."</option>";}}?>
</select>

It doesn't work, i am retrieving all the fields of a table, one of them is the categoryid, i wanna match the categoryid from the table categories and from table post in order to one element from the list to be selected

Am i on the right way?

[eriksmoen]

.
try $_POST['name_of_select'] instead of $post_element...

what your script is doing is comparing categoryid to itself, causing it to return true every time.

hope that helps.

[DigitalExpl0it]

yeah somthing like this

<?
mysql_connect("localhost");mysql_select_db(db_name);
$result1=mysql_query("SELECT categoryid, category FROM categories");
?>
<select name="select">
<option value="">Chose a category</option>
<option value="">----------------------</option>
<? 
   while ($row = mysql_fetch_array($result1)){
		$rs_fld1 = $row["categoryid"];  

  if($rs_fld1 == $_REQUEST[categoryid]) {
 echo "<option value=".$rs_fld1."selected>".$rs_fld1."</option>";
 } else {
 echo "<option value=".$rs_fld1.">".$rs_fld1."</option>";
 }
}
?>
</select>

[jonsof]

i forgot to show the rest code which is placed before the one above i have written.

<? $post_id_to_edit=$_GET['post_id'];
$result=mysql_query("SELECT * FROM post WHERE postid='$post_id_to_edit'");
$post_element=mysql_fetch_assoc($result);
echo $post_element['categoryid'];?>

[jonsof]

Your code it didn't work 🙁🙁🙁

Where the fault?Besides the $post_element['categoryid'] has a value and comes from another table called Post.
As you can sense categoryid is the foreign key in the post table.

any little help?

[eriksmoen]

.
you are still comparing it to itself. it should be something like:

if($row['categoryid']==$post_id_to_edit)

this way it will compare it to your input, not itself. I hope I'm understanding what you are saying and not confusing you:rolleyes:

[jonsof]

$row['categoryid'] and $post_id_to_edit are different values
The first comes from the table Categories and the second is the post_id each post you click on in order to edit it.

[eriksmoen]

<? 
$post_id_to_edit=$_GET['post_id'];
$result=mysql_query("SELECT * FROM post WHERE postid='$post_id_to_edit'");
$post_element=mysql_fetch_assoc($result);
echo $post_element['categoryid'];
?>
<option value="">Chose a category</option>
<option value="">----------------------</option>
<? 
mysql_connect("localhost");mysql_select_db(db_name);
$result1=mysql_query("SELECT categoryid, category FROM categories");
 while($row=mysql_fetch_assoc($result1)) {
  if($row['categoryid']==$post_element['categoryid']) {
 echo "<option value=".$row['categoryid']." selected>".$row['category']."</option>";}
else {echo "<option value=".$row['categoryid'].">".$row['category']."</option>";}
}
?>
</select>

sorry... didn't realize it was comparing two tables... the only thing i saw that might compromise the script is that there was no space in front of select. You might want to look at the source that your page generates, and try to see if it is the space that is causing the problems. otherwise, i see nothing wrong with it 😕 .

[jonsof]

Which Select?That's from Sql or Html??? 🙂🙂

[eriksmoen]

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

...sorry i didn't ellaborate 😃

[jonsof]

a TERRIBLE mistake of mine, oh dear i wasted my time 🙁

BUT thank you for your observation, it worked properly at last.

[eriksmoen]

.
it's funny how the hardest problems can have the simplest solutions🆒