$sql = "SELECT title, nodeid FROM node
where contenttypeid='30' and starter=equal nubber(but Not a fixed number)
order by nodeid desc limit 10";
Can someone help me? What is the right way to use "and starter=equal nubber(but Not a fixed number)"
You can use (int)
instead of (float)
if you need only integer numbers.
$number = 12.112; //some number
$sql = "
SELECT title, nodeid
FROM node
WHERE contenttypeid= 30 and starter = " . (float) $number . "
ORDER BY nodeid desc
LIMIT 10
";