Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
ameque
Forum Newbie
Posts: 8 Joined: Wed Jun 13, 2007 8:18 am
Post
by ameque » Wed Sep 19, 2007 11:11 am
I have two tables that are not related. I need to develop a single navigation system in PHP on a query run on both tables. The first table has six (6) fields and the second has four (4) fields. All fields are relevant to the search. I have tried the JOIN but didn't work. Any help?
Last edited by
ameque on Wed Sep 19, 2007 2:20 pm, edited 2 times in total.
feyd
Neighborhood Spidermoddy
Posts: 31559 Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA
Post
by feyd » Wed Sep 19, 2007 11:15 am
More information? A question? Thoughts on how you want to complete this?
JayBird
Admin
Posts: 4524 Joined: Wed Aug 13, 2003 7:02 am
Location: York, UK
Contact:
Post
by JayBird » Wed Sep 19, 2007 11:15 am
Last edited by
JayBird on Wed Sep 19, 2007 11:27 am, edited 1 time in total.
feyd
Neighborhood Spidermoddy
Posts: 31559 Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA
Post
by feyd » Wed Sep 19, 2007 11:17 am
The tables aren't related; joining them would probably be wasteful.
JayBird
Admin
Posts: 4524 Joined: Wed Aug 13, 2003 7:02 am
Location: York, UK
Contact:
Post
by JayBird » Wed Sep 19, 2007 11:28 am
feyd wrote: ...joining them would probably be wasteful.
Just like the initial post