| Index
» Projects
» phpMyEdit
» Forum
» Simplest way to work with two tables? |
 |
dani
Joined: 08 Apr 2007
Posts: 1
Posted: 2007-04-08 19:45
Back to top
Reply with quote
|
Hello all
I'm a NEWBIE and so far I've been able to use PHPMyEdit to generate a couple of pages for browsing and editing tables. Very satisfied with the results.
Now I'd like to setup a TWO TABLES system, so I can browse and edit the ORDERS table (order id, customer info, date received, order status) and optionally from there jump back and forth to the matching info in the ORDER-DETAIL table (order id, product code, quantity), which may have several entries per order id.
What would be the easiest way to accomplish that, with MINIMAL hands-on code modifications?
One way I imagined is to first make two independent scripts, one for each table, and then add a URL field to jump to each other, passing the order id as a parameter inside the url. Is this possible? Is there a better way?
Thanks for any assistance.
|
workingdog
Joined: 07 Apr 2007
Posts: 10
Posted: 2007-04-11 15:33
Back to top
Reply with quote
|
There does not appear to be anyone from Platon monitoring this forum, but I'll take a stab.
The easiest way is to use the 'URL' option to link to the other "tabel".
'URL' => 'http://www.mysite.com/importthis.php?recordID=$value'
where importthis.php is the code for the other table and recordID is the field in the other table and $value is the value you are passing for the record you want to view.
Peter
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
