Getting full text content from Sphinx search

So I am using the PHP api and have executed a successful Query(). I basically have an array of Ids. Do I just do:

SELECT * FROM mytable WHERE primary_id IN (5, 29, 52, 23, 59, 22) ORDER BY FIELD(primary_id, 5, 29, 52, 23, 59, 22);

Or is there a better way to get the resultset in the order Sphinx rated them?

 

This is the way I have been using.

 

Can you please paste some more code?

 

I much preferred SphinxQL to the API. Accessing Sphinx using just PDO/mysqli is absolutely brilliant, and made my application more portable.