fenway

I don't know what you mean by switched... and I still want to see CHECK TABLES.

There is an AT scheduler.

First, you don't need the ORDER BY, since GROUP BY does this implicitly. Second, one way to do this is to join these derived tables on id and work id... otherwise, you can issue a scalar subquery.

Which ones are you referring to? Some of the are set to the length of the data that will be inputting. Like postal is a drop down box where they make their choice so it only needs to be 5. Pretty much City, State, Postal, Country are all set values. I don't even know why I need country now that I think of it. Perhaps, but for the other fields, it seems rather short...

Your connection string.

Where's the join condition relating the two tables?

What do you mean? You used SELECT *...

Can you post the output for each individual query?

Define "put together".

No, it's not what I needed... I need plaintext SQL queries.

I have no idea what this means... obviously, you have to iterate through the records st!

Sorry, you have lost me there, but thnaks for taking the time in doing this for me. P.S. i cannot find how to donate I just mean there are fields sthat still appear to be in need of interpolation... but I should be able to do it regardless.

What's the final sql query?

This really isn't a mysql question, it's a WAMP question.

Sounds like it's not respecting your credentials.

Yes, a cron is likely the best way to go... otherwise, maybe the event scheduler in 5.1, but I haven't used it.

I am not sure I am following you, can you explain a little more about what you mean? Your field lengths seems very strict... why not be more lenient? That is how I want to do it, just store the image in a folder and have the DB store the URL and being to call it from their. How do I go about doing that. Is their anywhere you can point to read about this or explain this to me further? -Thanks Go about doyoing what? Uploading via PHP? You'll need to post that question in the appropriate forum.

With a LEFT JOIN, all of the non-matching record columns will be set to null... that is, if there are no replies, in your case. So you can use IFNULL() to try and pull the latest reply date/time, otherwise, use the post date. Make sense?

Well, why do you have variables you're not using?

That should be impossible... no grants, no passwords.

I guess a hint isn't enough...

You should be using IFNULL().

What are you talking about?

No order by clause? How do you know what's "next"?

Assuming you're hashing something of reasonable length, MD5() should give you something psuedo-unique enough.