duai8153 2017-04-08 07:07
浏览 108
已采纳

MYSQL查询在PHPMyAdmin中工作,但在网站上不起作用

I am trying to move all data from one table to another and that bit on it's own works fine, the part I am having trouble with is then deleting the data from the old table. The MYSQL query I hvae put together runs fine as an SQL query on PHPMyAdmin but for some reason gives me an error about syntax at line 2 if i run it from my webpage. Please see below for the query from the website.

if($old == 'Yesterday'){
$movequery = "INSERT INTO yesthistory select * from history; 
TRUNCATE TABLE history";

if (!mysqli_query($con2, $movequery))
{
    echo("Error description: " . mysqli_error($con2));
}
  • 写回答

2条回答 默认 最新

  • dpyoh6553 2017-04-08 07:12
    关注

    It is because of you are performing 2 operations seperated by semiclon in a single query
    query should be this

    $movequery1 = "INSERT INTO yesthistory select * from history";
    $movequery2 = "TRUNCATE TABLE history";
    

    then run these queries one by one.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?