fenway

No, not really... but I see 3 selects than can be done with a single join.

Did you in fact solve it? If so, post the solution, or I'll look into it.

I believe it's a .err file in the mysql directory.

How about here? http://www.phpfreaks.com/tutorials

Why not just use the REPLACE option?

You can format the string on your own.

Is the table UTF8?

Then you haven't dug deep enough -- there are plenty of resources and tutorials around; some of this site, too.

DECIMAL CAST-ing is only from 5+.

Understood -- well, first you need to determine which fields have been filled out, and then build your query -- not the other way 'round.

It's not for me to be "happy" -- the purpose of these forums is to SHARE problems & solutions. Give & take. Capiche?

If you're talking about getting values from an html form, you're asking in the wrong place.

Shouldn't you ask your host?

Now i'm confused... what are you trying to order by?

Don't mark "solved" unless you post the solution!!!

This doesn't do anything to the actual column type -- you know that, right?

Check mysql_error(), and the number of rows returned.

Yes, but NEVER use comma.

Last warning.

COUNT() return a single value, not a single row -- try this: SELECT c.pcatid,c.pcatname, p.cnt FROM parent_cats AS c INNER JOIN ( SELECT parents_id, COUNT(*) AS cnt FROM product GROUP BY parents_id ) AS p ON ( p.parents_id = c.pcatid )

If you actually read the posting guidelines for this forum, you'd see that we request your table structure AND the EXPLAIN output, which would have told us right away what the problem was.

Sphinx is much better.

Definitely not a numeric column type, that's for certain.

I thought I asked for that...

Yes, timestamps are evil.