fenway

You're missing a JOIN condition -- need to see the tables.

If you're trying to UPDATE data, then use UPDATE, not INSERT. Otherwise, the first thing that jumps to mind that that you're checking for the query being successfully executed, not returned.

500k rows isn't a problem

I'd strongly suggest using the file system -- you can dodge your system permissions with other cron jobs and file renames.

What/

Then show us the output of mysql_error().

Also, with setInterval, if the interval is really short, you can end up calling the function while the previous function call is still executing,.

Why wouldn't all developers use a site like this as a valuable resource? Between the staff and the gurus, people have access to help from the most senior of developers literally from around the world -- for free.

That's pure gold.

Stop using theta syntax (comma) and use JOINs.

I highly doubt that the webhost is to blame -- or that the database is corrupt.

Don't use "LIKE" when you mean "=" -- that's just confusing. A valid can't be "1" and "23" at the same time -- that's why AND doesn't make any sense. OR will give you either -- hence you're getting both. If you want to find items that have 2 rows -- once with termId 1 and a second time with term_id 23 -- you'll need to join twice.

Formatted data is always better -- xls is preferable -- LOAD DATA INFILE is your firend.

Yes, JOINs really work.

You'd left join, because that way you can handle a book with no votes.

Using an alias would make that pesky COUNT() problem go away.

Then you need a self-join.

Sure -- AVG(stars).

We're not going to debug someone else's code.

This topic has been moved to HTML Help. http://www.phpfreaks.com/forums/index.php?topic=348542.0

You've been told to use LIKE instead of =. REGEXP might work, too.

Show us the output you want vs the output you have.

Of course it only displays "1" -- that's boolean truth. You need to get the value for that expression -- with mysql_result() or by giving it an alias and using fetch_assoc().

As an example -- try to count the number of features. Try to insert one after the 3rd existing feature. To to hide the features with the word "waterproof". Etc.

It would in your server config.