View Single Post
10-01-2009, 12:34 PM
#3
.Cyanide is offline .Cyanide
Status: Senior Member
Join date: Mar 2006
Location: Stockholm,Sweden
Expertise: Web Design, Coding
Software: Phoshop CS3
 
Posts: 757
iTrader: 4 / 100%
 

.Cyanide is an unknown quantity at this point

Send a message via MSN to .Cyanide

  Old

Originally Posted by Salathe View Post
I may have missed the point, but it looks like you might be wanting to use a UNION rather than a JOIN since you just want to query multiple tables rather than join anything together.

See http://dev.mysql.com/doc/refman/5.4/en/union.html

Aside: whether you know it or not, by separating the tables by commas as you have, you're already doing an INNER JOIN on those tables.
The URL you provided didn't work =/

Aside: I am? Because when I try using that query I get an error message saying:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in D:\FTPROOT\KTD\sh09hf1763\www\webbapplikationer09\ lab4\lab.php on line 26

EDIT: I used UNION, which was ALOT easier to understand, and now it works perfectly

Reply With Quote