fenway

I have to disagree ONLY because if you have the raw date format in the database, it's alot easier to figure out what kind of data you need by using php functions(alot friendlier and not as hard to figure out) and then search the db accordingly. But both ways work. It's driving stick vs driving manual. I disagree -- you're potentially doing a lot more work outside the DB, which is likely very low.

Actually, the most crucial thing is determining if this is a mysql problem or not.

Exactly.

You should be expecting an sql statement... Then you don't have error reporting turned on.

You'd have to join that query back to your records table, and then find the corresponding record, and then join that one to the other tables.

Sounds like an enconding issue....

Yes, but it makes no sense without reference to this thread....

What's wrong is that I don't see the mysql statement that you're sending to the server that's causing the error....

It's likely blank because there are no matching rows and you used a left join.

This is a PHP issue.... don't double-post.

You need to run this: $result = mysql_query("SELECT * FROM Assignment"); while($row = mysql_fetch_array($result)) { echo" <tr> <td>$nbsp;</td> <td>$row['Assignment']</td> <td>$row['Title']</td> <td>$row['SchoolID']</td> <td>$row['Description']</td> </tr> "; }

That's the error, not the statement....

I'm not sure what you mean... just create it from phpmyadmin.

You have to check in advance.

Did you recently restore from a backup?

No... like "ON ( `ID` = `EmpID` AND `emp_name` = `EmpName` )"

Echo the sql statement that fails.

Shouldn't matter... how are you exporting?

Like I said, echo the $sql, make sure it's correct, and check for any mysql errors.

I'm not sure what you mean...

I don't see any proper keys there.... Oops, tired... try this instead: select r.recordID, max(r.date) from records AS r inner join ( select challengeID, min(score) AS minScore from records group by challengeID ) as t2 on ( t2.challengeID = r.challengeID AND t2.minScore = r.score ) group by r. challengeID

Not hard per se, you simply need to move through the field, and increment a counter every time you see an instance of your keyword.

No prob, sorry for the confusion.

CONVERT_TZ() is the function, I think.

Sorry, I meant to use the second method, not the first... typo.