fenway

My comment was extremely helpful -- I kept you from violating your database's referential integrity. Just a simple counter should do it -- if you need help with that, I'll move this to the php forum.

Further to the last post, NEVER use implicit notation -- it's just evil.

You don't want this at all. If you want to number your records, do so in PHP -- leave the DB records alone.

It's really annoying that the update_time isn't maintained on windows. So really, they're just using the same code on both platforms, instead of doing it properly. Seems like an easy patch to commit.

I mean, the CHECKSUM algorithm is really just millions of CRC32() calls, and with a large enough table, it's unlikely to collide in hash generation.

Oh, it's possible, and FIND_IN_SET() should work -- it's just not advisable.

That's not a normalized table structure.

Sorry, I don't follow -- the daemon always stay running.

Yes, but incredibly unlikely.

LOAD DATA FROM INFILE works wonders.

An EAV table might work.

Your where clause is incorrect. You need to compare each separately -- table1 to table2, and then table1 = somevalue.

Sorry, I dont' follow.

Yup -- I stumbled upon this issue a while ago -- SHOW TABLE STATUS only works for MyISAM, and even then, only on Linux. Crazy. Right now, since I'm using a DB wrapper anyway, I just automatically update a system table (with one record per table) whenever my app issues any update/insert/delete statements. Triggers is a technically a better way to handle this, but because you have to have 3 on each table, I just find it really annoying to maintain.

Use the TIMESTAMP columns, and mysql will be able to auto-convert for you.

That's because you're quoting it -- don't.

What's a slug value?

Define "not working" -- and post some raw sql commands, too.

Lucene or sphinx.

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

IF the most recent 'date_updated' is the one one you want back, then a simple order by date desc limit 1 should do the trick.

Sorry, I don't follow.

Sounds like a job for AJAX.

I'm sure there are countless tutorials on this issue -- and a similar number of threads on these forums.

Well, if you have access to both servers via php, you can SELECT from one and INSERT into the other.