[What's the difference between the export SQL dump type used in PhpMyAdmin?]

The Percona Toolkit has something called pt-table-sync.

[Need Database for My Products]

Since he posted in MySQL I assumed it's a MySQL db.

 

Of course -- I just mean to say that there's nothing wrong with tying a MySQL DB to a NoSQL document image store -- pick the right hammer for each nail.

[Mysql query problem to create menu]

I'm not sure where your question lies -- in the DB queries,, the PHP syntax for loops, or the HTML rendering?

[and/or statements]

This is a common misunderstanding -- if you have a bowl of fruit, and you ask someone to hand you apples and oranges, you'll likely get 2 kinds of fruit.

 

But this isn't a Boolean AND -- it's a Boolean OR.

 

Asking for the fruit that is both an apple AND and orange will result in no matching fruit.

[and/or statements]

so ..how can i help you can u give me your site detail..

contact me on rgopal101@gmail.com

 

That's not how a forum works -- share your advice with everyone.

[MYSQL Problem]

Obviously, adjust to suit your column needs accordingly (untested):

SELECT * FROM files
INNER JOIN platforms ON ( files.id = platforms .file_id ) 
INNER JOIN resolutions ON ( files.id = resolutions.file_id )
WHERE resolutions.resolution = '$match_resolution' AND platforms.platform ='$match_platform';

[Need Database for My Products]

Don't store images in the database, just the filename. Store images in the filesystem.

 

To be clear, it's a bad idea to store images (file contents) in an RDBMS -- noSQL is great for this stuff (because your files are still accessible from multiple nodes, etc.).

[Issues with Table Locks]

What makes you think you're getting table locks?

[Multiple Where Clauses]

Requirement? Whose?

[comparison query]

Never figured VARCHAR would do that. Learn something new everyday.

That's how date strings are sorted, too (i.e. outside of mysql).

[comparison query]

The comparison operator will always "work" -- but the implicit casting just might not do what you'd expect.

[problem updating mysql]

I suppose you can do it that way, though I never have -- what happens in PHP if the $id's aren't contigious? Will you get a sparsely populated array?

[Issues with Table Locks]

If you're talking about InnoDB tables, it's very rare to get a table lock during normal CRUD operations -- unless you somehow issue a write statement that can't use an index.

[problem updating mysql]

Writing out N forms isn't great either -- what if they want to make multiple changes? Usually, you just need another field with the ID, and then append this ID to each field name.

[How do I filter out items? Should be simple?]

MySQL doesn't know about clicks -- what are you actually trying to achieve?

[Explain SQL]

Without a query, EXPLAIN is meaningless.

[Mysql Insert Into]

What we didn't "trust" was your explanation -- as you indicated, that's the hardest part to communicate.

[Returning the Correct ID with column groups and...]

First, make the query without joining back to the contact name table.

[Mysql Insert Into]

I simply meant that if you executed the statement, if would be plainly obvious from the syntax errors where the problems are.

[How do I change the appearance of time/date?]

And TIMESTAMPs have time zone fun built-in.

[Mysql Insert Into]

You know that SQL can tell you if your statement parses correctly -- and we can't guess -- but I can tell you that without quoting, you're going to in trouble. That's what placeholders are for.

[Inner join without optional columns]

You can use COALESCE(), too.

[Edit replace all content with a table]

Please don't mark topics solved without posting solutions.

[What's the difference between the export SQL dump type used in PhpMyAdmin?]

There are tools that will do this -- mysqldump isn't one of them -- you're talking about diff-ing records and schemata.

[Locking tables question]

Use "SHOW OPEN TABLES" within the session.