Re: [PHP-DB] Re: Exporting Data From MySQL Using PHP

2004-08-09 Thread Peter Ellis
It seems to me that, at least in terms of consistency, using backticks isn't a bad idea. After all, if you look at any current version of phpMyAdmin that generates PHP selection code, it uses backticks constantly. I take your point, but it seems to me like it's a good habit no matter what. Perha

[PHP-DB] Re: Exporting Data From MySQL Using PHP

2004-08-09 Thread Guus der Kinderen
Ron Piggott wrote: > I was able to get the command: > > SELECT e_mail > FROM subscriptionsdatabase > WHERE discipleship_mailing_list_e_mail_subscription > LIKE 'on' > > to work in the mySQL command prompt but when I put it into a .PHP file I get > a parse error. I get that parse error by simply c

Re: [PHP-DB] Re: Exporting Data From MySQL Using PHP

2004-08-09 Thread Jason Wong
On Tuesday 10 August 2004 11:34, Peter Ellis wrote: > It has been my experience that you sometimes need to do backquotes (`) > in MySQL queries when cutting/pasting into PHP -- it's the same key as > the tilde (~) on my keyboard. Try: > > $result = mysql_query("SELECT e_mail FROM subscriptionsdat

Re: [PHP-DB] PHP and mysql script error in webhosting

2004-08-09 Thread Robby Russell
On Mon, 2004-08-09 at 20:45, Sukanto Kho wrote: > Hi all, > > My php files run well in my local PC > but some of PHP and mysql script just getting error when running in webhosting > server. > > I found out that the problem is in the way webhosting server handling global > variable. > for exam

[PHP-DB] PHP and mysql script error in webhosting

2004-08-09 Thread Sukanto Kho
Hi all, My php files run well in my local PC but some of PHP and mysql script just getting error when running in webhosting server. I found out that the problem is in the way webhosting server handling global variable. for example : In my local PC : $_GET['var'] is different with $var

Re: [PHP-DB] Re: Exporting Data From MySQL Using PHP

2004-08-09 Thread Peter Ellis
Whoops -- the fclose() statement refers to $result when it should refer to $handle. My bad for not at least spot checking the message before hitting send! -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis | http://www.naturalaxis.com/ On Mon, 2004-08-09 at 20:3

Re: [PHP-DB] Re: Exporting Data From MySQL Using PHP

2004-08-09 Thread Peter Ellis
It has been my experience that you sometimes need to do backquotes (`) in MySQL queries when cutting/pasting into PHP -- it's the same key as the tilde (~) on my keyboard. Try: $result = mysql_query("SELECT e_mail FROM subscriptionsdatabase WHERE `discipleship_mailing_list_e_mail_subscription` LI

[PHP-DB] Re: Exporting Data From MySQL Using PHP

2004-08-09 Thread Ron Piggott
It is a problem having write access to the file. This is what the online mySQL manual says ... The SELECT ... INTO OUTFILE 'file_name' form of SELECT writes the selected rows to a file. The file is created on the server host, so you must have the FILE privilege to use this syntax. The file cann

RE: [PHP-DB] Intellectual property rights

2004-08-09 Thread Robby Russell
This question sounds like a perfect discussion for Slashdot. ;-) I bet you would get a lot of typical dumb comments, but a few people might have some very valuable legal information in regards to this issue. Would be worth posting on the /. message board to see the feedback. -Robby On Mon, 2004-

