php mysql database order by

Question

$query = mysql_query("SELECT `code`, `file` FROM `files` WHERE id >= '$idimg' ORDER BY id ASC LIMIT 1, 8");
while ($result = mysql_fetch_assoc($query)) {
    if (strlen($result['title']) < 12) {
        echo '<div id="recomimage5"><div id="linkstyle"><strong><a href="http://localhost/edu/1111111111111/download.php?code='. $result['code'] . ' "><img src="files/thumbs/' . $result['code'] . '/' . $result['file'] . '" alt="' . $result['title'] . '"></a></strong></div></div>';
    }
    else {
        echo '<div id="recomimage5"><div id="linkstyle"><strong><a href="http://localhost/edu/1111111111111/download.php?code='. $result['code'] . ' "><img src="files/thumbs/' . $result['code'] . '/' . $result['file'] . '" alt="' . $result['title'] . '"></a></strong></div></div>';   
    }
}

I order eight images from a MySQL database.

Result this query:

My id images for example is '5'

Results now is: '6' '7' '8' '9' '10' '11' '12' '13' // id numbers images

But I want a result like this - for example my images in reloaded page is '5'

Result must be: '1' '2' '3' '4' '5' '6' '7' '8'     // id numbers images

Have you tried removing the first parameter to your LIMIT clause? SELECT code, file FROM files WHERE id >= '$idimg' ORDER BY id ASC LIMIT 8 — Aiias
– Aiias, Commented Mar 10, 2013 at 7:31
u have mentioned id should be greater than or equal to 5, so it's returning right, what you are getting....change your where conditions — sandeepKumar
– sandeepKumar, Commented Mar 10, 2013 at 7:36
If you're trying to return the 4 results to the left and 3 results to the right of the id, then change your WHERE clause to WHERE id >= $idimg - 4. Note: This is assuming $idimg has been sanitized. — Aiias
– Aiias, Commented Mar 10, 2013 at 7:38
Is there any error? If id is of type varchar, you may need to cast it for substraction. WHERE CAST(id AS UNSIGNED) >= CAST(id AS UNSIGNED) - 4 — Aiias
– Aiias, Commented Mar 10, 2013 at 7:53

shola · Accepted Answer · 2013-03-10 08:20:15Z

1

please refer http://dev.mysql.com/doc/refman/5.0/en/select.html chnage WHERE id >= $idimg - 4 and limit 0,8 as initial row is 0 not 1

answered Mar 10, 2013 at 8:20

shola

7044 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

php mysql database order by

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related