Please visit the mysql website and read up on 'joins'. I guess you haven't seen siva kumar's mail either. You can see an archived version here.
http://www.mail-archive.com/[EMAIL PROTECTED]/msg128334.html
Junaid Saeed Uppal wrote:
Hello Everyone,
I am trying to make 2 drop down boxs using data from a mysql database , the code is attached , the problem is I have a category and a sub category table. The link between the two tables is the id ( ID in category table & mid in subcat tables are the same ) . So i would like to make 2 drop down boxes , one with the categories and the other with the the subcategories of that specific category. I have written some code , which displays the category just fine .. but doesnt display the subcategory :(. Kindly help me out , My code is attached
regards
~junjun
/////////////////////////////////////////////////////////////////////// Code Starts//////////////////////////////////////////////////////////////////
<html>
<head>
<title>Bismillah</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<script>
function ProcSel(title) {
SetCookie("subcat",title.value);
self.location.reload();
}
function SetCookie (name,thevalue) {
document.cookie = name + ' = ' + thevalue + ';';
}
</script>
<form name="form1" method="post" action="value.php">
<p> Subject Category:
<?PHP
include("conn.php");
$rslt = mysql_query("SELECT id, title from vu_mcats");
echo "<SELECT NAME='title' onChange='ProcSel(this)' SIZE='1'>n";
if ($cmfg=="")
if(mysql_num_rows($rslt))
$cmfg=mysql_result($rslt,0,"title");
while ($row = mysql_fetch_array($rslt)) {
echo "<OPTION VALUE='".$row['title']."'";
if ($cmfg == $row['title'])
echo " SELECTED>".$row['title']."";
else
echo ">".$row['title']."";
}
echo "</SELECT>";
?>
Choose Model:</TD>
<?PHP
$rslt = mysql_query("SELECT mid,id,title FROM vu_cats WHERE mid='$id'");
echo "<SELECT NAME='subcat' SIZE='1'>n";
while ($row = mysql_fetch_array($rslt)) {
echo "<OPTION VALUE='".$row['title']."'>".$row['title']." (".$row['id']." VA)n";
}
echo "</SELECT>n";
?>
</p>
<p>
<input type="submit" name="Submit" value="Submit">
<input type="reset" name="Submit2" value="Reset">
</p>
</form>
<p> </p></body>
</html> ///////////////////End of Code//////////////////////////
-- Raditha Dissanayake. ------------------------------------------------------------------------ http://www.radinks.com/sftp/ | http://www.raditha.com/megaupload Lean and mean Secure FTP applet with | Mega Upload - PHP file uploader Graphical User Inteface. Just 150 KB | with progress bar.
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
