I have a MySQL table where I read some rows that match my sale type.
I place the index and description into an HTML drop down box for my sales agent
(in-house) to select from.
When they make a selection, I would like to populate some text boxes with the
associated data like price and weight, etc.
So far, I have the data in a php array, one per record that matches the possibilities.
for ($i = 0; $i < $SCRows; ++$i)
$row = mysql_fetch_array($SCResult);
if ($row['Category'] = 'S')
$SCCodes[$i] = " <option Value=".$row['SCRecNo'].'>'.$row['CallResultDescription'].'</option>\n\r';
$SCJSON[$i] = " <option Value = ".$row['SCRecNo'].'>'.json_encode($row)."></option>\n\r";
I have the data in memory, I am trying to not call the server again (I don't know how to, I presume AJAX but I don't know AJAX, yet...
I was going to put a json_encode string as the text in a hidden drop down and traverse that
associated values in a text box for the agent to see the values that go with their selection.
Am I clear?
Thanks in advance!