This isn't the code you were talking about but it's something I wrote and use all the time. update_table() requires a "where" variable which is an array which needs to be declared before the function is called. The $where array is only 2 parts with the column name as [0] and the condition as [1]. It would be declared something like: $where=array("name","George"); They both require $db as the database pointer and $db_name as the database name. insert_table() has the option of using a second database ($db_name2, $db2) if desired. I haven't needed this feature in update_table() yet so I didn't add it in. It wouldn't be hard to take the code from one to the other if needed.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ function update_table($table,$where){ GLOBAL $db,$db_name,$HTTP_POST_VARS; $fields = mysql_list_fields($db_name, $table, $db); $columns = mysql_num_fields($fields); for ($i = 0; $i < $columns; $i++) { $colnames[$i]= mysql_field_name($fields, $i); } foreach($HTTP_POST_VARS as $key=>$value){ if(in_array($key,$colnames) AND $value!="~NULL~"){ $value=addslashes($value); $save.="$c $key='$value'"; $c=","; } } $update="UPDATE $table SET $save WHERE $where[0]='$where[1]'"; mysql_query($update,$db); } ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ function insert_table($table,$db_name2="",$db2=""){ GLOBAL $db,$db_name,$HTTP_POST_VARS; $db1=$db; if($db2!="")$db1=$db2; $db_name1=$db_name; if($db_name2!="")$db_name1=$db_name2; $fields = mysql_list_fields($db_name1, $table, $db1); $columns = mysql_num_fields($fields); for ($i = 0; $i < $columns; $i++) { $colnames[$i]= mysql_field_name($fields, $i); } $cols="("; $save="("; foreach($HTTP_POST_VARS as $key=>$value){ if(in_array($key,$colnames) AND $value!="~NULL~"){ if($value==" ")$value=""; $value=addslashes($value); $cols.="$comma$key"; $save.="$comma'$value'"; $comma=","; } } $cols.=")"; $save.=")"; mysql_query("INSERT INTO $table $cols VALUES $save",$db1); } ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "Rory O'Connor" <[EMAIL PROTECTED]> wrote in message 20011109191732.B783@jacktasty">news:20011109191732.B783@jacktasty... > A while back somebody answered a question about some PHP code that would > take the $HTTP_POST_VARS and create the SQL that would write them to a > MySQL table (provided the posted var names matches the MySQL > fieldnames). > > Does anyone have info on that project? The PHP searchable archive is > down, otherwise I wouldn't be asking on the list. > > Thanks, > Rory -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]