[SOLVED] update query with multiple tables

[eluser]maria clara[/eluser]
@seanloving,

i have this code for update and it works..but it doesn't have a validation.. you can try this:

Code:

$sql = 'update '.$crudTableName.' set ';
                foreach($crudColumns as $key => $value){ $updateArray[$key] = $value.'='.$crudColumnValues[$key]; };
                $sql .= implode(',',$updateArray);
                $sql .= ' where role_id = '.$crudColumnValues['id'];
                mysql_query( $sql );

but i used $crudColumns here.

regards,
kahtrina