fenway

In fact, mysql is quite lax, and will happily match up date with date/time fields even without DATE() wrapping.

You can use: INSERT INTO yourTable( col1, col2, col3 ) SELECT c3, 'foo', c4, 'bar' FROM ..... WHERE .... As you had done earlier....

And what do you want?

No, i don't mean insert --- i saw select/update in your code.

Thanks for reading between the lines. I just get tired of having to deal with some of mysql's more annoying features -- like leaving off ONLY_FULL_GROUP_BY in the sql mode, allowing resetting of the auto-increment counter without truncate, etc.

There's a lot of junk in the server code.

You can actually just use NOW()... no need for wrapping in DATE().

BAD IDEA.

yes, you need a left join: select * from players as p left join medicalward as m on ( m.player_id = p.id ) where p.City_ID=? and m.player_id is null ORDER BY RAND() Limit 20

I suggest you copy my example, not yours ;-)

Why not use a multi-table update?

It gets even more complicated since it's also a function. It's just a bad idea to use it.

I'm assuming that all of this is happening when mysqld is shutdown... What about "isamchk -e -a -i -o"? The error 17 is really bothering me... are you running this as a privileged user?

OK... let's cover what you *can* do with the data. [As for the backup, I didn't mean a mysql dump... i meant a physical copy of the files in question, in case we destroy them in the process.] What errors/messages do you get from "force-recover"?

MAX(path)??? Don't you mean: select filename, path, max(revision) from repos group by filename, path;

No, you can't insert into multiple tables at once. But you can use LAST_INSERT_ID() (I'm sure there's an equivalent php function) to get the new photoID. You obviously know userId already.

"Show create table" will tell you what it is.

No, you need to do: ALTER TABLE yourTable CHANGE oldColName newColName <column def> But you NEED to make sure you use the exact same column defn as current exists.

It's usually the default OS temp dir -- see here

It can't auto-update a record that isn't there.

There are some ways to rename without using alter, but don't use them... bad form.

What exactly did you change? post table structure.

You can easily join the tables or use subqueries to pull those values.

Please echo $sql and post it here.

Also, why run two update queries? why not: mysql_query("UPDATE users SET on='ON',ip='$ip' WHERE username = '$username'");