mysql

[phporcaffeine]

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?

[phporcaffeine]

Nevermind, I figured it out

I did this:

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

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

}

then:

$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.