|
Joined: Jun 2002
Posts: 303
Enthusiast
|
Enthusiast
Joined: Jun 2002
Posts: 303 |
SELECT `w3t_links_favorites`.uid, `w3t_links_favorites`.lid, `w3t_links_links`.lid, `w3t_links_links`.title, `w3t_links_links`.url, `w3t_links_links`.description FROM WHERE ( (`w3t_links_favorites`.uid = 2) and ('w3t_links_favorites'.lid = 'w3t_links_links'.lid) )
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
What are you selecting from?
|
|
|
|
Joined: Apr 2002
Posts: 1,768
Addict
|
Addict
Joined: Apr 2002
Posts: 1,768 |
Try this: SELECT w3t_links_favorites.uid,<br />w3t_links_favorites.lid,<br />w3t_links_links.lid,<br />w3t_links_links.title,<br />w3t_links_links.url,<br />w3t_links_links.description<br />FROM w3t_links_favorites, w3t_links_links<br />WHERE w3t_links_favorites.uid = 2<br />AND w3t_links_favorites.lid = w3t_links_links.lid
|
|
|
|
Joined: Jun 2002
Posts: 303
Enthusiast
|
Enthusiast
Joined: Jun 2002
Posts: 303 |
Thanks Dave_L, that's exactly what I needed. I thought I needed the ' but obvuiously not. Just_Dave, this is for the TLD (Threads Links Directory) I've been working on, and this does the trick. I'll be finishing this up tonight at work and posting a release hopefully by the end of my graveyard shift if I don't have any distractions. Thanks guys.
|
|
|
|
Joined: Apr 2002
Posts: 1,768
Addict
|
Addict
Joined: Apr 2002
Posts: 1,768 |
The back quotes (``) for table names and column names are only needed if the names contain spaces (and possibly other special characters). You could reduce the amount of text in that query by using table aliases, which might (or might not) make it easier to read: SELECT f.uid,f.lid,l.lid,l.title,l.url,l.description <br />FROM w3t_links_favorites as f, w3t_links_links as l <br />WHERE f.uid = 2 <br />AND f.lid = l.lid
Last edited by Dave_L; 05/24/2003 4:57 PM.
|
|
|
|
Joined: Jun 2002
Posts: 303
Enthusiast
|
Enthusiast
Joined: Jun 2002
Posts: 303 |
I'll put these aliases in the next release. Thanks.
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 1,157
Joined: July 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|