douji9184 2016-07-02 21:41
浏览 127
已采纳

PHP PDO Microsoft SQL

However im trying to grab the 5 last entrys in a db and echo their first row out on the site, this is how far I've gotten:

<?php

$dsn = "sqlsrv:Server=localhost;Database=blog";
$conn = new PDO($dsn, "*****", "*********");
$conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );

$sql = "SELECT TOP 5 FROM blog_posts ORDER BY blogID DESC";

foreach ($conn->query($sql) as $row) {
echo $row[1];
} 
?>

error:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'FROM'.' in C:\inetpub\wwwroot\dev y\includes\left-menu.php:17 Stack trace: #0 C:\inetpub\wwwroot\dev y\includes\left-menu.php(17): PDO->query('SELECT TOP 5 FR...') #1 C:\inetpub\wwwroot\dev y\index.php(281): include('C:\inetpub\wwwr...') #2 {main} thrown in C:\inetpub\wwwroot\dev y\includes\left-menu.php on line 17

  • 写回答

1条回答 默认 最新

  • doubiaode0460 2016-07-02 23:14
    关注

    The row

    $sql = "SELECT TOP 5 FROM blog_posts ORDER BY blogID DESC"; 
    

    should have been

    $sql = "SELECT TOP 5 * FROM blog_posts ORDER BY blogID DESC";
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 目详情-五一模拟赛详情页
  • ¥15 有了解d3和topogram.js库的吗?有偿请教
  • ¥100 任意维数的K均值聚类
  • ¥15 stamps做sbas-insar,时序沉降图怎么画
  • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看
  • ¥15 关于#Java#的问题,如何解决?
  • ¥15 加热介质是液体,换热器壳侧导热系数和总的导热系数怎么算
  • ¥100 嵌入式系统基于PIC16F882和热敏电阻的数字温度计
  • ¥15 cmd cl 0x000007b
  • ¥20 BAPI_PR_CHANGE how to add account assignment information for service line