While you could, perhaps, develop a way to generate a row number in a query, it should not be necessary to have...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
a row number at query time. Many users have row ID values stored in their tables to assist with joins and where clauses. Others add row numbers at display time to help users distinguish rows, but PHP should not require row numbers to properly process data.
In any case, as MySQL does not have a row number meta-column, it would be better to add a row number in your PHP code while iterating rows by way of a counter or similar method.
Dig Deeper on Linux monitoring and troubleshooting
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.