write MySQL table data to a file

Report · Sep 21, 2006

I have a MySQL database table with five fields that I need to write to a
file as a comma separated list. This needs to be triggered by a mouse click
that makes the file available for download. The file "events.cvs" will be
used to import data to MS Outlook, Scheduler.

Jeff

Report · Sep 25, 2006

You need to tell us with server langauage you are using to access the
database before anyone can help you..

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"Jeff" <jeffs@NoSpamLamSam.com> wrote in message
news:eeupuu$84$1@forums.macromedia.com...
>I have a MySQL database table with five fields that I need to write to a
>file as a comma separated list. This needs to be triggered by a mouse click
>that makes the file available for download. The file "events.cvs" will be
>used to import data to MS Outlook, Scheduler.
>
> Jeff
>

Report · Sep 26, 2006

Paul Whitham AdobeCommunityExpert wrote:
> You need to tell us with server langauage you are using to access the
> database before anyone can help you..

Jeff posted another question titled "MySQL query question" dealing with
this same issue on the 22nd, which I answered. I've not heard back, but
I hope it has solved Jeff's problem.

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/

Report · Sep 28, 2006

Sorry for not getting back to you David, your corrections to the SQL syntax
were perfect.
Unfortunately, the issues with user permission persists. I talked to tec
support at the hosting co but they were little help. Just asked if the DB
user permissions were set to "all" and if the permission of the target file
was set to at least 755.
I had already given "all" permissions to the user and the target file
permission is 777. This was the last I've heard from them for the past 3
days. Needless to say the "#1045 - Access denied for user:
'wmevents@localhost' (Using password: YES)"
has not been solved.

Jeff

"David Powers" <david@example.com> wrote in message
news:efavk1$1k8$1@forums.macromedia.com...
> Paul Whitham AdobeCommunityExpert wrote:
>> You need to tell us with server langauage you are using to access the
>> database before anyone can help you..
>
> Jeff posted another question titled "MySQL query question" dealing with
> this same issue on the 22nd, which I answered. I've not heard back, but I
> hope it has solved Jeff's problem.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

Report · Sep 28, 2006

Jeff wrote:
> Needless to say the "#1045 - Access denied for user:
> 'wmevents@localhost' (Using password: YES)"
> has not been solved.

That means that the username and/or the password is incorrect.

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/

Report · Sep 29, 2006

> That means that the username and/or the password is incorrect.

That is also something I checked. My connection script
"connections/events.php" is valid. I have no problem connecting to the MySQL
data base and doing any of the other things I want to do with the data.

I want to thank you again for all of your help, including your book "PHP for
Dreamweaver 8", I've found it very useful.

Jeff

"David Powers" <david@example.com> wrote in message
news:efhim2$m54$2@forums.macromedia.com...
> Jeff wrote:
>> Needless to say the "#1045 - Access denied for user: 'wmevents@localhost'
>> (Using password: YES)"
>> has not been solved.
>
> That means that the username and/or the password is incorrect.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

Report · Sep 29, 2006

> That means that the username and/or the password is incorrect.

That is also something I checked. My connection script
"connections/events.php" is valid. I have no problem connecting to the MySQL
data base and doing any of the other things I want to do with the data.

I want to thank you again for all of your help, including your book "PHP for
Dreamweaver 8", I've found it very useful.

Jeff

"David Powers" <david@example.com> wrote in message
news:efhim2$m54$2@forums.macromedia.com...
> Jeff wrote:
>> Needless to say the "#1045 - Access denied for user: 'wmevents@localhost'
>> (Using password: YES)"
>> has not been solved.
>
> That means that the username and/or the password is incorrect.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

Report · Sep 29, 2006

> That means that the username and/or the password is incorrect.

That is also something I checked. My connection script
"connections/events.php" is valid. I have no problem connecting to the MySQL
data base and doing any of the other things I want to do with the data.

I want to thank you again for all of your help, including your book "PHP for
Dreamweaver 8", I've found it very useful.

Jeff

"David Powers" <david@example.com> wrote in message
news:efhim2$m54$2@forums.macromedia.com...
> Jeff wrote:
>> Needless to say the "#1045 - Access denied for user: 'wmevents@localhost'
>> (Using password: YES)"
>> has not been solved.
>
> That means that the username and/or the password is incorrect.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

Report · Sep 29, 2006

> That means that the username and/or the password is incorrect.

That is also something I checked. My connection script
"connections/events.php" is valid. I have no problem connecting to the MySQL
data base and doing any of the other things I want to do with the data.

I want to thank you again for all of your help, including your book "PHP for
Dreamweaver 8", I've found it very useful.

Jeff

"David Powers" <david@example.com> wrote in message
news:efhim2$m54$2@forums.macromedia.com...
> Jeff wrote:
>> Needless to say the "#1045 - Access denied for user: 'wmevents@localhost'
>> (Using password: YES)"
>> has not been solved.
>
> That means that the username and/or the password is incorrect.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

Report · Sep 29, 2006

> That means that the username and/or the password is incorrect.

That is also something I checked. My connection script
"connections/events.php" is valid. I have no problem connecting to the MySQL
data base and doing any of the other things I want to do with the data.

I want to thank you again for all of your help, including your book "PHP for
Dreamweaver 8", I've found it very useful.

Jeff

"David Powers" <david@example.com> wrote in message
news:efhim2$m54$2@forums.macromedia.com...
> Jeff wrote:
>> Needless to say the "#1045 - Access denied for user: 'wmevents@localhost'
>> (Using password: YES)"
>> has not been solved.
>
> That means that the username and/or the password is incorrect.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

Report · Sep 29, 2006

> That means that the username and/or the password is incorrect.

That is also something I checked. My connection script
"connections/events.php" is valid. I have no problem connecting to the MySQL
data base and doing any of the other things I want to do with the data.

