fenway

And what's the problem?

Yes, there's a sticky in the config child board... moving it there.

It would be possible if you used a list adjacency model instead of a hierarchy.

You're talking about a bunch of different things here... escape_string() doesn't do anything of the sort.

Why do you think you need so many?

You might want to consider naming your trigger with a prefix that tell you when they are triggered (like "AU_" for after update).

Sadly, I have even more basic knowledge... I could tell you how to do it in Perl ;-) Basically, just get back all of the rows "as-is", then build a hash of ( id, date, times ).

or BETWEEN event_date - INTERVAL 1 MONTH AND event_date + INTERVAL 1 MONTH But of course you'll need to start for the beginning of the month, so you might want to use extract the YEARMONTH.

I don't undrestan.

You mean like + INTERVAL 3 MONTH?

You shouldn't use date as your column name, that's a reserved keyword.... $month = $_GET["m"]; $result = mysql_query("SELECT * FROM ".TBL_NAME." WHERE MONTH(FROM_UNIXTIME( `date` ) ) = '$month' ORDER BY `date` DESC") or die("Error: " . mysql_error());

I would say that it's easier to aggregate these data into a hash and then handle it in the application... otherwise, it gets a bit ugly query-wise, though definitely possible.

Yes... don't use FLOAT/DOUBLE, it's evil.

I'm sure the intent was backticks.

You use MONTH(FROM_UNIXTIME( yourField ) )

As requested before, please echo the sql query. echo mysql_query($update,$con); and the output is 1 Sigh... not the output of the query, the query string itself -- $uue.

Don't store dates in CHAR fields... that was it.

Yikes... are you really using "SELECT *" when you just want a count?

Actually ,that's not helpful at all. The problem is that I don't know what this means:

The mysql "error logs" are unlikely to show anything to that effect, but it's worth checking anyway.

Make sure error reporting is turned in php...

I'm sorry, I still don't understand what all of this represents.

As requested before, please echo the sql query.

I don't understand.

Look at Lucene or Sphinx, 3rd party full-text search engines.