SELECT

$rule_ary = array(
  'user_id' => $user_id,
  'rule_check' => $rule_check
);
 
$sql = 'SELECT rule_id
  FROM ' . PRIVMSGS_RULES_TABLE . '
  WHERE ' . $db->sql_build_array('SELECT', $rule_ary);
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result)

INSERT

$sql = 'INSERT INTO ' . PRIVMSGS_RULES_TABLE . ' ' . $db->sql_build_array('INSERT', $rule_ary);
$db->sql_query($sql);
 
sql_query.txt · 最終更新: 2009/02/10 19:11 by chiron
 
Recent changes RSS feed Creative Commons License Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki