"; exit; } $idlink = mysql_select_db($dbname); if(!$idlink) { echo ""; exit; } $sql="SELECT * FROM ".$tbname; $result = mysql_query($sql); $fields = mysql_num_fields($result); $rows = mysql_num_rows($result); for($i=0; $i < $fields; $i++){ $names[$i] = mysql_field_name ($result, $i); $type[$i] = mysql_field_type ($result, $i); } $query1=""; switch ($mode){ case 0: $query1 = "INSERT INTO ".$tbname."("; for($i=0; $i < $fields; $i++){ if ($i!=0) $query1 = $query1.","; $query1 = $query1.$names[$i]; } $query1 = $query1.") VALUES("; for($i=0; $i < $fields; $i++){ if ($i!=0) $query1 = $query1.","; if ($type[$i]=="string" || $type[$i]=="blob") $query1 = $query1."'"; if ($names[$i]=="ID"){ $query2 = "SELECT MAX(ID) as xxxxx FROM ".$tbname; $result2= MYSQL_QUERY($query2); $id=mysql_result($result2,0,"xxxxx"); $id++; $query1 = $query1.$id; } else $query1 = $query1.$$names[$i]; if ($type[$i]=="string" || $type[$i]=="blob") $query1 = $query1."'"; } $query1 = $query1.")"; break; case 1: if ($$names[0]=="") break; $query1="DELETE FROM ".$tbname." WHERE ".$names[0]."=".$$names[0]; $rnum=0; break; case 2: $query1 = "UPDATE ".$tbname." SET "; for($i=0; $i < $fields; $i++){ if ($names[$i]=="ID") $id=$$names[$i]; if ($i!=0) $query1 = $query1.","; $query1 = $query1.$names[$i]."="; if ($type[$i]=="string" || $type[$i]=="blob") $query1 = $query1."'"; $query1 = $query1.$$names[$i]; if ($type[$i]=="string" || $type[$i]=="blob") $query1 = $query1."'"; } $query1 = $query1." WHERE ".$names[0]."=".$$names[0]; break; } if ($query1!="") $result1=MYSQL_QUERY($query1); mysql_close(); require 'db1-3.php3'; ?>