Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re: input form and MySQL across columns

by philiprbrenan (Monk)
on Sep 02, 2012 at 22:59 UTC ( #991336=note: print w/ replies, xml ) Need Help??


in reply to input form and MySQL across columns

If you name the input fields like this using a character say - that you know will not occur in your item names:

<input name="Shoes-1" size=2> <input name="Shoes-2" size=2> <input name="Shoes-3" size=2> <input name="Shoes-4" size=2> <input name="Shoes-5" size=2>

and likewise Tires etc. then it will be easy for you to test whether the form has sent you back "Shoes-2" etc. and if it has, you can use a SQL Update statement to modify just the one column in one row:

update ... set qty2 = ... where name = "Shoes";


Comment on Re: input form and MySQL across columns
Select or Download Code
Replies are listed 'Best First'.
Re^2: input form and MySQL across columns
by Anonymous Monk on Sep 03, 2012 at 00:54 UTC
    Naming the input fields with unique names is not an issue, the problem is using multiple input fields on a single row of the MySQL table. I also have working queries to manage the SQL table, again not an issue there. Thanks for your reply.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://991336]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (11)
As of 2015-07-29 12:13 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (263 votes), past polls