21,891
社区成员
发帖
与我相关
我的任务
分享找一个用过 txtSQL 的人请救：我的 SELECT 语句错在哪儿？
SELECT * FROM soft.soft WHERE needaccept = FALSE and cateid = 0 LIMIT 1,2 ORDERBY dtime DESC
...全文
请发表友善的回复…
发表回复
eingmarra 2005-06-30
- 打赏
- 举报
needaccept = 'FALSE ' ???
山雨欲来-风满楼 2005-06-30
- 打赏
- 举报
txtSQL是啥东东来着?
然后而且一个SQLyog这样可视界面,这样可以方便地得到错误提示~~
然后而且一个SQLyog这样可视界面,这样可以方便地得到错误提示~~
xuzuning 2005-06-30
- 打赏
- 举报
请告知txtSQL的出处
Altaori 2005-06-30
- 打赏
- 举报
http://chibiguy.dotgeek.org/
swzlxm 2005-06-30
- 打赏
- 举报
up
Cain 2005-06-30
- 打赏
- 举报
txtSQL是啥东东??
uuq 2005-06-29
- 打赏
- 举报
needaccept = FALSE 是不是这个问题
有哥 2005-06-29
- 打赏
- 举报
楼上，我本来就是跟你所说的一样了，不行啊。
顺便问一句，你真的用过txtSQL吗？
顺便问一句，你真的用过txtSQL吗？
枫与风月 2005-06-29
- 打赏
- 举报
SELECT * FROM soft.soft WHERE needaccept = FALSE and cateid = 0 ORDER BY dtime DESC LIMIT 1,2
TXTSQL是一种文本数据库,文件存储方式类似mysql，兼容部分sql语句.
PHP需4.0以上版本才能运行。
官方网站：http://txtsql.com/
txtSQL简单例子（来源：http://smvcn.xhblog.com/archives/2007/259845.shtml）
xtSQL.class.php');
$sql = new txtSQL('./data');
$sql->connect('root', 'bar');
/*创建数据库
$sql->createdb(array('db' => 'demo')) or die('Error creating txtSQL DB, txtSQL said: '.$sql->get_last_error());
*/
/*选择数据库*/
$sql->selectdb ( 'demo' );
/*创建表
$columns = array('id' => array('type' => 'int', 'auto_increment' => 1, 'permanent' => 1 ),
'name' => array('type' => 'string', 'max' => 50),
'email' => array('type' => 'string', 'max' => 50)
);
foreach($columns as $k => $v){
echo "\$colums[$k]=";
foreach($v as $k1 => $v1){
echo "$k1:$v1 ";
}
echo "
"; } $sql->execute('create table',array( 'table' => 'table1', 'columns' => $columns)) or die('建表发生错误:'.$sql->get_last_error()); if($sql->table_exists('table1','demo')){ echo "建表成功"; }else{ echo "建表失败"; } */ /*插入纪录 $value = array(0 => array('name' => 'abc','email' => 'abc@123.com'), 1 => array('name' => '123','email' => '123@bac.com'), 2 => array('name' => 'df','email' => 'reg@bac.com'), 3 => array('name' => 'trt','email' => 'hgh@bac.com'), 4 => array('name' => 'tyty','email' => 'ytyt@bac.com') ); for($i=0;$i<5;$i++){ echo "\$value[$i]:"; foreach($value[$i] as $k => $v){ echo "[$k]=$v "; } echo "
"; } for($i=0;$i<5;$i++){ if(!$sql->execute('insert',array('table' => 'table1','values' => $value[$i] ))){ die('An error occurred, txtSQL said: '.$sql->get_last_error()); }else{ echo "插入成功
"; } } */ /*修改表数据 $value = array('name' => 'abc','email' => 'aaa@123.com'); if(!$sql->execute('update',array('table' => 'table1','where' => array('id = 1'),'values' => $value))){ die('An error occurred, txtSQL said: '.$sql->get_last_error()); }else{ echo "修改成功"; } */ /*删除表内容 $delete = array('table' => 'table1','where' => array('id > 1')); $delcount = $sql->execute('delete',$delete); echo $delcount; */ /*显示表内容*/ $select = array('table' => 'table1','orderby' => array('id','asc')/*,'where' => array('email =~ %bac%'),'limit' => array(0,9)*/); $data = $sql->execute('select',$select); echo "
";
echo "表内共有 ".$sql->table_count('table1')." 行
"; /*加入主键 $sql->execute('alter table',array('table' => 'table1','action' => 'addkey','name' => 'id','values' => array('name' => 'id'))); */ echo "最后插入ID号:".$sql->last_insert_id('table1') ; $sql->disconnect(); ?>
"; } $sql->execute('create table',array( 'table' => 'table1', 'columns' => $columns)) or die('建表发生错误:'.$sql->get_last_error()); if($sql->table_exists('table1','demo')){ echo "建表成功"; }else{ echo "建表失败"; } */ /*插入纪录 $value = array(0 => array('name' => 'abc','email' => 'abc@123.com'), 1 => array('name' => '123','email' => '123@bac.com'), 2 => array('name' => 'df','email' => 'reg@bac.com'), 3 => array('name' => 'trt','email' => 'hgh@bac.com'), 4 => array('name' => 'tyty','email' => 'ytyt@bac.com') ); for($i=0;$i<5;$i++){ echo "\$value[$i]:"; foreach($value[$i] as $k => $v){ echo "[$k]=$v "; } echo "
"; } for($i=0;$i<5;$i++){ if(!$sql->execute('insert',array('table' => 'table1','values' => $value[$i] ))){ die('An error occurred, txtSQL said: '.$sql->get_last_error()); }else{ echo "插入成功
"; } } */ /*修改表数据 $value = array('name' => 'abc','email' => 'aaa@123.com'); if(!$sql->execute('update',array('table' => 'table1','where' => array('id = 1'),'values' => $value))){ die('An error occurred, txtSQL said: '.$sql->get_last_error()); }else{ echo "修改成功"; } */ /*删除表内容 $delete = array('table' => 'table1','where' => array('id > 1')); $delcount = $sql->execute('delete',$delete); echo $delcount; */ /*显示表内容*/ $select = array('table' => 'table1','orderby' => array('id','asc')/*,'where' => array('email =~ %bac%'),'limit' => array(0,9)*/); $data = $sql->execute('select',$select); echo "
| id | name | |
|---|---|---|
| $v | "; } echo "
"; /*加入主键 $sql->execute('alter table',array('table' => 'table1','action' => 'addkey','name' => 'id','values' => array('name' => 'id'))); */ echo "最后插入ID号:".$sql->last_insert_id('table1') ; $sql->disconnect(); ?>
