oslo Posted February 6, 2013 Report Share Posted February 6, 2013 i get problem with 'insert' in this function. logically, i think its ok but.... function iInsert($list_tbl=array(), $postData = array()){ $res = count($list_tbl); for($i=0; $i<$res; $i++){ $q = "DESC $list_table[$i] "; $q = mysql_query($q); $getFields = array(); while ($field = mysql_fetch_array($q)){ $getFields[sizeof($getFields)] = $field['Field']; } $fields = ""; $values = ""; if (sizeof($getFields) > 0){ foreach($getFields as $k){ if (isset($postData[$k])){ $postData[$k] = htmlspecialchars($postData[$k]); $fields .= "`$k`, "; $values .= "'$postData[$k]', "; } } $fields = substr($fields, 0, strlen($fields) - 2); $values = substr($values, 0, strlen($values) - 2); //$insert = "INSERT INTO $table ($fields) VALUES ($values)"; $q1=" INSERT INTO ($list_table[$i]) ($fields) VALUES ('$values')"; if (mysql_query($q1)){ return true; }else{ echo mysql_error(); return false; } }else{ return false; } } return true; } Quote Link to comment Share on other sites More sharing options...
sudheerphp Posted February 6, 2013 Report Share Posted February 6, 2013 what it throws, post fully qualified :blink:Error description : Quote Link to comment Share on other sites More sharing options...
oslo Posted February 6, 2013 Author Report Share Posted February 6, 2013 no error and no insert to db! that's the problem cause its no error it doesn't insert the post data Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.