|
Posted by Garry Jones on 10/19/06 22:32
I want to link two tables together to create a list. The unique value
loppnum appears in both tables. I need to look up its corresponding value
for each entry.
table1 has 2 cols
A Jag
D Cht
E Lio
P Mkn
Q Res
table2 has 2 cols
MN A
PL D
RT E
PO P
LM D
NB D
In the first table both values are unique
In the second table the first value is Unique
Now I need to display a list of data in this form
MN Jag (Displays second table data and looks up value of A in first table)
PL Cht (Displays second table data and looks up value of D in first table)
RT Lio (Displays second table data and looks up value of E in first table)
PO Mkn (Displays second table data and looks up value of P in first table)
LM Cht (Displays second table data and looks up value of D in first table)
NB Cht (Displays second table data and looks up value of D in first table)
I have made a start
$upgcollect='SELECT * FROM table1 ORDER BY scfmfor';
$upg1=mysql_query($upgcollect);
$ml_collect='SELECT * FROM table2 ORDER BY loppnmn';
$upg2=mysql_query($ml_collect);
That gives me two variables with complete table data.
The rest of this is beyond me at the moment.
Can someone please point me in the right direction.
Garry Jones
Sweden
Navigation:
[Reply to this message]
|