Re: My sql Security

2010-04-28 Thread nwood
On Wed, 2010-04-28 at 13:58 +0530, Vikram A wrote: Hi all, I have some security issues. I would like to have your suggestions/solutions. I have winserver2003 with mysql 5.1.45. We have client serve application that allows multi-login system with various people. I am getting user name,

Re: Pivot Query in

2010-04-28 Thread nwood
On Wed, 2010-04-28 at 15:24 +0530, VR Venugopal Rao wrote: I am working on Java-HTML-MS Access Backend database. Now office is removing all unlicensed softwares and they are removing microsoft applications also and hence the necessity to shift from MS Access to MySQL has arised. In MS

Re: problem reading array data

2010-04-08 Thread nwood
On Wed, 2010-04-07 at 21:37 -0700, Karthick Subramanian wrote: I need to read an array's content using a while loop and inside the loop read another array's content. Using the variables from the two arrays I need to execute a query. My problem is the inner while loop reads all records of the

Re: subquery multiple rows

2010-04-07 Thread nwood
On Wed, 2010-04-07 at 11:37 -0400, kalin m wrote: hi all... i have a bit of a problem with this: table products: -- prod | category | -| boots | winter| boots | summer | boots | spring | shoes | spring | shoes | winter|