fenway

Yes, that's going to be quite difficult in mysql... you should consider doing this in php.

There's a CREATE TABLE LIKE command.

I would guess the latter, but I've no experience with persistent connections.

Just remember about threads...

how to show the progress bar? eg 1% to 100% ? Progress bar in mysql? I didn't realize that was possible, to make a new table and copy the data in one step.... Since I don't know that original table looks like, it's hard to guess.

Agreed... having a timestamp would be more appropriate.

Well, you're getting back * and using just a single row... but without seeing the EXPLAIN for each one, I can't really comment further.

That's code... that's not the contents of the "SQL" variable before the .open call.

This should work: $query = "INSERT INTO table (blah1, blah2, blah3, newvar) VALUES ($blah1, $blah2, $blah3, ( $_POST['newvar'] == '' ? NULL : $newvar) )"; But why aren't you quoting your strings?

Actually, you'd still need to quote the non-NULL value, so that's not it.

It depends on your INSERT statement... if you're blindly quoting this value, you're stuck. You'd need to check in in-line... could you post just the relevant code snippet (NOT the whole file)?

There's only one $query variable in your entire code block.

Echo $query.

Please echo the plaintext sql query that causes this error.

It's generally faster, because the rows of the unLIMITed query aren't sent back to the cilent.

There is a skip-networking option in the cnf file that prevents non-local host connections.

It's easy to get the first of the month, figure out what day of the week that is, add the difference to the first monday, then add 2 weeks.

OK... so run select game_id, league, max(total_points) as maxpoints from ts_table group by game_id, league and then join this result back to ts_table with all three of these columns as the on condition... then the users table should be another join.

It can't not run the 2nd query... you sure?

dbQuery() isn't php.

Not really, becauase (a) the amount of data is the same and (b) getting mysql to "flip" the rows like that would be more expensive.

Why does it matter how many rows it gives back? You can format the output however you desire.

Yes, it was an IP issue. No, you can't safely assume anything. Try issuing a "SELECT NOW()" using an actual php function, not some fancy wrapper class.

Depends with version... You either needs to use BINARY to cast the collation accordingly?

You want TIMESTAMP not to have a time? Why? Who cares? Let it be there, you can always remove it for output... why would you throw away valuable data?