fenway

Unless you wanted to write a stored procedure, it's probably easier to simply pull each merchant record, grab the products field, split by comma, and then insert a new record into the merchant_product table with the appropriate merchant_uid.

This doesn't seem like a small project...

Well, the inserting is more critical at this stage. Are they all separated by commas, all the time?

Check this refman page.

To automate the searching or to automate inserting all of these records?

FULLTEXT index?

The problem is you have a list of products... you need another table, merchant_products, one for each product with a merchantID link.

Forget about what you want to do with "clicking" -- that's not a DB question. You first need to import these data... do you have a separate file for each merchant? How is the link identified in the raw text file.

I have no idea what you want... perhaps you meant to post thisin the freelance section? Help with what? According to your post, there isn't even a db?

Also, the table structure, and the insert statement in question.

Echo the $sql variable for each flow path. It's much easier to collect each condtiion, then build the where clause at the end (i.e. by join-ing an array with ANDs). You still have unpaired parens.

wb... you may want to read though this thread first... no cause for alarm (anymore). edit by redbullmarky: link fixed

You're missing an open paren in nam2.

So this text file is not in the database? Or you want to produce this file?

At this stage, only with a trigger.

You can use LAST_INSERT_ID() to get back the user_uid... and use this in subsequent inserts. You can also have the relational table have unique index contraints. But "making sure" is still ambigious.

Turning column values into column names is quite difficult to do "a priori".

I don't know what you mean by "inserts the values of the relationship".

what do you mean "list of products ordered alphabetically"?

And you check the my.cnf file as well as the grants table?

Why not check if a given interval is > 24hrs?

You have the wrong password, or you're connecting from the wrong host.

You need to read the list of incompatible changes on the mysql site.

actually that's the only way. well, the most logical without subqueries.

No, seems great.