Forums Scripts & Popups Accessing mysql using mIRCs COM features

If you just want to pull the last record added (assuming your ID field is an auto_increment), then you can do it two ways:

var %SQL = SELECT * FROM news;

and then use the $com(RecordsetObject, MoveLast, 1) method and retrieve the fields you want with Recordset.Collect method like you did before. Or, you should be able to use the SQL statement you posted...

var %SQL = SELECT * FROM news ORDER BY id DESC LIMIT 1;

and then use the Collect method as normal.