Have you tried it? I've done this sort of thing before, and it works
just fine. By the time the query string is executed, the variables have
So, if $colName = "id", and $id = 12, then your query variable looks
something like "select * from myTable where $colName = $id". By the
time you get to executing the query, it's been interpolated (?) to
"select * from myTable where id = 12".
Michael K. Dolan Jr. wrote:
> Is it possible to do a sort of dynamic sql. For instance, if I have a form with a
>bunch of field/data variables and I send them to a php processor, can I just create a
>loop to have it update all the fields without having to specify each field.
> In scratch code, I guess I'm looking for something like this:
> sql = "UPDATE my_table SET $table_field_name = $table_field_value WHERE table_id =
> If you see how I'm trying to make the field name a dynamic variable, then you can
>see what I'm trying to do. I have no problem with the dynamic field value, it's just
>the dynamic field name that I'm not sure how/if I can create it dynamically.
> Can anyone help with this? Or can anyone tell me it can't be done?
Richard S. Crawford
AIM: Buffalo2K ICQ: 11646404 Yahoo!: rscrawford
MSN: [EMAIL PROTECTED]
"It is only with the heart that we see rightly; what is essential is
invisible to the eye." --Antoine de Saint Exupery
"Push the button, Max!"
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]