fenway

That's not English.

Just so that the same expression doesn't show up multiple times, is all.

That's a cron job.

That's a php question related to entities.

Join twice.

That's because not every OS is case sensitive. But don't ever use mixed case.

Sending how? If it's just another accessible mysql server, then it's a joke.

Oh, so many things. First, where's the column list? Second, what makes you think that pic_id exists?

You could have used user variables to make that simpler to read...

That's just hard to read... so elt me know if you need more help.

That is what I suggested....

That means you need to get both first.

It's because the PK is indexed, and it knows nothing matches. But NEVER use a varchar for a pK.

If you're not disconnecting, then your DB wrapper is -- but that's buried somewhere in php, I presume.

Use: SUBSTRING(columnName,3)

Then why not simply add a second expression to the order by clause?

Then please post that particular query, and the relevant code snippet. What we "love" is not having to read through code to find the problem -- we're here to help solve known problems.

Why RIGHT JOIN? That just makes it hard to read.

Somewhere your DB wrapper specifies a timeout.

You mean how you use PHP to write to a database?

ALTER TABLE? I don't follow.

PASSWORD() is a function -- which means that $pwd already had PASSWORD() applied to it. Of course, you're never supposed to use PASSWORD() for anything. And you never need to send the password, even in hashed state, on the wire.

And again, post the solution.

This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=325839.0

Depends on how stable that formatting is. You can split by the slash, remove the first 3 characters, etc.