php - 如何获取此语句中的设备 token ？

Question

我的数据库架构在登录表中有一个 device_token 字段。我想在调用此语句时选择它。

    $result = query("SELECT IdPhoto, title, l.IdUser, username FROM photos p JOIN login l ON (l.IdUser = p.IdUser) WHERE p.IdPhoto='%d' LIMIT 1", $IdPhoto);
    //Use the result of one php function in another php file

问题是上面的语句使用了连接，我需要帮助根据当前语法从登录表中选择device_token。我的最终目标是回显 device_token 所以我想:

• 在上面的语句中选择它
• 将其存储在变量中
• 回显它

如何才能做到这一点？

更新代码

SELECT p.IdPhoto, p.title, l.IdUser, p.username, l.device_token FROM photos p JOIN login l ON (l.IdUser = p.IdUser) WHERE p.IdPhoto='%d' LIMIT 1", $IdPhoto

编辑2

以下是声明全文

function stream($IdPhoto=0) {

if ($IdPhoto==0) {

    // load the last 50 photos from the "photos" table, also join the "login" so that you can fetch the 
    // usernames of the photos' authors
    $result = query("SELECT IdPhoto, title, l.IdUser, username FROM photos p JOIN login l ON (l.IdUser = p.IdUser) ORDER BY IdPhoto DESC LIMIT 50");

} else {
    //do the same as above, but just for the photo with the given id
    $result = query("SELECT IdPhoto, title, l.IdUser, username FROM photos p JOIN login l ON (l.IdUser = p.IdUser) WHERE p.IdPhoto='%d' LIMIT 1", $IdPhoto);
    //Use the result of one php function in another php file
    //Either result or idphoto since idphoto can successfully get the photo we want etc
    //if i store id photo can i query idphoto based on idphoto like above?
    //get device token here?

    $result = mysql_query("SELECT p.IdPhoto, p.title, l.IdUser, p.username, l.device_token FROM photos p JOIN login l ON (l.IdUser = p.IdUser) WHERE p.IdPhoto=%d LIMIT 1", $IdPhoto);

while ($row=  mysql_fetch_assoc($result)){
  echo $row['device_token'];
}
}

Answer 1

您没有在查询中选择 l.device_token，因此您无法获取 device_token 的值。

SELECT p.IdPhoto, p.title, l.IdUser, p.username, l.device_token FROM photos p JOIN login l ON (l.IdUser = p.IdUser) WHERE p.IdPhoto=%d LIMIT 1", $IdPhoto

用于获取数据

$result = mysql_query("SELECT p.IdPhoto, p.title, l.IdUser, p.username, l.device_token FROM photos p JOIN login l ON (l.IdUser = p.IdUser) WHERE p.IdPhoto=%d LIMIT 1", $IdPhoto);

while ($row=  mysql_fetch_assoc($result)){
      echo $row['device_token'];
}