php 是 name=1 和 id=相等的数字，但未指定

php were name=1 and id=equal number but Not specified

本文关键字：数字未指定 id name php | 更新日期: 2023-09-27

$sql = "SELECT title, nodeid FROM node 
 where contenttypeid='30' and starter=equal nubber(but Not a fixed number) 
 order by nodeid desc limit 10";

有人可以帮助我吗？使用"和启动器=等于 nubber(但不是固定数字("的正确方法是什么

如果只需要整数，则可以使用 (int) 代替 (float)。

$number = 12.112; //some number
$sql = "
    SELECT title, nodeid 
    FROM node 
    WHERE contenttypeid= 30 and starter = " . (float) $number . "
    ORDER BY nodeid desc 
    LIMIT 10
";