-Log in
-Register (free)


-RSS Feeds
-New MyDesk Module
-Update to Profile

• Fashion Buy Bulk Discount Designer Handbags from D
• Handbags UK Designer Style Handbag fashioned buy h
• fashion women cross necklaces stores.cheap discoun
 Forums /

Getting new records
Kevinneke | Posted 3:21am 3. February 2009 Server Time |

Hi all,

I want to get the latest records from a database, starting with a specific id.

SQLstmt = "SELECT x.* FROM (SELECT * FROM Chatlog WHERE Kamer='algemeen' ORDER BY ID DESC LIMIT 0,max(`id) - " & session("aantal_records") & ")x ORDER BY ID ASC"

But this isn't a correct statement. Can I use max in a SQLquery or is the best way to execute 2 query's (one for getting the highest record id number and one to get the latest records, by the use of the highest record id session)?

Thanks!

-Kevin.
arrowgance | Posted 7:16am 6. May 2009 Server Time |

select top 1 id from chatlog
ORDER BY ID DESC LIMIT

should be enough, unless you have a datetime stamp...or you want to get the chatlogs daily, weekly, whatever
lymanknap | Posted 2:50am 6. August 2010 Server Time |

MJQeod  <a href="http://hdoemxzmffir.com/">hdoemxzmffir</a>, [url=http://rxugsdrgztte.com/]rxugsdrgztte[/url], [link=http://nbpacwlvefuv.com/]nbpacwlvefuv[/link], http://fkjdiptnosht.com/
lymanknap | Posted 7:39pm 6. August 2010 Server Time |

AXMQkR  <a href="http://cdlwqithsssn.com/">cdlwqithsssn</a>, [url=http://ecvvqejkvwjf.com/]ecvvqejkvwjf[/url], [link=http://mfxjcausirqx.com/]mfxjcausirqx[/link], http://qbalpfwjdfbw.com/
lymanknap | Posted 10:29am 7. August 2010 Server Time |

http://www.wjcrew.org/cheapestlifeinsurance.html senior life insurance %P http://www.sundayonanism.com/cheap_auto_insurance.html cheap auto insurance tpi http://www.iphoneobserver.com/cheap-home-insurance.html cheap home insurance yati http://www.nltsecrets.com/ business insurance 856204 http://www.whatsatararrel.com/ online auto insurance 965
lymanknap | Posted 7:04am 8. August 2010 Server Time |

http://www.organizandolalucha.com/ acomplia >:(( http://www.itsalltherage.org/metoprolol.html Toprol XL %( http://www.aqueerexistence.com/ prednisone online ker http://www.candycoateddoxie.us/valium.htm valium mxqa http://www.afrilifetv.com/ propecia xurj
lymanknap | Posted 12:34am 9. August 2010 Server Time |

http://www.mega1031.org/ home insurance kjtog http://www.getlifeinsurancequotes.net/ no exam life insurance spkg http://www.carsinsurancecompanies.com/ car insurance %) http://www.free-home-insurance-quotes.net/ homeowners insurance 42154
choonchan | Posted 5:13pm 11. August 2010 Server Time |

http://www.pinkcollarclub.net/homeinsurance.html home owners insurance 7202 http://www.karenmartinezforassembly.org/business_insurance.html business insurance dxnw http://www.pinkcollarclub.net/ online auto insurance quotes ddyg http://www.roomofzen.com/businessinsurancerates.html business insurance quotes mskhyb
choonchan | Posted 7:10am 14. August 2010 Server Time |

http://www.doctorsofthecaribbean.net/ accutane ybqbew http://www.maldivestouroperators.com/ metoprolol >:-DDD http://www.charlottetownchitoryukarate.com/ prednisone bqkfi http://www.bellevuegrille.biz/prednisone.html prednisone 490316
choonchan | Posted 7:49am 17. August 2010 Server Time |

http://www.basesparalariqueza.com/ buy acomplia ystrz http://www.ganjahcultivo.com/metoprolol.html metoprolol dosage zgz http://www.ganjahcultivo.com/ambien.html ambien 2490 http://www.goldmeasures.com/ order accutane online :-[[[ http://www.ccooidl.com/ propecia %-(((
choonchan | Posted 12:15am 17. August 2010 Server Time |

http://www.skincaremedication.net/ online accutane 743163 http://www.forget-acne.com/ accutane 601397 http://www.tramadol-pills-online.com/ tramadol 500196 http://www.phentermineguide.net/ buy phentermine without a prescription :OOO http://www.phentermine-hcl.org/ phentermine pqkdn
1 2  [ Next Page >> ]
Show all replies to 'Getting new records'
To post a message to this discussion you need to be
a Haneng.com member. If you already are a member please log in
if not register as a member here (free).

| Info |
© Copyright 1997-2010 Alexander Haneng