I know this is a stupid question but I am using a script that created several fields in a table (mysql). However, none of the fields are "create date" which seems so obvious. Is there a way to pull the create date of a record(s) in a database even if it's not a field in the table? I checked phpMyAdmin and couldn't find anything. All I want to do is display records based on create date. Thanks!
Not unless you recorded the data when you did it...... Next time, include a datetime field and just insert the mysql now() function to it.
There is no function that logs when a query has been made by either the mysql-server or phpmyadmin instance. You would have to do what lukeg32 said, or use the int type and store the timestamp.