fenway

Double-post.

You mean keep track of the previously inserted UID?

Double-post -- actually, quadruple.

Now you're really posting about the same topic multiple times -- topic locked.

I don't believe that you actually updated them.

This is (again) one of those time where you are trying to resist having to actually issue queries the way the SQL parser executes them.

You seem to be posting a lot of topics on the same single item.

You really don't want DISTINCT * -- what do you want? My guess is you need to JOIN twice, then COALESCE.

You're going to get burned on whitespace.

SELECT dbUsers.id, dbPosts.post, dbUsers.username, dbPosts.post_id, dbPosts.karma_up, dbPosts.karma_down FROM dbPosts INNER JOIN dbUsers ON ( dbPosts.username_id = dbUsers.id ) INNER JOIN dbFriends ON ( dbFriends.friend_id = dbPosts.username_id ) LEFT JOIN dbDownvote ON ( dbDownvote .post_id = dbPosts.post_id ) WHERE dbDownvote .post_id IS NULL dbDownvote.user_id = $user AND dbFriends.user_id = $user AND dbFriends.status = 1

Disconnect can happen at any time -- none is more likely than any other. Besides, what's the problem with a partial insert in this case?

This question came a while ago -- something with a php setting that controls this behavior...but I don't recall the details. It's on the forum, somewhere.

You have it backwards -- if you choose to use their DBMS product, it's up to you, the programmer, to learn to use it correctly. Otherwise, write your own, or pick a different product.

@ebmigue : DBs, at least the relational ones, are based on set theory -- nothing else. To claim that NULL has no use is just proposterous.

You're not seriously suggesting that NULLs shouldn't be used? Or LEFT JOINs?

How do you relate vote to posts?

Huh?

What kind of "problem"?

Perhaps easier to understand for a person, but not for the parser.

Echo the string you're passing to mysql_query, followed by mysql_error output.

I suggested an alternative.

It's always the programmer -- they wrote the query -- as long as you're not cheating with optimizer hints.

Why not have a web interface?

I missed that too -- but I'm not the expert on PHP configurations.

But truthfully, using a LIMIT with an ORDER BY is not likely what you mean.