<?php
include "lib.php";
$connect = dbconn();
$_POST['id'] = "test";
$query = "select max(top) from moasan_board_data id='$id' and no='$no'";
$result = mysql_query($query, $connect);
$data = mysql_fetch_array($result);
$regdate = time();
$top = $data[0]+1; // 这里 加不了 +1 怎么回事呢?
$query = "insert into moasan_board_data(id,subject,name,email,password,memo,url,regdate,top)values(
'{$_POST['id']}',
'{$_POST['subject']}',
'{$_POST['name']}',
'{$_POST['email']}',
'{$_POST['password']}',
'{$_POST['memo']}',
'{$_POST['url']}',
'{$_POST['regdate']}',
'{$_POST['top']}')";
mysql_query($query, $connect);
?><script>
location.href='board/list.php?id=<?=$id?>';
</script>
include "lib.php";
$connect = dbconn();
$_POST['id'] = "test";
$query = "select max(top) from moasan_board_data id='$id' and no='$no'";
$result = mysql_query($query, $connect);
$data = mysql_fetch_array($result);
$regdate = time();
$top = $data[0]+1; // 这里 加不了 +1 怎么回事呢?
$query = "insert into moasan_board_data(id,subject,name,email,password,memo,url,regdate,top)values(
'{$_POST['id']}',
'{$_POST['subject']}',
'{$_POST['name']}',
'{$_POST['email']}',
'{$_POST['password']}',
'{$_POST['memo']}',
'{$_POST['url']}',
'{$_POST['regdate']}',
'{$_POST['top']}')";
mysql_query($query, $connect);
?><script>
location.href='board/list.php?id=<?=$id?>';
</script>
echo $top.'<br>';$query = "insert into moasan_board_data(id,subject,name,email,password,memo,url,regdate,top)values(
'{$_POST['id']}',
'{$_POST['subject']}',
'{$_POST['name']}',
'{$_POST['email']}',
'{$_POST['password']}',
'{$_POST['memo']}',
'{$_POST['url']}',
'{$_POST['regdate']}',
'{$top}')";
echo $query ."<br>";
插入结果是什么?一看,调试就全知了
此处需要遍历取数据: $data = mysql_fetch_array($result);改为
将每条记录保存到一个数组里:
$temp=array();
while($data = mysql_fetch_array($result,MYSQL_BOTH))
{
array_push($data[0],$temp);
} 然后在SQL遍历使用这个数组即可
$result = $conn->query($sql);
if($result&&$conn->affected_rows){}