[Resolved] Dynamic SQL queries

[spstieng]

I'm dynamically trying to create an UPDATE query.

I have a form

<form name="updateOrganization" action="update.php?orgID='.$_orgID.'" method="post">
  Different fields here....
</form>

Then I have my update.php

$query =' UPDATE `organization` SET ';

foreach($_POST as $key => $value) 
{
   if ($value)
    {  $query.= '`'.$key.'` = `'.$value.'`,';  }
}

$query.='WHERE orgID = '.$_orgID.' LIMIT 1';

The result of the query can e.g. be:

UPDATE organization SET
orgID = 454545080,
orgName = A. E. Haavik AS1,
addPostName = VOLDA,
orgEmail = [e-mail],
orgUrl = [url]http://www.tomshardware.com[/url],
WHERE orgID = 454545080 LIMIT 1

My Problemo
orgUrl = [url]http://www.tomshardware.com[/url], <-------- how can I avoid this last comma?????

Any suggestions appreciated!!

[bastien]

use [man]substr[/man]

or

create a count of optoins then when the count matches the number of options run an append without the ending comma

[spstieng]

$query = substr($query, 0,-1);

Worked perfectly.
Sometimes one is so deep into the code, that one can't see the simple solutions ;-)

Thanks mate