fenway

What do you have now, what do you want it to do?

Sounds like you're encoding HTML characters... on purpose?

Table structure is less than ideal... but let's get the script to work first. Sounds like in_array() isn't doing what you think it's doing... nor is it possibly efficient. I'd build a hash. Are you sure it's not doing a string comparison? Check the output of $row['startdate'] and what you think $i is.

Try SET @runtot:=0, then select it on the next line.

There's nothing wrong with that code... but it shouldn't work with LIKE... that's not interchangable with IN.

Why not this? SELECT t.tagid, MAX( readTimeField) FROM taglist AS t LEFT JOIN tagscans AS s ON s.tagid=t.tagid GROUP BY t.tagid

set the scrollTop = 0.

No difference... keep track of all of the ids.

Should be fine in the onclick handler... you should go through doc.forms.elements, though.

I'd hope you can't.

If you're unfamiliar, I suggest you find some examples to copy...

"javascript:" isn't valid anywhere... void(0)... perhaps.

Could be any of these scripts... how can we guess? And posting the source of those won't help either... try to narrow it down to a single function / event.

document.getElementById() to find it... then settting the display attribute to "none" should work well enough.

You can't initialize it to a variable first!

Depending on what you're actually trying to accomplish and don't want to use a maintenance script or the event scheduler in 5.1, why not just add a field called "valid_until", and set it to NOW() + INTERVAL 30 DAY every time they log in?

Interesting... LENGTH(null) = NULL, not sure why you're getting blank.

Why do you think you can solve a database issue with php?

You should be able to look up the id in the DOM and delete it.

You haven't set the user variable first.

A fancy HTML widget that displays calendar-looking things and translates this into an sql-ready date for you.

I assume there's php code that goes with this...

I'm confused as to why you're not storing the events with a pure datetime field... but even so, you should simply retrieve all the events for a given month with a single sql statement, and then iterate though the days, and check for matching ones.

Did I help?

From the manual: To be honest, I've never used FLOAT ever... so I guess I didn't know. The easy way to cheat is the use CAST( field AS decimal) -- but only in MySQL 5 -- otherwise, use yourField+0, which forces an implicit converstion back to decimal. HTH.