I have the official qQuery autocomplete plugin ( from bassistance) working properly. Start typing a product name and it queries my php script and mysql to return a list of products.
However, when the user submits the form, I want a hidden form field that contains the row ID for that product in the database table. I would have thought that this is a very common need, but I did not see any of the examples in the doc or website.
SELECT sensor, sensorID FROM sensorTable WHERE sensor LIKE '\\\\$q%' "
Desired form for submission
<input type="text" id="sensor" />
<input type="submit" name="retrieveSensor" value="Get Sensor" />
<input type="hidden" name="rowID" value="...returned from ajax call..." />