fenway

Did you set the delimiter first?

Yeah, no kidding.

Yes, but it will be very slow.

Why is your query failing? Check mysql_error()

No problem... but don't double-post next time.

Just one or all the time?

Sounds like you're trying to build crystal reports.

I'm sorry, I don't follow... show the current input and desired output.

Are you serious??? How do you intend to work with such a query at all?

I don't see line numbers... show only the relevant portions.

Is this not the same as this?

The comma operator is a bad choice... ALWAYS use proper JOIN syntax instead. And you don't need the backticks: SELECT g.groupid,g.gname,g.gaddress,g.gcity FROM banner AS b INNER JOIN contact AS g USING ( groupid ) WHERE b.banner = '1'

But then you'll get a random ID & price.

What do you have so far? Listing "all" usually isn't te problem.

And it's still not working?

Um... why not just post the solution?

File? No idea... wherever that query is being generated.

Oh, it's definitely not going to easier to "fake" a DATE.

I would suggest you provide *a lot* more information. All we know is that it doesn't work.

Sounds like someone upgraded to version 5 of mysql without telling you. JOIN and comma precedence changed -- you can't mix them anymore. Use this: select count(p.products_id) as total from products p on inner join products_to_categories p2c on ( p.products_id = p2c.products_id ) inner join products_description pd on (pd.products_id = p2c.products_id ) left join manufacturers m on ( p.manufacturers_id = m.manufacturers_id ) left join specials s on ( p.products_id = s.products_id ) where p.products_status = '1' and pd.language_id = '1' and p2c.categories_id = '58' Though you many need to switch LEFT and INNER depending on your needs.

That's now a php issue... but just keep dividing through.

Sphinx is one option....

Well, you don't *need* mysql to convert it back from seconds to "time" -- you can do that quite easily yourself.

Yeah, I can't make any sense of that. Post the table definitions from SHOW CREATE TABLE.

That's unfortunate