agree Posted April 11, 2007 Report Share Posted April 11, 2007 Kā dabūt jaunāko ierakstu tabulā kura `blabla` lauks =`xxx`? Respektīvi svaigako ierakstu kura kāda lauka vērtība atbilst norādītajam! Link to comment Share on other sites More sharing options...
andrisp Posted April 11, 2007 Report Share Posted April 11, 2007 Nezinu, vai pareizi sapratu, bet: SELECT * FROM `tabula` WHERE `blabla` = 'xxx' ORDER BY `datums` ASC LIMIT 1 Vai arī DESC. Es nekad neatceros kā :). Link to comment Share on other sites More sharing options...
rpr Posted April 11, 2007 Report Share Posted April 11, 2007 desc no lielaakaa uz mazaako, asc no mazaakaa uz lielaako. shajaa gadijumaa jaunaakais noziimee no lielaakaa (ar lielaako laiku) uz mazaako. Link to comment Share on other sites More sharing options...
Recommended Posts