Hi,
first of all thank you for this great great tool!
i'm having this problem:
i have 2 phpMyEdit pages, one shows a table of suppliers and the other show a table of parts.
i'm using the URL option in the supplier name field definition so that clicking on a supplier will call the parts page with a GET call, so that only parts of this supplier will show. the URL definition is:
| Kód: |
| $opts['fdd']['supplierName']['URL'] = 'Parts.php?sup=$key'; |
and then in Products.php i'm using:
$sup = $_REQUEST['sup'];
to extract the GET value (which is the key of the supplier that the user clicked).
then, to filter the table i'm using:
| Kód: |
| $opts['filters'] = "SUP = $sup"; |
and in the field definition for SUP (which is the key for the supplier's table) i'm using:
| Kód: |
$opts['fdd']['SUP'] = array(
'name' => 'SUP',
'default' => $sup,
'options' => 'ACPVD',
'input' => 'R'
); |
as the manual suggest, i'm using:
| Kód: |
| $opts['cgi']['persist'] = array( 'sup' => $sup; |
to maintain the filteration on every screen.
until here everything works great and the filteration works well.
THE PROBLEM:
lets say that i'm viewing the parts of a certain supplier. if i'm deleting a single specific part, all of the parts for that supplier is deleted! i get a message, like: "5 records deleted".
why is it deleting all of the suppplier's parts and not just the one i've selected to delete??
please help me... i dont have a clue..
thank you very much :)
p.s. i don't know if it matters but the PK of the parts table consists of 2 fields: SUP (supplier ID) and PART (part ID). currently only the SUP is declared in Parts.php as the key. is this ok? is this the problem maybe?
|