MYSQL PHP - get float LIKE $float

Question

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)

You are working with only one result, put the mysql_fetch_array directly inside while in place of $request. — Peon
– Peon, Commented Jul 19, 2012 at 13:53

Shehzad Bilal · Accepted Answer · 2012-07-19 13:44:20Z

2

Try This

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

    echo $r['float'];

}

answered Jul 19, 2012 at 13:44

Shehzad Bilal

2,5132 gold badges19 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

chiwangc · Accepted Answer · 2014-12-17 05:51:57Z

2

How about select * from floats where floor(float) = $floor;?

edited Dec 17, 2014 at 5:51

chiwangc

3,58716 gold badges28 silver badges32 bronze badges

answered Jul 19, 2012 at 13:47

ethrbunny

10.5k9 gold badges77 silver badges145 bronze badges

4 Comments

Kenny Thompson Over a year ago

also, try properly concatenating your query string like so: "select * from floats where floor(float) = ".$floor

ethrbunny Over a year ago

Not if you're just matching the integer part

Kenny Thompson Over a year ago

I wasn't really saying that directly to you ethr. Your question (user107..) looks like it is asking us to query all floats that have the same whole number when you remove the decimals. This solution would find those.

Ken Keenan Over a year ago

I agree; using LIKE forces MySQL to convert the column to a string for comparison which will affect performance

Fluffeh · Accepted Answer · 2012-07-19 13:49:22Z

1

Your variable already has a decimal point in it.

"SELECT * FROM floats WHERE float LIKE '$float%'"

If your float is 34.567 your statement executes as find like '34.567.%' which isn't finding any results.

Edit: how about this then?

"SELECT * FROM floats WHERE abs(float-$float)<1;"

That will bring in anything within 1?

Having said that, although you can keep floats in mysql, it might be safer to keep them as decimals with a limited number of points after the decimal.

edited Jul 19, 2012 at 13:49

answered Jul 19, 2012 at 13:44

Fluffeh

33.6k16 gold badges69 silver badges80 bronze badges

Collectives™ on Stack Overflow

MYSQL PHP - get float LIKE $float

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related