show columns

[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 going
by the table name only, and need to work with an array of the column names
to print out the html table header.

Help appreciated; thx in advance.

Steve.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

output to csv

[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://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

output to csv

[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://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mySQL DSN and PHP

[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 the 'test' database (in
c:\inetpub\mysql\data\ ) and hardware 'table'.

$link = mysql_connect(mySQL_test, mysql_login, mysql_password)
or die (Could not connect);
print (Connected successfully);
mysql_select_db (test)
or die (Could not select database);

I get the error message:
Warning: Unknown MySQL Server Host 'mySQL_test' (2) in
C:\Inetpub\wwwroot/mySQL.php on line 9

In my ODBC sources I have a user DSN of
name: mySQLtest
driver: mySQL
mySQL host: 127.0.0.1
mySQL database name: test

I have a system DSN:
name: mySQL_test
driver: mySQL
mySQL host: 127.0.0.1
mySQL database name: test

I get the same message using mySQLtest in the php file. (names are case
sensitive?)
I run WinMySQLadmin 1.1 on startup, and it runs okay. Details are:
Server Info: 3.23.38-nt
Host Info: localhost via TCP/IP
Client Info: 3.23.36
MyODBC driver version 02.50

Everything looks fine to my untrained eye.

!--emph--Help appreciated!!--emph--


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

ASP ADO

[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.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php