List box

minds_gifts

well, I'm showing all the records in a list box from a table.On selection of a record in this listbox, the corresponding records has to be displayed.

well, there are 2 tables:themes, subthemes:

In themes there are:theme_id, theme_name

In subthemes there are:subthemes_id, theme_id, subthemes_name.

At first, I'm displaying theme_name, on selecting any record the corresponding subthemes names are to be listed.How can i do this??

So far, I'm done with my first part, how can i proceed with the second one.

Many thanks

Here is my code:

<?

$sql = "SELECT THEME_NAME FROM themes";

$result = mysql_query($sql);
?>
<form>
  <SELECT NAME="Select1" SIZE="1">
<?
while ($items = mysql_fetch_array($result))
{
?>
  <OPTION VALUE="<? echo $items['THEME_NAME'] ?>">
  <? echo $items['THEME_NAME'] ?>
  </OPTION>
<?
}
?>
  </SELECT><BR>
</form>

sgoku01

<?php
$sql = "SELECT * FROM themes";

$result = mysql_query($sql);
?>
<form>
  <SELECT NAME="Select1" SIZE="1">
<?
while ($items = mysql_fetch_array($result))
{
$get_sub = mysql_query("SELECT * FROM subthemes WHERE theme_id = '".$itmes['theme_id']."');
$sub_theme = mysql_fetch_array($get_sub);
?>
  <OPTION VALUE="<? echo $items['THEME_NAME'] ?>">
  <? echo $items['THEME_NAME'] ?>
  </OPTION>
  <OPTION VALUE="<? echo $sub_theme['subthemes_name'] ?>">
<? echo $sub_theme['subthemes_name'] ?>
</OPTION>
<?
}
?>
  </SELECT><BR>
</form>

I think that has to work 🙂
If not, please say, and I will have a closer look 🙂

minds_gifts

Hello,

Thanks for your help.But, I'm sorry to tell you, it does'nt work exactly, but its almost.

Well, I changed my table names:it looks like as follows:

thema(thema_id, thema_name)
unterthema(unterthema_id, thema_id,unterthema_name)

I'm getting all those listed in one list box.

could you please correct it.

Thanks in advance

sgoku01

<?php
$sql = mysql_query("SELECT * FROM thema");

echo "Field one [ themes ] :";
echo "<select name=\"Select1\" size=\"1\">";
while ( $item = mysql_fetch_array($sql) ) 
{
echo "<option value=\"".$item['thema_name']."\">".$item['thema_name']."</option>";
}
echo "</select>";

echo "<br>Field two [ sub-themes ] :";
echo "<select name=\"Select2\" size=\"1\">";
while ( $item = mysql_fetch_array($sql) )
{
$get_sub = mysql_query( "SELECT * FROM unterthema WHERE unterthema_id = ' ".$item['thema_id']." ' ");
$sub = mysql_fetch_array($get_sub);

echo "<option value=\"".$sub['unterthema_name']."\">".$sub['unterthema_name']."</option>";
}
echo "</select>";
?>

I think this has to work 🙂

minds_gifts

sgoku01,
thanks for your help, but still it does'nt seems to work.i aint sure why??the code seems to be productibve though;-)

sgoku01

What isn't working? What error(s) do you get?

minds_gifts

well, now, I dont get my records displayed from the tables.

on the first list box, i get my records displayed from the table thema.

when i select those records, i dont get the corresponding records displayed from the table unterthema.

Also, I have a question concerning the following st:

echo "Field one [ themes ] :";

Does this print the first field name of the table themes??and so with the other st:

echo "<br>Field two [ sub-themes ] :";

Thanks for your time.

sgoku01

About the strings:
Nothing to worry about, it's just a little bit of text 🙂
Ignore it.

About the script:
Oow, I thought you wanted to display all the records on the same page...
If you want to select a theme and then see the subtheme, you have to submit the 'thema' and then select the 'unterthema'.

I'm running a bit out of time now, so I can't make a script for you. Try it for yourself, and if it doesn't work out, pm me or something 🙂