Re: [PHP-DB] retriving values from two tables

2002-11-19 Thread Shannon Johnston
I'm not clear on what you're considering the 'main links'. You can use the linkid value to match the header in the Links table to the childid in the subLinks table. SELECT Links.header, subLinks.childid FROM Links, subLinks WHERE Links.linkid = subLinks.linkid; This should return values like th

Re: [PHP-DB] retriving values from two tables

2002-11-19 Thread 1LT John W. Holmes
> Hi all, > > I am karthik. I am using using php with mysql. i am stuck with a qury. Pls hep me out. > > i have two tables. Here is table with sample data > > Table Name : Links > > linkid header > 1 yahoo.com > 2 google.com >

[PHP-DB] retriving values from two tables

2002-11-19 Thread karthikeyan
Hi all, I am karthik. I am using using php with mysql. i am stuck with a qury. Pls hep me out. i have two tables. Here is table with sample data Table Name : Links linkid header 1 yahoo.com 2 google.com 3