fenway

Preferably something with syntax highlighting at the very least, function lists, code folding, etc.

Well, it's less than optimal, but it if works, go with it temporarily

I don't understand.

ENUM? What are you thinking? What do you mean "added to all rows"?

Use this as your query: "select t.teamname, t.mail from ".$prefix."_teams as t inner join ".$prefix."_userteams as u on ( u.team_id = t.team_id ) where uid='$cookie[0]'"

Why would you store the totals like that? And if you really wanted to, you'd need to run proper subqueries.

Because you then need to move you where clause to the on clause.

Thanks... much appreciated.

I just gave you the query....

Both of those code snippets assume that the part of the where clause you're building doesn't have ORs in it... and definitely use the array method.

Um, there's no IS NULL there.

Or "= ROUND( 0.85 * pricecolumn, 2 )"

If Home is a string literal, quote it.

Then use aschk's code, switch to a LEFT JOIN and add "i.item_id IS NULL" to the where clause.

You want the team name? select t.teamname from teams as t inner join userteams as u on ( u.team_id = t.team_id ) where uid=<the-uid-you-want>

You can't select sum() like that.

Well yes, you should be getting both name and id... you simply need to order your result set appropriately.

Why not use MySQL's DATE_FORMAT() function?

You sure you selected the correct DB?

You can't have FROM twice! Drop the first one.

Well, do you get into that isset() if statement? Did you echo the query string?

Then you could simply self-join 4 times... that's what I tend to do.

Then you need to store this info as a hierarchy... the way you've done it, with a "parentID", you can't write a query that will return a "unlimited" subcategory list -- you need to know the depth in advance, which is impossible. The adjacency list model might work.

You really want DECIMAL, not DOUBLE.

You still need indexes.