[SOLVED] Mysql query ORDER BY

[MemphiS]

Currently my code has been working fine but for some reason today it stoped..

 

$search = mysql_query("SELECT `id` , `site_title` FROM `sites` WHERE `accepted`='1' ORDER BY `site_in` DESC LIMIT $lima, $limb");

while (mysql_fetch_row($displaySearch)){

// data,,,

 

But it isnt displaying this correctly.. :s its displaying like 3 then 25 :/

 

Thanks for responding frost110  haha

[per1os]

What is usually contained in site_in, can you also post the database structure with maybe a few fields from the DB?

[MemphiS]

Ahh thanks frost110 that twigged something for me i had `site_in` as VAR(100) change dit to an INT(100)