First empty record in SQL

[yanng1]

Hi thanks for taking a moment, as always

I would like to insert a record in the first unused space in a MySQL table.  I am using PHP.
I really don't want to loop and look, it seems like overkill.  I think MySQL must have command to return the value of the first vacant record to a PHP script.
does anyone know of a command or operation similar to this? 

Thanks in advance,
G.R.

[Rob Pomeroy]

What do you mean by "vacant record"?  Do you mean a record with several fields, all set to NULL?  What fields are there in your database?

[Deerpark]

A basic SQL insert statement should place your data in the first available row.
But like (I think) Rob Pomeroy is hinting at this wont work if you have rows filled with null values. If you do, you should really do something about it.