Hi All,

I've created an function for update record in database's table.

the function can handle all the record update from any table... with parameter passed 
in .. like this :

function update($table,$values,$condition)
   { $link=$this->database();
     $fields = mysql_list_fields("wellindo", $table, $link);
              $columns = mysql_num_fields($fields);
     for ($i = 1; $i < $columns-1; $i++) {
     $field_values=$field_values.mysql_field_name($fields, $i)."=".$values[$i];
     $query = "UPDATE $table SET $field_values $condition";
the function will find all the fields of the table then update all the data.

the problem is that when there ar some fields that I dont want to update (I still want 
to use the existed/old data )...
so how do I do that...??

eg : I hav record 
name   phone      country
a          123        England
and i want to update only phone change to 234.... what can do to set name and country 
so that it still remain the old data

sorry for the awful explaination....hope someone can get it... 

By regard;


Reply via email to