Error in phpmyadmin though runs fine in php script?

If not, try removing elements from the query until it does work. Show us that query. Or show some table definitions?

PHPMyAdmin takes the liberty to slightly rewrite your queries (for example, adds the LIMIT 0,30 clause as to only show the first 30 lines). Can you enable the query-log and see which query actually gets executed on the server? If not, try removing elements from the query until it does work.

Show us that query. Or show some table definitions?

In this instance no extra code is being added as I have checked it. Let me see about the query log and see what that shows? After that I will try adding some table definitions.

– spinon Jul 30 '10 at 20:12 I removed the count subquery and it turns out that is the problem. But it seems pretty basic. – spinon Jul 30 '10 at 20:20 Ok another find is that if I remove all the labels for the columns then that works.

– spinon Jul 30 '10 at 20:24 It works not without changing a thing. I don't know what happened. It must have been a problem within mysql that was temporary.

– spinon Jul 30 '10 at 20:27.

If so, enclose them in backticks: `table name`.

2 no spaces. Personally I feel like if you have spaces in your table or column names you should be shot. Again just my opinion though.

:P – spinon Jul 30 '10 at 19:52 @spinon: I agree about the spaces. I'm just not seeing anything weird on line 1 except for the 't1', etc. Which I assume are not the real table names. – Scott Saunders Jul 30 '10 at 19:55 Table names aren't keywords are they?

– Scott Saunders Jul 30 '10 at 19:56 no table names are not keywords. They are pretty hideous table names and there is no way they could be keywords. – spinon Jul 30 '10 at 20:11.

What you should do is delete phpmyadmin and promise never to download it again. Then fire up a command-line mysql prompt, and try the same query. This will tell you whether the query is genuinely bad, or if phpmyadmin was simply trashing it for the perverted pleasure of its misguided authors.

I do agree somedays. Though phpmyadmin is great for letting me be lazy. Sometimes I don't always want to work with the command line.

Great when I want that granular control but not great when I don't want to type a lot. Which on a Friday @ 3 the latter is definitely the case. – spinon Jul 30 '10 at 22:18 this intrigues me.

What don't you like about PHPMyAdmin? – Konerak Jul 31 '10 at 10:41 I have many times read stories where people lose either data or time to phpmyadmin malfunctioning; to me this is just too much of a risk. It may be ok for readonly operations.

– MarkR Aug 1 '10 at 10:14.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.