Jump to content


This topic is now archived and is closed to further replies.



Recommended Posts

Lokking for help on building a MySQL UPDATE query

my script does a

foreach ($_POST as $key => $value) {


for the POST array. In the foreach of the $_POST the '$key' is the column name and the '$value' is the column data, respectively.

I need help figuring out how to build that? INSERT queries are a sinch cause all the tables are on one side of the query and values on the other, but UPDATE dictates a table=value, table=value ... etc.

Is there some kind of " array implode function " I am missing?

My solution was to put the following in the foreach;

$string .= "$key='$value', ";

and then just ltrim " , " off the end and build the end of the query.

Is there a better way?

Share this post

Link to post
Share on other sites
Nevermind, I figured it out

I did this:

foreach $_POST as $key => $value) {

$data_string[] = "$key='$value'";



$partial = "UPDATE record SET ";

$partial .= implode(", ", $datastring);

$partial .= " WHERE id='$record_number'";

after it finished it built a fully qualified MySQL UPDATE query.

Thanks to those who took/take the time to look.

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.