relating tables output

mattotto

Im currently converting paradox forms and tables to mysql and php but have hit a bit of bother.

One Table has 2 fields code, name the code fields is numbered 1-10 and the name field has a list of names.
1 fred
2 john
3 sue
etc,etc

The second table is not related to the first table but has been linked so that the Code field of the first table has been inserted into the the second table ie the code field but not name of the person ie..
2
3
2
1

The question is how do i link data from the second table to the first name ie if number 2 exists in the database then for it to say via html John has already been inserted into the database.

Thanks in advance.

Matt

[deleted]

try this:
$query="SELECT t1.code, t2.code FROM tablename1 AS t1, tablename2 AS t2 WHERE t1.code = t2.code group by t1.name
order by ..........;"
$result=@($query,$conncet_id);
if ($result)
sorry,you have done that
else
.......

this clause help you get all the records of talbename1 that has insert into tablename2(maybe you have insert into tablename not only once,so i use group by)

try this:-)

yours
shakespeare