fenway

What's your sql statment?

I don't really work with InnoDB tables, but it's a completely different format for both data & index files, has namespaces, etc. etc. With MyISAM, as long as the tables aren't being written to, you can safely copy FRM/MYD/MYI files.

Not necessarily. The lazy way is simply to have a modified datetime field for ech record, retrieve it on page load, and then compare it before you write the data back.

MyISAM tables?

Since when?

Where's the query log? Should be easy to find some of the pertinent update statements with string literals?

Strange.

There are stickies, too.

There are two issues here... the database transaction, and the application level of allowing editing of the same "record".

Shouldn't be... post the EXPLAIN.

What version of mysql?

That's not EXPLAIN output. And "refreshing 5 times" isn't an sql issue... unless your query takes forever to run.... hence the request for EXPLAIN output. Now it's your turn to be helpful.

I don't see you using these functions: function createCookie(name,value,days) { if (days) { var date = new Date(); date.setTime(date.getTime()+(days*24*60*60*1000)); var expires = "; expires="+date.toGMTString(); } else var expires = ""; document.cookie = name+"="+value+expires+"; path=/"; } function readCookie(name) { var nameEQ = name + "="; var ca = document.cookie.split(';'); for(var i=0;i < ca.length;i++) { var c = ca[i]; while (c.charAt(0)==' ') c = c.substring(1,c.length); if (c.indexOf(nameEQ) == 0) return c.substring(nameEQ.length,c.length); } return null; } function eraseCookie(name) { createCookie(name,"",-1); }

You don't have any [L] there.

This is mainly because distinct is a filesort operation which group by has the chance to use an index or some temporary filesorting on smaller sets along the way.

this refman page has some simple examples on how to get the age... should be trivial to use BETWEEN based on this value.

I mean echo the $sql variable inside the loop. PLEASE start using code blocks... I'm getting tired to re-formatting everything. Change your "saving" block to this: if ($orderId) { // save order items for ($i = 0; $i < $numItem; $i++) { $sql = "INSERT INTO tbl_order_item(od_id, pd_id, od_qty) VALUES ($orderId, {$cartContent[$i]['pd_id']}, {$cartContent[$i]['ct_qty']})"; echo $sql; $result = dbQuery($sql); } Then post the output from the echo call.

It's possible to adapt mysql birthday code to handle a range... let me know if you care, I can dig it up

UTF-8 can store anything... just make sure that your editor / server-side script / etc. know about this too.

You can always have a summary table to keep count.

Just like exists vs defined in perl.. interesting.

Much easier explained by a php/ajax tutorial... but since I'm not versed in this, I can't suggest one. Must be one on the php help / ajax help board stickies?

Sure he was... but his solution still wasn't a wrapper.

I mean echo the $sql variable inside the loop.

That's a PHP issue... with POST and isset().