Assuming that 'id' is the name of the MySQL column selected as the unique identifier when phpMyEditSetup.php script was run, the key will appear in the script as:
Important: There were problems reported by phpMyEdit users regarding to usage of MySQL reserved word as an unique key name (the example for this is "key" name). Thus we recommend you to use another name of unique key. Usage of "id" or "ID" names should be safe and good idea.
Example 3-3. Unique key type definition
// Type of key field (int, real, string, date, etc.) $opts['key_type'] = 'int'; |
The argument 'int' shown above indicates the column type is an integer. If the column type was a date then 'date' would appear above instead of 'int'. Other possible unique key types are 'real' or 'string'.
Important: If you are using 'real' key type and some problems with record manipulaton have occured, it is probably because your MySQL key datatype is 'float'. Comparsions with this datatype is a common problem in most computer languages (SQL including), because floating-point values are not exact values. In most cases, changing MySQL datatype from 'float' to 'double' and preserving 'real' as phpMyEdit key type should solve this problem.
For more information about this issue, read Solving Problems with No Matching Rows chapter in the MySQL manual (in version 3.23.47 it was A.5.6).