Word Count Query

[Dirks]

Hey everyone, I run a creative writing website that rewards people by number of words written rather than posts. I'm trying to come up with a rudimentary webpage that searches word count in a thread with a mySQL query. By searching online, my coder and I have hacked together what appears on paper to be a workable code, but it still produces a database error when the query is made. I was hoping someone here could help me out.

Here's the code: <?php
require_once('./global.php');
error_reporting(E_ALL & ~E_NOTICE & ~8192);

// define variables and set to empty values
$threadID = $threadIDErr = "";
$totalWords = 0;

if ($_SERVER["REQUEST_METHOD"] == "POST") {
if (empty($_POST["threadID"])) {
$threadIDErr = "threadID is required";
} else {
$threadID = test_input($_POST["threadID"]);
// check if threadID only contains numbers
if (!preg_match("/^[1-9]+$/",$name)) {
$threadIDErr = "Only numbers allowed";
}
}

// fetch all post from a specfic thread
$posts = $vbulletin->db->query_read("
SELECT pagetext
FROM " . TABLE_PREFIX . "post
WHERE threadid = $threadid
");

while ($post = $vbulletin->db->fetch_array($posts)) {
$totalWords = $totalWords + str_word_count($post['pagetext']);
}
}

function test_input($data) {
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data;
}
?>

<h2>Thread Word Count</h2>
<p><span class="error">* required field.</span></p>
<form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>">
Thread ID: <input type="text" name="threadID" value="<?php echo $threadID;?>">
<span class="error">* <?php echo $threadIDErr;?></span>
<br><br>
<input type="submit" name="submit" value="Submit">
</form>

<?php
echo sprintf("Thread ID %i contains %s words", $threadID, vb_number_format($totalWords));
?>

Here's the error I'm getting: Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT pagetext
FROM post
WHERE threadid =;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 3
Error Number : 1064

Any help you can provide would be great. Here's the sample: www.althanas.com/world/postcount.php

[Dave]

Variables are case sensitive.
You define it as $threadID but use it as $threadid in the query.

[Dirks]

You're my hero, Dave, that did the trick!