Brendan, Thanks for the quick response. I tried the command but I can't tell if it has created a file. That is I can't find one. Is their anyway to tell it to write to a certain directory. I don't have direct access to my MySQl directory as Iam on a shared server.
I tried:
mysql> mysql -u...
Is there a way to extract/export the contenets of a MySQL table into a coma delimited text file for use with MS Excel?
If yes. What are the commands?
Thanks,
Ray
Steve, Thanks for the insightful comments. I came to the same conclusion, fortunately before I did any XML work for my client. He seems satisfied with the normal php/mysql report I came up with.
Again Thanks and Happy New Years.
Ray
Specifically, I have set up a login with session information set to the user Id. What I want to do is after logging in with the user id and the viewer is on a specific page how do you get just one cell from one row of a MySQL db to display it's contents in the page with the user id as the...
Actually, the client was driving this. Their management attended a lecture or something and heard all the hype about XML. Their intranet is a unix/apache server with MySQL.
I've just been trying to see if it is doable.
For now we will only be producing a static report that will display information from a database in xml. Not sending information to the database.
Specifically, an employees benefits statement that he can login to and view. No imput from the employee other than a login and pasword for his/her...
Great! I have php4 installed on my server with mysql. Do you know of any resources/references that discuss using php and xml to querry mysql?
Any help would be appreciated.
Ray
Actually, we are considering using Cocoon from Apache.org which retrieves data from the database with a SQLProcessor module which uses JDBC.<br><br>Are you familiar with this particular middle ware? If so is there anything I should watch out for?<br><br>Thanks,<br><br>Ray
We have a unix machine running the Apache server with MySql installed. We plan to use the tcp/ip protocol. We have enabled the mime type for XML for viewing of XML documents. <br><br>We plan to target the IE5 browser as this will be on a company wide Intranet and all the...
Pete, thanks for the quick reply. As you can probably tell from my original post I'm new to this. Can one build an online report using XML that would display information contained in a MySQL database. There would not need to be any calculations...
I have done a lot of searching and can not find XML and MySQL in the same sentance. Is their a way for an XML document to use MySQL as its data source?<br><br>Any references, suggestions would be greatly appreciated.
I have done a lot of searching and can not find XML and MySQL in the same sentance. Is their a way for an XML document to use MySQL as its data source?<br><br>Any references, suggestions would be greatly appreciated.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.