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

Re: [PHP-DB] MySQL Insert

2004-01-07 Thread ma
hi there are several ways of saving the data within a file. you can save it plain or binary. if you want to save a file in the db i suggest using the field-type BLOB short example: to create the table: CREATE TABLE `files` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `fileName` VARCHAR(255)

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-DB] MySQL Ins

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

2002-05-01 Thread [EMAIL PROTECTED]
I'm not sure what you're asking but the fields are set to varchar(40) which will accommodate the information I have been insertinging... /T on 4/30/02 9:00 PM, Neil at [EMAIL PROTECTED] wrote: > Have you checked to see that id tidying is set to the amount equal to the > fields in your form. >