[RESOLVED] PHP form trouble with drop down list!

[king_uk]

Hi,

I have been creating an online database and have just encountered a problem.

with my drop down lists I use this code so that when I edit records the original data is still there:

<select name="name" id="name">
<option <? if($name=="Please Select"){ echo "selected";}?> >Please Select</option>
<option <? if($name=="option"){ echo "selected";}?> value="option">Option</option>
<option <? if($name=="option2"){ echo "selected";}?> value="option2">Option 2</option>
value="Other">Other</option>

</select>

My trouble is that I now want another drop down list that uses dynamically generated options which works fine. The problem is I can't get it to show the correct record when editing the data

<select name="source" id="source">
<?
$result = mysql_query("SELECT * FROM source");
while($row = mysql_fetch_array($result)){
?>
<option value="<?=$row['source']?>"><?=$row['source']?></option>
<?
}
?>

  </select>

Any help will be gratefully appreciated
Thanks

[Kudose]

<?php
  echo '<select name="source" id="source">';
  $result = mysql_query("SELECT * FROM source");
  while($row = mysql_fetch_array($result)){
    echo '<option value="'.$row['source'].'"';
    if($name == $row['source']) echo ' selected';
    echo '>'.$row['source'].'</option>';
  }
  echo '</select>';
?>

[king_uk]

Thanks for the quick reply kudose.

Unfortunlatly still doesnt work.

My fault though.

I forgot to mention that this form is entering into a customer table and that i am and thats where i need the data pulled from when im editing, but my table is also used when entering a new customer thats where my problem lies.

[Kudose]

Can you post more of your code? Please place it between the boards BB tags php and/or html

i.e.

[ php ] echo 'hello'; [ / php ]

Without spaces is

echo 'hello';

[king_uk]

  <form name="form1" method="post" action="index.php?base=leads&amp;page_id=lead&amp;action=<? if($_GET['action']=="new"){echo "insert";}else{echo "update&pid=".$_GET['pid'];}?>">
...

<select name="source" id="source">
<?
$result = mysql_query("SELECT * FROM source");
while($row = mysql_fetch_array($result)){
?>
<option value="<?=$row['source']?>"><?=$row['source']?></option>
<?
}
?>

</select>

[king_uk]

not sure what code you really need.
the rest of that page is just simple form stuff

[Kudose]

I am kinda confused, but I think you are looking for

<?php
  echo '<select name="source" id="source">';
  $result = mysql_query("SELECT * FROM source");
  while($row = mysql_fetch_array($result)){
    echo '<option value="'.$row['pid'].'"';
    if($_GET['pid'] == $row['pid']) echo ' selected';
    echo '>'.$row['source'].'</option>';
  }
  echo '</select>';
?> 

[king_uk]

Sorry still doesnt work, ill try and explain my db slightly better and what i am trying to achieve.
Thanks for your help by the way.

the two tables i am talking about are customer_details and sources,
when entering a new customer you have to enter their source,

but there are new sources added all the time so that is why i needed the dropdown list to pull data from the sources table dynamically. this works great, the problem is:

that when i come back to edit a certain customer the source field doesnt show the one i chose (it shows the first entry in the sources table) even though in my db admin it shows the correct value

what can i do the code i use for non dynamic drop down boxes works

<option <? if($lead_status=="Please Select"){ echo "selected";}?> >Please Select</option>

but not for the dynamic box i just get errors

hope this makes it more clear
Thanks for your help and for being so patient with the rubbish i keep typing

[Kudose]

Ok, you need to check the client source id against each source's id and select the source id if it matches the client source id ... right?

<?php
  echo '<select name="source" id="source">';
  $result = mysql_query("SELECT * FROM source");
  while($row = mysql_fetch_array($result)){
    echo '<option value="'.$row['source_id'].'"';
    if($client_info['source_id'] == $row['source_id']) echo ' selected';
    echo '>'.$row['source'].'</option>';
  }
  echo '</select>';
?> 

If that doesn't make sense, please post the columns from your database tables and your complete code.

[king_uk]

THANKS KUDOSE,
had to change a few values and it works!!!

Thanks so much for your help.

[Kudose]

No problem. 🙂