MYSQL PHP - get float LIKE $float <p>I want to get rows with floats like my <code>$float</code>.</p> <p>I used this code:</p> <pre><code>$float = $_GET['float']; $requst = mysql_fetch_array(mysql_query("SELECT * FROM floats WHERE float LIKE'$float.%%%%%%%'")); </code></pre> <p>then I echoed all the rows with while:</p> <pre><code>while ($r = $request) { echo $a['float']; } </code></pre> <p>but the page doesn't show anything. (YES, I typed in the address bar <code>?float=34</code> and there are floats like <code>34.******</code> in the table.)</p> <p>What is the problem?</p> <p>(PHP version 5.2, MYSQL version 5.0)</p>