Thread: MAX() in WHERE clause

first thing you should do is rewrite the query to use JOIN syntax secondly, if you are "querying the DB for a specific client name" then you should put that into the WHERE clause Code: SELECT ... FROM trips INNER JOIN locations ON locations.id = trips.locationid INNER JOIN salesmen ON salesmen.id = trips.salesmen_id WHERE trips.client_name = 'Mr. Jones' the third step is to figure out which columns you want in the...

Hi i am having a query such as Code: SELECT * FROM #__vm_product AS prd INNER JOIN #__vmfprodsubcategory AS feat ON feat.product_id=prd.product_id INNER JOIN #__vm_product_category_xref AS cat ON cat.product_id=prd.product_id WHERE prd.product_id IN (1,5,5,6) AND cat.category_id=1 GROUP BY prd.product_id As you have seen there is a Code: WHERE prd.product_id IN (1,5,5,6) where some ids are being reffered more than 1 times. But the query...

nope becuase it'd be virtually impossible to code the import file for this. there is no way I could conceive that you would be bale to make an import process flexible enough to decide off its own bat whcih fields go where if there are fields missing in the input stream if you don't have data for the column then supply a null value, usually this is a comma followed by another comma if you are using CSV

you would, also, need a count of the days of the week. In your instance here that would be a 2, maybe another subquery and then calculate avg on your own? Dave

Hello I have just designed a database with an inheritance relationship. I have supertype as a table on its own. Each subtype would also have a table too. i need to reference the supertype with the subtype. supertype table: - id (PK) - ..other fields each subtype table: - id (PK) - ..unique sub fields Should i make subtype id a FK as well as a PK so it can reference its parent supertype? OR should i introduce an additional field that does the...

As a moderator I should point out you can (and should) be getting your answers for free like everyone else but seeing as it's Christmas I'll put your donation towards the kids presents

No. Registered users will just use the site to stream content - they won't have the facility to add their own content.

WELL MAY the table field prior be int converted to string... a new problem: When I have a text area and somebody types in without space when appeared data in html table the structure modified to fullfill the long word like typing "ffffffffffffffffffffffffffffffffffggggggggggggggg gggggggggggggggfffffffffffffffffffffffffffffgggggg ggggggggggggggggggggggggfffffffffff" well is any way from textarea text get cut in the middle so...

Thanks for the comments!

This sounds like an error in your PHP, not your database. Get any error messages?