How to limit a conditioned result query in PHP/MYSQL?

Question

I need to limit the first six results from a query with a condition WHERE.

I would like to do something like that:

mysql_query("CREATE VIEW [test] AS SELECT * FROM table WHERE status=1");

$sel = "SELECT * FROM [test] LIMIT 0,6";

$result = mysql_query($sel);

while($r=mysql_fetch_array($result)){ 
    echo "".$r['id']."<br>";
}

How can I do it? Thanks!

Have you tried adding the WHERE clause? There's nothing special, just put it before the LIMIT — jprofitt
– jprofitt, Commented Feb 10, 2012 at 2:51
I don't understand. What's the problem with $sel = "SELECT * FROM [test] WHERE condition = value LIMIT 0,6"; ???? — Mike B
– Mike B, Commented Feb 10, 2012 at 2:53
Simple as that. Actually I was having a problem in other part of my code. That's why the fetch_array wasn't working. Thank you all. — Rafael Fonseca
– Rafael Fonseca, Commented Feb 10, 2012 at 3:42

earthmeLon · Accepted Answer · 2012-02-10 03:07:14Z

1

$query = "SELECT * FROM `table` WHERE this = 'that' ";
$limit = "ORDER BY index LIMIT 6 ";
$result = mysql_query($query.$limit);

You need to limit your ordered conditional selection. (You probably don't have to order this)

answered Feb 10, 2012 at 3:07

earthmeLon

6381 gold badge8 silver badges20 bronze badges

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

1 Comment

Rafael Fonseca Over a year ago

Simple as that. Actually I was having a problem in other part of my code. That's why the fetch_array wasn't working. Thank you all.

Collectives™ on Stack Overflow

How to limit a conditioned result query in PHP/MYSQL?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related