Script only picking up first 3 letter
<p>Im using the following script in conjunction with a autocomplete script to search my db. If I put in the letter a for example it is finding all the ID's with an a. I want to change it so by typing the letter a it will only bring up data in the id field that begings with the letter a. </p>

<pre><code>&lt;?php
require('json.php');
error_reporting(E_ALL);
mysql_connect("localhost", "root", "") or
    die("Could not connect: " . mysql_error());
mysql_select_db("timetable") or die("No such database");
$sql = sprintf("SELECT id,dsc FROM module WHERE id LIKE '%%%s%%'",
               mysql_real_escape_string($_REQUEST['term']));
$result = mysql_query($sql)
  or die(mysql_error());
$all = array();
while ($row = mysql_fetch_array($result))
    $all[] = array('value'=&gt;$row[1],'label'=&gt;$row[1]);
print json_encode($all);
?&gt;
</code></pre>
