[PHP-DB] Re: Need help with SQL Query

2012-04-13 Thread Jim Giner
why don't you try it and see? (altho I suspect that using 'count' as the result field name might not work, and that having column names with spaces in them will require quotes around them.) Rikin Parekh riki...@gmail.com wrote in message

Re: [PHP-DB] Re: Need help with SQL Query

2012-04-13 Thread Rikin Parekh
This is the sample data provided to me. I need to query this data only. And column name can be without spaces. I need to know the query that will give me the result irrespective of the syntax errors in question table. Can someone please guide or help? Thanks, Rikin On Apr 13, 2012, at 9:12,

Re: [PHP-DB] Re: Need help with SQL Query

2012-04-13 Thread Jim Giner
Rikin Parekh riki...@gmail.com wrote in message news:fad9d02d-2add-4a31-b118-81d56183e...@gmail.com... This is the sample data provided to me. I need to query this data only. And column name can be without spaces. I need to know the query that will give me the result irrespective of the syntax

Re: [PHP-DB] Re: Need help with SQL Query

2012-04-13 Thread Rikin Parekh
I got the answer. My query works perfectly fine. Earlier I had problems in configuring mySQL Workbench so I could not try. Thank you guys. Rikin On Fri, Apr 13, 2012 at 10:28 AM, Jim Giner jim.gi...@albanyhandball.comwrote: Rikin Parekh riki...@gmail.com wrote in message

Re: [PHP-DB] Re: Need help with SQL Query

2012-04-13 Thread Jim Giner
Rikin Parekh rpare...@umd.edu wrote in message news:CALbBjtctPawe=qyuvqWZvG3nq_Tw7PwKoe-hhi5fkYGec=6...@mail.gmail.com... I got the answer. My query works perfectly fine. Earlier I had problems in configuring mySQL Workbench so I could not try. Thank you guys. Rikin No thanks necessary.