phpcms2008SQL语法

查询

$db->get_one("SELECT ip,tol FROM ".DB_PRE."xianzhidenglu WHERE ip='{$ip}'");

$sql = 'SELECT namount FROM tbs_member_cache WHERE userid='.$id;
$attr=$db->select($sql);

插入

  $db->query( "INSERT INTO " . DB_PRE . "xianzhidenglu SET ip='{$ip}',tol=1,time='{$time}'" ) ;

更新

$db->query("UPDATE " . DB_PRE . "xianzhidenglu SET tol={$array[tol]}+1 WHERE ip='{$ip}'");

删除

$db->query("DELETE FROM ".DB_PRE."pingjia WHERE pid=".$pid);