haggis-man

A client would like me to implement spreadsheet-style form traversal using the arrow keys on a keyboard, i.e. left arrow would submit the entry for that field and then move left by one field on the form. The form is managed by my PHP code. Does anyone have a [U]browser-independent[/U] …

[code=sql]UPDATE `isc_products` SET `prodprice` = (`prodcostprice` * 1.20) WHERE `prodcostprice` >= 0 AND `prodcostprice` <= 1000 ; UPDATE `isc_products` SET `prodprice` = (`prodcostprice` * 1.18) WHERE `prodcostprice` >= 1001 AND `prodcostprice` <= 2000 ;[/code] If prodcostprice can have decimal places then you need to edit to handle values between 1000 …

I would like to send code along with my form to re-map a couple of keys. Specifically ... Right arrow key to act like TAB Left arrow key to act like Shift+TAB Is this possible please?

I was hoping that there would be a readonly system or session variable such as @@username or @@user_id or similar Is there any way I can access username information inside an SQL database please? I am hoping to use it to render certain ROWS visible/invisible in views This would be …

I haven't used the mySQL permissions mechanism to any great degree & could use a little help while still at the design stage. Is it possible to grant certain users access only to certain RECORDS within a table (based on the value of a field in those records). If not, …

A client would like me to implement spreadsheet-style form traversal using arrow keys, i.e. left arrow to submit entry and move left by one field on the form, and so on. Does anyone have a browser-independent method of doing this please? All input fields are single line text fields.

Bear in mind that some users may choose to set their browsers to accept or decline cookie requests. I don't have the whole picture from what you've entered but you may find that $_SESSION variables will do the job for you instead. They have super-global scope.

I wish to pass an array of arbitrary content via a hidden field in a form which uses the POST method [CODE]$targets = any old array; ... build form to include ... <input type=hidden id=targets title=targets name=_targets value=\"".htmlspecialchars( serialize( $targets ))."\">[/CODE] Clearly this requires some use of the htmlspecialchars() or …

I would suggest you create an entirely new table with only two fields ... full name and acceptable abbreviation for each customer. Any automated attempt to join tables as you describe will, I surmise, only run into problems since "ABC LIMITED" can be derived from many many other names.

I am also interested in UTF-8 support PDFlib Lite since I need to write Cyrillic text into a PDF. Any suggestions please?