I want to thank you again for all of your help, including your book "PHP for
Dreamweaver 8", I've found it very useful.

Jeff

"David Powers" <david@example.com> wrote in message
news:efhim2$m54$2@forums.macromedia.com...
> Jeff wrote:
>> Needless to say the "#1045 - Access denied for user: 'wmevents@localhost'
>> (Using password: YES)"
>> has not been solved.
>
> That means that the username and/or the password is incorrect.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

Report · Sep 29, 2006

> That means that the username and/or the password is incorrect.

That is also something I checked. My connection script
"connections/events.php" is valid. I have no problem connecting to the MySQL
data base and doing any of the other things I want to do with the data.

I want to thank you again for all of your help, including your book "PHP for
Dreamweaver 8", I've found it very useful.

Jeff

"David Powers" <david@example.com> wrote in message
news:efhim2$m54$2@forums.macromedia.com...
> Jeff wrote:
>> Needless to say the "#1045 - Access denied for user: 'wmevents@localhost'
>> (Using password: YES)"
>> has not been solved.
>
> That means that the username and/or the password is incorrect.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

Report · Sep 30, 2006

> That means that the username and/or the password is incorrect.

That is also something I checked. My connection script
"connections/events.php" is valid. I have no problem connecting to the MySQL
data base and doing any of the other things I want to do with the data.

I want to thank you again for all of your help, including your book "PHP for
Dreamweaver 8", I've found it very useful.

Jeff

"David Powers" <david@example.com> wrote in message
news:efhim2$m54$2@forums.macromedia.com...
> Jeff wrote:
>> Needless to say the "#1045 - Access denied for user: 'wmevents@localhost'
>> (Using password: YES)"
>> has not been solved.
>
> That means that the username and/or the password is incorrect.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

Report · Sep 30, 2006

> That means that the username and/or the password is incorrect.

That is also something I checked. My connection script
"connections/events.php" is valid. I have no problem connecting to the MySQL
data base and doing any of the other things I want to do with the data.

I want to thank you again for all of your help, including your book "PHP for
Dreamweaver 8", I've found it very useful.

Jeff

"David Powers" <david@example.com> wrote in message
news:efhim2$m54$2@forums.macromedia.com...
> Jeff wrote:
>> Needless to say the "#1045 - Access denied for user: 'wmevents@localhost'
>> (Using password: YES)"
>> has not been solved.
>
> That means that the username and/or the password is incorrect.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

Report · Sep 30, 2006

> That means that the username and/or the password is incorrect.

That is also something I checked. My connection script
"connections/events.php" is valid. I have no problem connecting to the MySQL
data base and doing any of the other things I want to do with the data.

I want to thank you again for all of your help, including your book "PHP for
Dreamweaver 8", I've found it very useful.

Jeff

"David Powers" <david@example.com> wrote in message
news:efhim2$m54$2@forums.macromedia.com...
> Jeff wrote:
>> Needless to say the "#1045 - Access denied for user: 'wmevents@localhost'
>> (Using password: YES)"
>> has not been solved.
>
> That means that the username and/or the password is incorrect.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

Report · Sep 30, 2006

> That means that the username and/or the password is incorrect.

That is also something I checked. My connection script
"connections/events.php" is valid. I have no problem connecting to the MySQL
data base and doing any of the other things I want to do with the data.

I want to thank you again for all of your help, including your book "PHP for
Dreamweaver 8", I've found it very useful.

Jeff

"David Powers" <david@example.com> wrote in message
news:efhim2$m54$2@forums.macromedia.com...
> Jeff wrote:
>> Needless to say the "#1045 - Access denied for user: 'wmevents@localhost'
>> (Using password: YES)"
>> has not been solved.
>
> That means that the username and/or the password is incorrect.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

Report · Sep 30, 2006

> That means that the username and/or the password is incorrect.

That is also something I checked. My connection script
"connections/events.php" is valid. I have no problem connecting to the MySQL
data base and doing any of the other things I want to do with the data.

I want to thank you again for all of your help, including your book "PHP for
Dreamweaver 8", I've found it very useful.

Jeff

"David Powers" <david@example.com> wrote in message
news:efhim2$m54$2@forums.macromedia.com...
> Jeff wrote:
>> Needless to say the "#1045 - Access denied for user: 'wmevents@localhost'
>> (Using password: YES)"
>> has not been solved.
>
> That means that the username and/or the password is incorrect.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

Report · Sep 30, 2006

> That means that the username and/or the password is incorrect.

That is also something I checked. My connection script
"connections/events.php" is valid. I have no problem connecting to the MySQL
data base and doing any of the other things I want to do with the data.

I want to thank you again for all of your help, including your book "PHP for
Dreamweaver 8", I've found it very useful.

Jeff

"David Powers" <david@example.com> wrote in message
news:efhim2$m54$2@forums.macromedia.com...
> Jeff wrote:
>> Needless to say the "#1045 - Access denied for user: 'wmevents@localhost'
>> (Using password: YES)"
>> has not been solved.
>
> That means that the username and/or the password is incorrect.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

Report · Sep 30, 2006

> That means that the username and/or the password is incorrect.

That is also something I checked. My connection script
"connections/events.php" is valid. I have no problem connecting to the MySQL
data base and doing any of the other things I want to do with the data.

I want to thank you again for all of your help, including your book "PHP for
Dreamweaver 8", I've found it very useful.

Jeff

"David Powers" <david@example.com> wrote in message
news:efhim2$m54$2@forums.macromedia.com...
> Jeff wrote:
>> Needless to say the "#1045 - Access denied for user: 'wmevents@localhost'
>> (Using password: YES)"
>> has not been solved.
>
> That means that the username and/or the password is incorrect.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/