fenway

I should probably add that WHERE `date` > CURDATE() - INTERVAL 7 DAY would likely have better index utilization. BTW, why are you storing time separately?

Better yet, actually show us the query.

BETWEEN CURDATE() - INTERVAL 7 DAY AND CURDATE()

Again, when you don't store dates properly, date operations become painful.

I'm confused... why combined the two parts just to make it hard to query?

Ah, I see. You need to add this expression to the column list: SELECT * ,CONCAT(USERS.`state`, LOCATION.stateabbreviation) AS state FROM USERS, LOCATION WHERE user_ID = colname AND USERS.`state` = LOCATION.stateabbreviation

Show us the queries you've tried and what they produce in error.

Again, you can do the same in mysql... usually the easiest way around this is to add to the where clause the current value of 'gold'.

I don't understand what you're trying to do...but you can't use a column alias that way.

why not "gold = gold + 100"?

That's a mighty racist database you're working on.

Stored procedures can do this... but why?

That's because you have a space between CONCAT and the open parenthesis.

How is this stored in the db?

That's why always debug in textareas.

As long as the depth is fixed, this approach will work just fine for most cases.

I see... why? It's always going to be equal to auto-inc value.

No, you've set it up correctly.

Unless I've misunderstood, you asking how to serve up files from mysql.

I think you've misunderstood -- there is no reading from the table in the aforementioned case. I was agreeing with the latter statement.

Well, if what you're saying is true, they're not the same... use === to test this.

Denormalization is really only required for seriously large databases with crazy load requirements.

And mysql does precisely this if you happen to have a multi-column key and specify only such columns in the select list and where clause.

Right out of the refman, too.

From where?