Inventory List

[Anon]

I hope I can explain this one.

What I have is a database table INVENTORY which in it has colums ID, INV_NAME, QUANTITY, DESCRIPTION and so forth.

What I want to be able to do is have a MULTIROW HTML LIST/MENU that pulls all the data in and have it be scrollable, it will list
INV_NAME } DESCRIPTION | QTY

Is this possible??? DO I make sense?

Kacey

[biggus]

Yeah, you can do it. Ebay had/has up to 6 boxes, where the choice in one sets the choices for the next and so on. You just have to have PHP generate the 2D javascript arrays used to populate the HTML select boxes. The javascript should be in any non-basic reference book. I would send the link to the page on eBay, but I couldn't find where they moved it. If you can't find it, drop me an email and I'll send you some of my versions of that code.

[Anon]

I was hopeing to get some code for this can you help, I understand what I am suppose to do, I even bought like 14 books, but it never seems to be working right, I think I have tried so many times/examples that I am really confused, kinda wanted something working that I could look at to get an idea.

If not thanks for the already mentioned help!

[biggus]

Kacey,

here is some code I used for a project last year. The table is LANGUAGES and the LANUGAGES.ABREVIATION is used for the main array. VERSIONS is a colon-delimited area with numeric version numbers. I used this to build the 2nd dimension of the main array. Instead of that, you'd have a multidimensional javascript array similar to... myarray=["ID"]["INV_NAME"]["QUANTITY"]["DESCRIPTION"] .

<SCRIPT LANGUAGE="JavaScript">
var WfVersionLists = new Array;
<?
$connection=mysql_connect("localhost","root","") or die ("couldn't connect");
$db=@mysql_select_db($myDB, $connection) or die ("couldn't select database");
$SQL="select * from LANGUAGES order by FULL_TEXT asc";
$result=mysql_query ($SQL, $connection) or die ("couldn't execute query<br>sql stmnt=$SQL");
while ($row=mysql_fetch_array($result)){
?>
WfVersionLists["<?echo $row['ABBREVIATION']?>"] = new Array;
<?
$subarray=explode(":", $row['VERSIONS']);
for ($g=0;$g< count($subarray);$g++){?>
WfVersionLists["<?echo $row['ABBREVIATION']?>"]["<?echo $g?>"]="<?echo $subarray[$g]?>";
<?}
}//end while
?>
function setCats(x){
document.lang.WfVersionList.options.length=0;
for(g=0;g<WfVersionLists[x].length;g++){
document.lang.WfVersionList.options[g] = new Option(WfVersionLists[x][g]);
if (document.lang.WfVersionList.options.length==WfVersionLists[x].length){
if (x!=14){document.lang.WfVersionList.options[document.lang.WfVersionList.options.length]= new Option ("------------------");}
}
}
}
function setCats2(){
if (document.lang.WfVersionList.options[document.lang.WfVersionList.selectedIndex].text!="----"){
document.lang.currLangAbbrev.value=document.lang.currLangList.options[document.lang.currLangList.selectedIndex].text + " -> " + document.lang.WfVersionList.options[document.lang.WfVersionList.selectedIndex].text;
}
}
</script>
<form name="lang" action="<? echo $PHP_SELF;?>" onSubmit="return doIt()">
<table width=400 border=0 bgcolor=black cellpadding="1" cellspacing=0>
<td>
<table width=100% border=0 bgcolor=#e6e6e6 cellpadding="4" cellspacing=0>

<tr><td>Please select from the list:</td><td>&nbsp;</td><tr>
<td><select size=5 name="currLangList" onChange="setCats(currLangAbbrev.value);">
<option value="0" default></option>
<?
$connection=mysql_connect("localhost","root","") or die ("couldn't connect");
$db=@mysql_select_db($myDB, $connection) or die ("couldn't select database");//retreive it
$SQL="select * from LANGUAGES order by FULL_TEXT asc";
$result=mysql_query ($SQL, $connection) or die ("couldn't execute query<br>sql stmnt=$SQL");
while ($row=mysql_fetch_array($result)){
?>
<option value="<?echo $row['ABBREVIATION']?>"><?echo $row['FULL_TEXT']?></option>
<?}
mysql_close($connection);
?>
</select>&nbsp;:Language</td>
<td><select size=5 name="WfVersionList">
<option value="0" selected>------------------</option>
</select>&nbsp;:Wf Version</td>
</table></table>
<p>&nbsp;</p>
<input type=submit value="Next Step" class="orange"></form>

Hope that all came through OK. Anymore questions, let me know.