Re: Upload and retrieval of stories?

First, you need to get the MySQL ODBC driver and create a system DSN (this is the data source) for your db. If you're not sure how to do this, it's a little complex to describe via e-mail but you should be able to find instructions on the mysql Web site. Once you've got your data source ready, in Access, file->get external data->link tables. Choose the odbc file type, then the data source. This will create a dynamic link to your original MySQL db but w an Access interface. Easy! --------------------------------------------------------- Conceive. Create. myClientManager.com. --------------------------------------------------------- - ----- Original Message ----- From: "Steven Katz" <steven@idma.com> To: "Dave Daniels" <dave@myclientmanager.com> Sent: Friday, September 15, 2000 11:53 AM Subject: RE: [PHP] Upload and retrieval of stories? > Thanks. Do you know of any good descriptions of how to use Access as > front end? > > > -----Original Message----- > From: Dave Daniels <dave@myclientmanager.com> > Sent: Friday, September 15, 2000 9:39 AM > To: Steven Katz; php-general@lists.php.net > Subject: Re: [PHP] Upload and retrieval of stories? > > > > The database I will most likely use is MySQL. If I choose not to build > > a web-based administrative interface at this stage, what are my > > other options for uploading the data? Are there any good visual > > administrative tools? > > What type of user is likely to be uploading the data? phpMyAdmin is a good > Web-based administrative tool (nothing for you to > build!)http://www.phpwizard.net/projects/phpMyAdmin/ Also, if > you have > Access, you can use that as a front end quite easily. Alternatively, you > could write a simple Perl script to import the data to your db. > > --------------------------------------------------------- > Conceive. Create. myClientManager.com. > --------------------------------------------------------- > > - > ----- Original Message ----- > From: "Steven Katz" <steven@idma.com> > To: <php-general@lists.php.net> > Sent: Friday, September 15, 2000 10:48 AM > Subject: RE: [PHP] Upload and retrieval of stories? > > > > Thanks for all of the help I've received. It sounds like storing > > everything in the database might be the best option here, after all. > > > > The database I will most likely use is MySQL. If I choose not to build > > a web-based administrative interface at this stage, what are my > > other options for uploading the data? Are there any good visual > > administrative tools? > > > > Also, if the entire story is contained within a single field of a > > record, how can I break it up into multiple pages, such as after a > > certain number of words? > > > > Steven > > > > > > -----Original Message----- > > From: Hans H. Anderson <me@hansanderson.com> > > Sent: Thursday, September 14, 2000 4:38 PM > > To: James Atkinson > > Cc: Steven Katz; php-general@lists.php.net > > Subject: Re: [PHP] Upload and retrieval of stories? > > > > > > I *think* the textarea limit is 64k, but it's probably browser (maybe even > > OS) dependent. > > > > Regardless, James' suggestion is probably the best. If you can have them > > upload an unformatted version in plain text, you'll be able to do a lot > > with it. Few novels I read take advantage of italics, bold, etc, so you > > are probably okay there. > > > > Hans > > > > > > On Thu, 14 Sep 2000, James Atkinson wrote: > > > > > A textarea should work, although I'm not sure what the > > > limit on them is...but I'm sure its pretty big. > > > > > > Alternitivly you can have your users upload plain text files containing > > the > > > stories then open the needed files when you want to display the story. > > > > -- > > Hans Anderson -=- me@hansanderson.com > > http://www.hansanderson.com | PHP, SQL Databases, Flash 5 > > Animation & > > http://www.goofiness.com | Programming, Audio > > Production, Brewmeister. > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >