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

2012-04-13 Thread Jim Giner
"Rikin Parekh" 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. You solve

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 wrote: > > "Rikin Parekh" wrote in message > news:fad9d02d-2add-4a31-b118-81d56183e...@gmail.com... > Thi

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

2012-04-13 Thread Jim Giner
"Rikin Parekh" 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 errors in quest

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, "J

[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" wrote in message news:CALbBjtc3S51Wm=GfZz6_mUW08iRfTC1v=mrzhqru3hx__u2...@mail.gmail.com.