[PHP-DB] Re: MAIL() help needed :-(

2004-08-09 Thread Manuel Lemos
Hello, On 08/09/2004 01:25 AM, Chris Payne wrote: I'm having a major problem. I'm trying to send a message FROM Windows XP Pro, now this is where it get weird - in some mail packages it WORKS, and in some it doesn't. Basically it's an HTML email which is sent when a form is completed, the results

RE: [PHP-DB] Intellectual property rights

2004-08-09 Thread Sunmaia
Hi A few thoughts. You are in a difficult position and the approach will depend your company and their ethics. At the worst you are screwed. They may offer you nothing. At this stage you may face a choice of legal battle or to walk away. To win a legal battle you would need to prove ownersh

Re: [PHP-DB] RE: [SPAM] Re: [PHP-DB] Intellectual property rights

2004-08-09 Thread Justin Patrin
On Mon, 9 Aug 2004 19:47:53 -0400, Vincent Jordan <[EMAIL PROTECTED]> wrote: > Michael, > > I did not sign a contract, NDA, or any other paperwork when I was hired. > Just the standard government IRS / Tax stuff. I do not work in the IT > department nor does my position entail anything to do with

[PHP-DB] RE: [SPAM] Re: [PHP-DB] Intellectual property rights

2004-08-09 Thread Vincent Jordan
Michael, I did not sign a contract, NDA, or any other paperwork when I was hired. Just the standard government IRS / Tax stuff. I do not work in the IT department nor does my position entail anything to do with IT, programming, or any other technical task besides answering email. > -Original

Re: [PHP-DB] Intellectual property rights

2004-08-09 Thread Michael Gale
Hello, I am not sure what you could do .. but some companies have it in the contract you sign that all software you create or develop while you work for the company are property of the company. So you may have to prove that it was developed on your personal time not company if you deci

[PHP-DB] RE: [SPAM] RE: [PHP-DB] Intellectual property rights

2004-08-09 Thread Vincent Jordan
Granted this is a legal question however it is more of a world experience question. Im sure at least one person on this list had some experience with this type of matter. Im just trying to see if I have a leg to stand on or if I should chalk it up to life lessons learned > -Original Message---

RE: [PHP-DB] Intellectual property rights

2004-08-09 Thread Ed Lazor
You're asking a legal question and should contact an attorney. > -Original Message- > From: Vincent Jordan [mailto:[EMAIL PROTECTED] > Sent: Monday, August 09, 2004 4:03 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Intellectual property rights > > This is a bit off topic however it m

[PHP-DB] Re: Exporting Data From MySQL Using PHP

2004-08-09 Thread Guus der Kinderen
Hello Ron, If I understand correctly, you're asking what query to execute (and how to put the result in a textfile) to get the results you want? The first part is described thorougly in the mysql-manual (chapter 14.1.7 for example, search for the SELECT syntax or examples. You'll find it at htt

[PHP-DB] Intellectual property rights

2004-08-09 Thread Vincent Jordan
This is a bit off topic however it may be something people here have or will have the unpleasant opportunity to deal with. The company I work for has been having a problem tracking our customers warranty information and have used paper for items sent in for repair. I on my own time had created a we

RE: [PHP-DB] Excel Formulas

2004-08-09 Thread Gilmore, Corey (DPC)
> -Original Message- > From: Norma Ramirez [mailto:[EMAIL PROTECTED] > Sent: Monday, August 09, 2004 4:54 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Excel Formulas > > Hi all, I need to integrate an aplication runing under Linux > and postgresql with Excel formulas, I mean while I in

[PHP-DB] Excel Formulas

2004-08-09 Thread Norma Ramirez
Hi all, I need to integrate an aplication runing under Linux and postgresql with Excel formulas, I mean while I insert records in a table, for some of that records I need to calculate values using a Formula from excel, does any one know if that's posible, call any kind of function in excel for thos

[PHP-DB] Re: Timeout problem

2004-08-09 Thread Guus der Kinderen
Hello Mauro, There are several scripts available for performing database-backups. You can find more information for mysql here: http://dev.mysql.com/doc/mysql/en/Backup.html Why re-invent the wheel? Hope this helps. Regards, Guus der Kinderen Mauro Chojrin wrote: Hi: I'm developing a d

[PHP-DB] Re: MAIL() help needed :-(

2004-08-09 Thread Guus der Kinderen
Chris, Instead of: > mail($to_email, $subject, '', $headers); Try this: > mail($to_email, $subject, $body_html, $headers); Get the $body_html out of $headers too. Regards, Guus der Kinderen Chris Payne wrote: Hi there everyone, I'm having a major problem. I'm trying to send a message F

[PHP-DB] Using global variables in mysqli-extended class

2004-08-09 Thread Guus der Kinderen
Could someone confirm or deny this? I'm running php5.0.0 with mysqli extention as a Apache2 module on a Windows XP box. I've tested the database by querying it with mysqli (procedural) and results are coming back just fine. This makes me believe that the mysqli-extention is working properly. R

Re: [PHP-DB] PHP sitemap

2004-08-09 Thread Ruprecht Helms
Dermot Mc Laughlin wrote: Hi, Is it possible/easy to create a simple sitemap page using PHP which would automatically parse all files and directories from index.html and create a structured HTML document from the results? seams to be possible. It's some code to write. You need something to store