Re: [PHP-DB] MySQL Insert via SQL?

2004-01-07 Thread ma
ed, 07 Jan 2004 21:52:23 -0500 > An: [EMAIL PROTECTED] > Cc: PHP-DB <[EMAIL PROTECTED]> > Betreff: Re: [PHP-DB] MySQL Insert via SQL? > > ma wrote: > >> just a question: don't know it exactly: isn't it possible that the sql-user >> on the server may not

Re: [PHP-DB] MySQL Insert via SQL?

2004-01-07 Thread John W. Holmes
ma wrote: just a question: don't know it exactly: isn't it possible that the sql-user on the server may not have enough rights to read the file? Yeah, could be. The uploaded file is already somewhere that PHP can write to, though, so it's more than likely available for reading by any other user.

Re: [PHP-DB] MySQL Insert via SQL?

2004-01-07 Thread ma
uot;John W. Holmes" <[EMAIL PROTECTED]> > Antworten an: [EMAIL PROTECTED] > Datum: Wed, 07 Jan 2004 21:29:20 -0500 > An: Will W <[EMAIL PROTECTED]> > Cc: PHP DB <[EMAIL PROTECTED]> > Betreff: Re: [PHP-DB] MySQL Insert > > Will W wrote: > >> Can

Re: [PHP-DB] MySQL Insert

2004-01-07 Thread John W. Holmes
Will W wrote: Can anyone tell me how to insert a file, say a .doc, .txt or a .rtf file into a table from an upload form?? How about just this: $query = "INSERT INTO Table (orig_name, size, mime_type, data) VALUES ('{$_FILES['userfile']['name']}', '{$_FILES['userfile']['size']}', '{$_FILES['use

Re: [PHP-DB] MySQL Insert

2004-01-07 Thread ma
t;Will W" <[EMAIL PROTECTED]> > Antworten an: [EMAIL PROTECTED] > Datum: Wed, 7 Jan 2004 21:03:40 -0500 > An: <[EMAIL PROTECTED]> > Betreff: Re: [PHP-DB] MySQL Insert > > Thanks!!! :) > > For getting the info from the database is it like all the rest or is there

Re2: [PHP-DB] MySQL Insert

2004-01-07 Thread ma
hi! just to add: use file() only if you run php 4.3.0 or higher. if this is not the case use this syntax (its binary safe): $fp = fopen($_FILES['myFile']['tmp_name'], 'r'); # on windows use 'rb' instead of 'r' $data = fread($fp, file_size($_FILES['myFile']['tmp_name'])); fclose($fp); instead o

Re: [PHP-DB] MySQL Insert

2004-01-07 Thread ma
<[EMAIL PROTECTED]> > Antworten an: [EMAIL PROTECTED] > Datum: Wed, 7 Jan 2004 20:21:15 -0500 > An: "PHP DB" <[EMAIL PROTECTED]> > Betreff: [PHP-DB] MySQL Insert > > Hello Everyone, > Can anyone tell me how to insert a file, say a .doc, .txt or a .rtf file

[PHP-DB] MySQL Insert

2004-01-07 Thread Will W
Hello Everyone, Can anyone tell me how to insert a file, say a .doc, .txt or a .rtf file into a table from an upload form?? Thanks in advance, ~~Will~~

Re: [PHP-DB] MySQL Insert Select statement

2002-10-19 Thread Jeffrey_N_Dyke
<[EMAIL PROTECTED]> 10/19/2002 08:32 PM cc: Please respond to Subject: Re: [PHP-DB] MySQL Insert Select stateme

Re: [PHP-DB] MySQL Insert Select statement

2002-10-19 Thread dwalker
thers. -Original Message- From: John W. Holmes <[EMAIL PROTECTED]> To: 'dwalker' <[EMAIL PROTECTED]>; 'professional php' <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Saturday, October 19, 2002 7:24

RE: [PHP-DB] MySQL Insert Select statement

2002-10-19 Thread John W. Holmes
That's how you do it. Hopefully you've figured it out already. ---John Holmes. -Original Message- From: dwalker [mailto:dwalker@;healthyproductsplus.com] Sent: Saturday, October 19, 2002 7:51 PM To: professional php; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP

[PHP-DB] MySQL Insert Select statement

2002-10-19 Thread dwalker
While reading the MySQL manual for INSERT SELECT, I was not able to determine how to include all 5 fields of one table into another table (containing 100 fields) into SPECIFIC data fields.  Do I need to explicitly list all the fields within the table of 5 fields?  If so, would the statement

Re: [PHP-DB] MYSQL: INsert html form data;

2002-05-01 Thread [EMAIL PROTECTED]
lds in your form. > - Original Message - > From: "Info_Best-IT" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, April 30, 2002 4:56 PM > Subject: [PHP-DB] MYSQL: INsert html form data; > > >> I have a problem writing form data to

[PHP-DB] MYSQL: INsert html form data;

2002-04-30 Thread Info_Best-IT
I have a problem writing form data to a table in MySQL. I have an action.php file that it called when the information is submitted and it looks something like this: Thanks for submitting your name and e-mail, I will contact you soon to discuss your interest in more detail. I can tell the fil