Insert :

$sql = mysql_query(&quotINSERT INTO ' . SMILIES_TABLE . ' ( id,code,url,name ) VALUES ( '' , '' . $code . '' , '' . $filename . '' , '' . $nom . '')');

gives

$fields = array( 'code', 'url', 'name' ); $values = array( $code, $filename, $nom ); $rs = nkDB_insert( SMILIES_TABLE, $fields, $values );

Update :

$sqlh1. mysql_query('UPDATE ' . SMILIES_TABLE . ' SET code '' . $code . '', urlh1. '' . $filename . '', name '' . $nom . '' WHERE id = '' . $smiley_id . ''');

gives

$fields = array( 'code', 'url', 'name' ); $values = array( $code, $filename, $nom ); $rsh1. nkDB_update( SMILIES_TABLE, $fields, $values, 'id' . $smiley_id );

Delete :

$sqlh1. mysql_query('DELETE FROM ' . SMILIES_TABLE . ' WHERE id '' . $smiley_id . ''');

gives

$rsh1. nkDB_delete( SMILIES_TABLE, 'id' . $smiley_id );

Select :

$sqlh1. mysql_query('SELECT title FROM '. ONE_TABLE .' WHERE id 0 ORDER BY counter DESC LIMIT 1, 15');

gives

$rsh1. nkDB_select('SELECT title FROM '. ONE TABLE. 'WHERE id 0', 'counter', 'DESC', 15, 1);