I would like to know how I can perform a query, having a float
number. In the bank I have an item with that number (3.4), but when I apply the following code, the item with number (3.4) is not appearing.
$numerador = '3.4';
$lisagemMedias = mysql_query("SELECT * FROM 'medias' WHERE 'cat'='".$dadosGerais["cat"]."' AND 'subcat'='".$dadosGerais["id"]."' AND 'numero'='".$numerador."' ORDER BY numero");
$mediaDados = mysql_fetch_array($lisagemMedias);
$numeradorPonto = str_replace('.', '-', $mediaDados["numero"]);
echo $dadosGerais["nome"].' '.$numeradorPonto;
I would like to know how I can arrange this so that I can query both integers and (1,2,3). As numbers with float
as (1.2, 3.4).