Displaying 1 result from an estimated 1 matches for "_bookmark".
Did you mean:
bookmark
2006 Jan 23
2
del.icio.us-like output
...elete=76b171f78b8e4eb0851ae24a1994f105&jump=no>
There are several things going on there that make it
hard/impossible/inefficient to do it one query. I''m soliciting tips on how
to do this most efficiently.
For me, the data is in 4 tables.
Bookmarks (id, bookmark)
Tags (id, tag)
Tags_Bookmarks (tag_id, bookmark_id, user_id)
Users (id, username)
I have a query that can get me most of the info I need, but not necessarily
in the format I need it in.
sql = "SELECT jt.tag_id, b.id bid, t.tag, b.bookmark, jt.created_on
FROM tags_bookmarks jt
LEFT JOIN tags...