douzhi2017 2017-05-07 11:54
浏览 8

echo on query result buggin

I am trying to extract the $row elemts with:

$sql = "SELECT date, email, journal, section FROM selection_loggedin WHERE email = '$email' and date in (SELECT max(date) FROM (SELECT date, email FROM selection_loggedin WHERE email = '$email') as x)";
$result = $dbc->query($sql);

if ($result->num_rows > 0) { 

while($row = $result->fetch_assoc()) {
    $journal = row['journal'];
    $section = row['section'];
    print_r($row);
    //echo "'$journal'"."'$section'";
    echo "<br>".row['email']."<br>";
    echo row['date']."<br>";

And I get this:

Array ( 
      [date] => 2017-05-07 12:45:45 
      [email] => benoitkoen@gmail.com 
      [journal] => Wall Street Journal 
      [section] => Economy 
) 

Why doesn't it print the right stuff ('Wall Street Journal' and 'Economy')?

  • 写回答

1条回答 默认 最新

  • duanhuancong1969 2017-05-07 12:08
    关注
    $sql = "SELECT date, email, journal, section FROM selection_loggedin WHERE email = '$email' and date in (SELECT max(date) FROM (SELECT date, email FROM selection_loggedin WHERE email = '$email') as x)";
    $result = $dbc->query($sql);
    
    if ($result->num_rows > 0) { 
    
    while($row = $result->fetch_assoc()) {
        $journal = $row['journal'];
        $section = $row['section'];
        print_r($row);
        //echo "'$journal'"."'$section'";
        echo "<br>".$row['email']."<br>";
        echo $row['date']."<br>";
    
    评论

报告相同问题?

悬赏问题

  • ¥15 如何在炒股软件中,爬到我想看的日k线
  • ¥15 51单片机中C语言怎么做到下面类似的功能的函数(相关搜索:c语言)
  • ¥15 seatunnel 怎么配置Elasticsearch
  • ¥15 PSCAD安装问题 ERROR: Visual Studio 2013, 2015, 2017 or 2019 is not found in the system.
  • ¥15 (标签-MATLAB|关键词-多址)
  • ¥15 关于#MATLAB#的问题,如何解决?(相关搜索:信噪比,系统容量)
  • ¥500 52810做蓝牙接受端
  • ¥15 基于PLC的三轴机械手程序
  • ¥15 多址通信方式的抗噪声性能和系统容量对比
  • ¥15 winform的chart曲线生成时有凸起