Things to do in Cape Town, the Helderberg, and the Cape Winelands

Tag resultset

MySQL: How to Order a SQL query’s results by a given ID Sequence

I have a specific sequence of ID numbers and I want the result set retrieved when looking up more information on those records in the exact same sequence that I have it. This sequence is not your usual ascending or… Continue Reading →

How to Reuse a MySQL Result Set

To reuse an existing result set returned from a query is actually pretty simple thanks to PHP’s mysql_data_seek function and the fact that mysql_query returns a buffered result set by default.

© 2021 An Exploring South African — Powered by WordPress