MYSQL PHP - 获取浮动LIKE $浮动 [英] MYSQL PHP - get float LIKE $float

问题描述

我希望获得像我的 $ float 这样的浮动行。

我使用下面的代码：

  $ float = $ _GET ['float']; 
 
 $ requst = mysql_fetch_array（mysql_query（SELECT * FROM floats WHERE float LIKE'$ float。%%%%%%%'））; 
  

然后我用while回显所有行：

  while（$ r = $ request）{
 
 echo $ a ['float']; 
 
} 
  

但页面不显示任何内容。 （是的，我在地址栏中输入？float = 34 ，并有像 34这样的浮动。******


是什么问题？

（PHP 5.2版，MYSQL版本5.0 ）


解决方案

试试这个

  $ requst = mysql_query（SELECT * FROM floats WHERE float LIKE'$ float。%%%%%%%'）; 
 while（$ r = mysql_fetch_array（$ request））{
 
 echo $ r ['float']; 
 
} 
  




I want to get rows with floats like my $float.

I used this code:

$float = $_GET['float'];

$requst = mysql_fetch_array(mysql_query("SELECT * FROM floats WHERE float LIKE'$float.%%%%%%%'"));

then I echoed all the rows with while:

while ($r = $request) {

    echo $a['float'];

}

but the page doesn't show anything. (YES, I typed in the address bar ?float=34 and there are floats like 34.****** in the table.)

What is the problem?

(PHP version 5.2, MYSQL version 5.0)

解决方案

Try This

$requst = mysql_query("SELECT * FROM floats WHERE float LIKE'$float.%%%%%%%'");
while ($r = mysql_fetch_array($request)) {

    echo $r['float'];

}

这篇关于MYSQL PHP - 获取浮动LIKE $浮动的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！