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

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 na

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 > th

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 |