fenway

Why isn't this in the onsubmit handler?

See here -- LOCAL is a potential security hole, so it may be off by default.

Assuming "status1" can be evaluated as some sort of expression/query, you can use subqueries to extract this at once....

You definitely don't want different databases... in fact, you don't even want different tables for each customer. Just add a customerID field, and tie it to a customer table.

They're not the same... read this.

I find that once you reach a certain level of competency the questions you post are unanswerable by almost everyone. No kidding... I think I've posted maybe 10 times total, and I'm 0-for-10. Maybe we need a "superfreaks" forum ;-)

group_concat, then.

I don't think you do... explain.

I still don't see the query and it's EXPLAIN output.

From which statement?

Yes, it is an issue ... I did download the page and worked on a local copy (using IE6). And yes, I understand what you're trying to accomplish. "hidden" definitely has to be quoted, if it worked before, it was simply because e.type == 'click" evaluated for false, hence the second condition was never evaluated. I decided not to look any further at that point.

I'm guessing either e or event doesn't exist.

There is an optional SET caluse.

insert... on duplicate update...

Let's see EXPLAIN, table structure, etc... have you run analyze tables?

How?

I guess it's Barand's decision -- but if you _did_ plagerize (which you don't need to), then why pretend that you didn't? It's your homework, not ours... take our advice, but don't copy it.

What is "first"? Always by date?

Well, my guess is that it would be a hierarchy. That is, a table with fields such as user_id, board_id, topic_id, message_id, and a date/time. You simply add whatever level of detail is necesarry -- if someone selects "mark board as read", leave out topic/message... etc.

I think SMF uses a date.

No, it goes: $result=mysql_query("SELECT *, DATE_FORMAT( mytimedatefield, '%d-%m-%Y ) as pretty FROM mytable WHERE id=12")or die(mysql_error()); $row=mysql_fetch_array($result); $mytimedatefield=$row["pretty"] ; echo $mytimedatefield ;

What part of this is mysql related?

I'm very confused at to what you want. EDIT: Thread continues here.

Sounds like a job for group_concat().

That's about the same thing... 30 seconds may be a bit frequent.