fenway

So what doesn't work now? I'm lost.

I don't understand... you're already necessarily iterating through all of the results, why make mysql do more work?

Yikes -- why the redundant index? Anyway, we generally prefer pastebin to random IPs. But define "wrong".

That's what PHP is for.

Yes, it's pseudo-code -- you have to capture the errors from mysql.

Sigh.... SELECT *, (SELECT COUNT(galerija.kat_id) AS cnt FROM galerija WHERE kat_id = kategori.kat_id) as cnt FROM kategori WHERE kat_parent = 1;

I don't need an example -- you need to make an column alias called "cnt", or there won't be one.

Not to burst your bubble, but you could save a DB query by simply grabbing the teams from the 2nd query.

Sorry, my bad, cut and paste error: Try this: SELECT a.user, a.exp_attack AS Attack, @num := @num +1 AS Rank FROM `rscd_experience` a, ( SELECT @num := 0 ) b GROUP BY a.user ORDER BY a.exp_attack DESC

Well, there are some excellent resources in the "sticky" if you're looking for a place to start.

I don't see a column alias ANYWHERE.

Your dates WILL be a problem -- use a proper DATE column type, and use DATE_FORMAT() to get it displayed how you'd prefer -- you'll thank me later. But I digress.... you're using ON DUPLICATE KEY UPDATE incorrectly. if you use VALUES(), you need to refer to the column name, not the value.

And if you only want 3, use LIMIT.

FULLTEXT will return nonsense unless 50% of the rows have matches.

Unless there is a duplicate key, use update -- impossible to tell since we see nothing of the actual database.

Or you can set the variable as part of the query directly: SELECT a.user, a.exp_attack AS Attack, @num := @num +1 AS Rank FROM `rscd_experience` a, ( @num := 0 ) b GROUP BY a.user ORDER BY a.exp_attack DESC

How many rows total?

Sphinx?

Well, have you set up the primary tables?

And you're only connecting once per script?

Then dump the row.

Wrap your queries in parens.

You'll have to recompile mysql.

Really?

Combine how? I don't follow.