show columns

2001-09-10 Thread Steve Doig
Hi Folks - simple Q from a newbie, I'd like to return only the column names using something like show columns. I'm using PHP to display db tables in html, with the headers of the html table url'ed to sort the result by field. It's easy when you hard-code the column names into the page, but I'm g

output to csv

2001-09-04 Thread Steve Doig
Hi Folks, I'm running a batch command in win2K: cmd> mysql < batch-file > output.txt In the batch file, can I specify that values are separated by commas instead of tabs? Cheers, Steve - Before posting, please check: http:/

output to csv

2001-09-04 Thread Steve Doig
Hi Folks, I'm running a batch command in win2K: cmd> mysql < batch-file > output.txt In the batch file, can I specify that values are separated by commas instead of tabs? Cheers, Steve - Before posting, please check: http:/

mySQL DSN and PHP

2001-08-08 Thread Steve Doig
Hi Folks - new user here, My question is on the setup of my local server. I'm using Windows 2000 and IIS 5 I've just started to use php on my local IIS as a cgi .exe file. Under c:\Inetpub I have: \mySQL \php \wwwroot etc (php seems to working fine) In a php test page I'm trying to connect to t

ASP & ADO

2001-08-07 Thread Steve Doig
Hi Folks, New user here...How easy or not is it to use mySQL as a substitute when using .asp and ADO? What do I need to know in order to use mySQL with ASP and ADO? Are there 3rd party solns available? Thankyou, Steve. - Befo