Page 1 of 1

display data Help

Posted: Thu Mar 03, 2005 5:28 am
by cylleezz
Hi guys,

I need some helps from the follow script:

Code: Select all

<?PHP
$Host = "localhost";
$User = "root";
$Passwd = "";
$DBName = "temp_database";
$TableName = "topic";

$Link = mysql_connect($Host, $User, $Passwd) or die("Could not connect: " . mysql_error());

$Query = "SELECT Distinct topic_id FROM $TableName";
$Result = mysql_db_query( $DBName, $Query, $Link );
?>
<HTML>
<HEAD>
<SCRIPT language="JavaScript">
<!--
function BodyLoad() &#123;
var select = document.FormName.Main_category;
select.options&#1111;0] = new Option("Choose One");
select.options&#1111;0].value = 0;
<?PHP
$ctr = 1;
While( $Row = mysql_fetch_array($Result) ) &#123;
echo "select.options&#1111;$ctr] = new Option("$Row&#1111;topic_id]");\n";
echo "select.options&#1111;$ctr].value = "$Row&#1111;topic_id]";\n";
$ctr++;
&#125;
?>
&#125;
function Fill_Sub() &#123;
var main_select = document.FormName.Main_category;
var sub_select = document.FormName.Sub_category;
if( main_select.options&#1111;main_select.selectedIndex].value != 0 ) &#123;
sub_select.length = 0;
&#125;
<?PHP
$Query = "SELECT Distinct topic_id FROM $TableName";
$Result = mysql_db_query( $DBName, $Query, $Link );

while( $Row = mysql_fetch_array($Result) ) &#123;
?>
if( main_select.options&#1111;main_select.selectedIndex].text == "<?PHP echo $Row&#1111;topic_id]; ?>" ) &#123;
<?PHP
$Query2 = "SELECT topic_name FROM $TableName WHERE topic_id = '$Row&#1111;topic_id]'";
$Result2 = mysql_db_query( $DBName, $Query2, $Link );

$ctr = 0;
While( $Row2 = mysql_fetch_array($Result2) ) &#123;
echo "sub_select.options&#1111;$ctr] = new Option("$Row2&#1111;topic_name]");\n";
echo "sub_select.options&#1111;$ctr].value = "$Row2&#1111;topic_name]";\n";
$ctr++;
&#125;
?>
&#125;

<?PHP
&#125;

mysql_close($Link);
?>
&#125;
 -->
</SCRIPT>
</HEAD>
<BODY onload="BodyLoad();">
<FORM name="FormName" method="POST" action="">
<TABLE border="1">
<TR>
<TD>Main Category</TD>
<TD>Sub Category</TD>
</TR>
<TR>
<TD>
<SELECT name="Main_category" onchange="Fill_Sub();"></SELECT>
</TD>

<TD>
<SELECT name="Sub_category" size="4"></SELECT>
</TD>
</TR>
</TABLE>
</FORM>
</BODY>
</HTML>
The problem is that select box is not poulating...any help is apprecaited :)

Posted: Thu Mar 03, 2005 6:03 am
by CoderGoblin
While should be while....

Posted: Thu Mar 03, 2005 8:02 am
by feyd
warning: nesting queries can lead to dangerous side-effects.

These queries can be compacted to a single JOIN.