[help with query joining 3 tables]

That error isn't from mysql.

[Categories sql ?.]

Assuming you only want (a) a single category per item, and (b) no subcategories, then yes.

[Mysql Query Help]

Of course there's an easier way -- use a DB wrapper to write the queries for you, and pass it a hash.

[Combine Queries]

I don't know what a "large query" is, and why it's a problem.

[Listener faileure - Mysql Cluster]

Sorry -- never worked with NDB.

[Easy question!]

First, you can change the auto-increment starting value.

 

Second, you really don't need to change UIDs -- ever.

[PHP mySQL: Select with multiple criteria load a lot of row with LIMIT 12]

Show us the EXPLAIN.

[Opinion on database search..]

There could be thousands of matching rows -- don't get data just to throw it out.

[can't create InnoDB tablespace]

Are you sure it's using that my.ini file?

[Problem with encoding russian text to mysql]

Browsers need to be told about UTF-8, as well as your import.

[database sql/php comparing two table fields]

What are you trying to do?  That looks like it should be a JOIN.

[can I setup log-bin from my.ini]

So you have 0, 1, or 2 files?

[New Moderator: PFMaBiSmAd]

Welcome to the club.

[Bizar result using SUM]

If you want all the rows _and_ an aggregate expression, you'll need a subquery.

[procedure not working]

You have dozens of queries -- find the one that causes the error, and tell us.

[Adding information into database with drop down selection]

Also, insert queries don't have where clauses.

Sounds like the OP wants an UPDATE.

[Data insert.php doesn´t go into db on-line?]

Don't post your DB credentials to the world -- and I don't know what "offline" means, anyway.

[regarding mysql query with php]

limit

 

 

select * from table where foo='bar' limit 1

Sounds like the OP is talking about fields, not records.

[Top 10 counts problems [MySQL5][PHP5.3]]

So.. yes,

 

is there a way to change the limit if 2 values are the same?

 

i dont think so, but ask anyway

Do this in 2 parts -- grab the top 10 scores, and then join back to grab anyone with said scores.

[Using Session value in query TROUBLE]

If your DB equalities are case-sensitive, that means you're working with a binary collation.

[Top 10 counts problems [MySQL5][PHP5.3]]

Then you want more than 10.

[Assigning ID's to result array]

Sorry for that I was not even sure what is was that I was looking for and finally came across a solution...thanks for your time and I aplogize for the rule violation, I was exhausted when posting that I did not mean to disregard them.

 

Thanks again.

Please post your solution.

[having multiple SQL queries dependant of what type of user logs in]

First, it gives you a line number.

 

Second, "$end" doesn't show up the code you posted.

[Please could some check create/Insert code before I cry]

Well I don't mean the whole page, I meant the relevant section, but I said the wrong thing

 

I'm wondering what the errors are.

I figured as much -- but I've seen 80kb attachements recently.

 

As mentioned above, that string isn't quoted at all.

[Restricting database records based on allowed "cities" or "counties" fields]

I mean debug turned on within the PHPMaker application. There is a checkbox to debug.

 

Art

 

You need to be able to debug code yourself -- not with someone else's tools.