fenway

Well, if you're looking for "NOT in B", you'll need a left join -- and then use a IF(), check for NULL, and update your two fields accordingly.l

Nope, that's the only reason... but it's better to simply avoid using any such keywords -- and the only way to know you've stumbled upon one if you leave the backticks out.

Perhaps, but you shouldn't anyway. Looks fine to me, just grab the value of this column back in your PHP code.

Sorry, I misunderstood your question.

MySQL will handle the type "conversion" if necessary -- the quotes prevent SQL injection attacks.

You mean your field is named 'date' -- that's going to be an issue too, since it's a reserved keyword. And you'll need DATE_FORMAT( yourColumnName, '%Y-%m-%d %H:%i:%s' ) AS uk_date

That's your ENTIRE code block -- not very helpful. And yes, no need to repeat everything! Also, there's a space in your column name... difficult to work with in the long-run. what i'd like to see if an echo of $insertSQL along with your die() statement -- and figure out which one it is.

I would agree... it's like a connection_timeout, AFAIK.

Post your INSERT statement.

No problem... but why the second if?

Well, yes, make a new table for the export... but I'd highly recommend a new field in the new database. It's going to be a disaster otherwise.

Hold on a minute... are you outputting the uk_date field in your code? Chaged to (date)? What does that means? And TIME() won't work.

There are a variety of hacks... but the best solution is to split first from last.

$result = mysql_query("SELECT *, date_format(posted_date, '%d/%m/%Y') AS uk_date FROM $db_table ORDER BY time DESC LIMIT 3",$connect);

Basically, this blog contains a regularly-updated run-down of MySQL functions, with a short description and a few hints on how to use them; RSS feed here.

What you'll need to do is "change" the rec date for <7 days using an IF() statement, and then group by this column.

Give an examplel.

Add the previous expression after your *.

First, you can issue an SQL query to find out. Second, I find it hard to believe that PHP can't spit out a different date format. But if you really need to, you can always convert the other way.

You DON'T want to do this. Why corrupt the atomicity of each field?

SELECT tier, hostname, platname FROM node AS n INNER JOIN node_platform AS np ON np.node = n.id INNER JOIN platform AS p ON p.id = np.platform Same for the fields, but I don't know which tables they're in.

SELECT tier, hostname, platname FROM node INNER JOIN node_platform ON node_platform.node = node.id INNER JOIN platform ON node_platform.platform = platform.id I like to prefix field names and alias tables.

There's a DATEDIFF() function.

Where's the DB query for this 12 hour search?

Use DATE_FORMAT() -- a mysql function.