Hi All!
While this is not a huge problem, it is a recurring one so I thought I would
see if someone else has a nice generic way of handling this situation. I
often set up database tables with a PHP4 interface to handle insertions.
It is always set up on a CGI basis, wherein a form blasts variable names and
values to the interface, which does the insert. Often a table consists of a
few hundred variables. Clearly when entering the variables by name into
the statements below, there is room for little errors to creep in, even
though I copy the var names from a table export. For example, in a list
of 500 variable names I might accidentally not copy a variable or miss part
of one inadvertantly. This takes a while to find.
$Entry=MYSQL_QUERY("INSERT INTO seniors(interviewer, surveynum, dat, q1_1,
q1_2, q1_3, q1_4)
VALUES('$interviewer', '$surveynum', '$dat', '$q1_1',
'$q1_2', '$q1_3', '$q1_4')");
Being a klutz, I frequently make assorted little errors and it takes some
time to figure where I have screwed up each and every time I set up one of
these things.
I'm wondering therefore if there is a Better Way than using the exact
variable names. For example, using something like a while statement
including :
while(list($key, $val) = each($HTTP_GET_VARS)) { clever stuff here } Does
anyone have ideas on how to do this better? I don't think that I am being
efficient. . .
Thanks!
-Warren
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
