Re: [PHP-DB] first 10 or so words

Or rather SUBSTRING_INDEX(str,delim,count) Because you want to use a custom delimiter (space, comma) Ignatius - Original Message - From: Peter Lovatt [EMAIL PROTECTED] To: Bruce Levick [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday,

[PHP-DB] The lists commands?

If you go the lists page (www.php.net/mailing-lists.phpand) there is a HERE link to get the command for managing your mailing list options. This link gives you a 404 error. There is an optional email address given that is supposed to cause the server to email back the commands, but instead it

Re: [PHP-DB] MySQL problem -- new to PHP

Thanks for all the help everyone sent me on this. However, nothing seems to make any difference whatsoever (except putting the 'localhost' part in quotes). I am still getting permission denied errors based on the user credentials. I have entered a user into the user table with host='localhost',

RE: [PHP-DB] How to access a MS Access DB

to set up a DSN go to control panel and then Administrative Tools then into Data Sources and then add a new system DSN. you can probably work the rest out as its fairly straight forward. -Original Message- From: Jonathan Villa [mailto:[EMAIL PROTECTED]] Sent: 13 February 2003 22:48 To:

[PHP-DB] Re: TXT files with fixed width

[EMAIL PROTECTED] (Pedro Oliveira) writes: I need to import a fixed width txt to a my sql database, I know how to do that with a coma separated value. any1 knows how i can do this easilly or know some software to do this? any help would be appreciated. *nix or windows? If the file is tab

Re: [PHP-DB] MySQL problem -- new to PHP

On Fri, 14 Feb 2003 11:30:03 +0200 [EMAIL PROTECTED] (Evan Morris) wrote: Thanks for all the help everyone sent me on this. However, nothing seems to make any difference whatsoever (except putting the 'localhost' part in quotes). I am still getting permission denied errors based on the user

RE: [PHP-DB] dump data, and save as a file

Header(Content-type: text/plain); Header(Content-Disposition: attachment; filename=topsellers_dvd.csv); Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com Hi everyone, I want to dump some data from mysql into a

Re: [PHP-DB] dump data, and save as a file

On Fri, 2003-02-14 at 03:09, Ruth Zhai wrote: Hi everyone, I want to dump some data from mysql into a file, and use php to force the browser to pop a download file window. This seems a simple procedure, but I am having trouble to make it work with IE. The following is what I did:

[PHP-DB] Question about replacing large textfields

Hi there, I'm looking for a way to let people without any knowledge of coding replace large fields of text and images on their website. Is there anyone who knows some way to do this with MySQL and PHP ? Maybe someone knows where I can find an online tutorial about this? Thanks a bunch

[PHP-DB] Re: Question about replacing large textfields

Wart, You can use Horde and Giapeto to achieve this. Giapeto is a Horde component that is written to give end users the ability to create and modify web sites through their web browser. You can obtain Horde and Giapeto from http://www.horde.org. You will have to obtain both from their

RE: [PHP-DB] How to access a MS Access DB

Ok, this is what I did... Keep in mind I have Xp so I don't know how this all pans out. 1. I opened the ODBC Data Source Administrator 2. My default view was User DSN 3. I clicked on System DSN 4. Clicked on Add 5. Choose Microsoft Access Driver (*.mdb) 6. Gave it a name of Killerspin_com2 7.

Re: [PHP-DB] Question about replacing large textfields

http://www.hotscripts.com/PHP/ One example: http://www.hotscripts.com/Detailed/9026.html Good luck, Doug On Fri, 14 Feb 2003 16:09:34 +0100, Ingen, Wart van wrote: Hi there, I'm looking for a way to let people without any knowledge of coding replace large fields of text and images on their

RE: [PHP-DB] How to access a MS Access DB

Not sure if it's at typo, but the DSN you created was Killerspin_com2 and the DSN you're trying to reference is killerspin_com. Also, if the Database already exists, don't use Create. Click Select. The location ofhte database isn't important, as long as the DSN can see it. You might want to put it

[PHP-DB] When to do free()?

Hello, I'm currently using pear DB to abstract out use of my mysql database. Everything is generally working fine, except that it seems that performance seems to degrade the more it is used, then I get my ISP to restart mysql and everything seems to be good again for a while, then it

[PHP-DB] Storing Boolean Values

I've been storing checkbox values in MySQL as Enum's for a while, I was wondering if there's a better way to do things. Is this the most compact way to store a boolean value? -Micah

RE: [PHP-DB] Storing Boolean Values

I would say using a 'tinyint' as either a 1 or 0 would be the same ... thats basically all a boolean TRUE or FALSE is, anyway. Regards, Matthew Moldvan --- System Administrator Trilogy International, Inc http://www.trilogyintl.com/ecommerce/

[PHP-DB] RE: your odbc problem can be solved

Great, the error message is gone so I am assuming that it have it right so far. Now, my question is on syntax and logic. I have a RecordSet class I use when I connection to a MySQL. It's basically like this: class RecordSet { //var name function RecordSet($sql) {

[PHP-DB] efficient next/prev page generation

Hey, One more on efficiency. Basically all the examples I've seen for doing 'windowed dbase queries' (i.e., displaying a limited set of results and providing next/prev paging capabilities) have the same basic format: 1.SELECT * FROM table 2. get the number of rows from result 3. figure out

[PHP-DB] Re: efficient next/prev page generation

Just reviewed my post (should do that *before* hitting submit ... sigh ). One minor note, which should be obvious, but just for completeness: David Chamberlin wrote: 1.SELECT * FROM table 2. get the number of rows from result 3. figure out paging scheme 4. SELECT desired data FROM table LIMIT

Re: [PHP-DB] efficient next/prev page generation

I think the first item should be COUNT(*), because as you mentioned it would be pretty inefficient to pull all the data just to get a count. In MySQL 4 you can move step 4 to step 1 with a slight modification and leave it at three steps. Lookup the FOUND_ROWS() function to find out all the

Re: [PHP-DB] efficient next/prev page generation

Hello, See http://www.pearfr.org/docs/dbpager.php?lang=en, a tutorial about PEAR::DB_Pager, which paging datas, from a DB result or a simple array. It can help you to find a good method. hth pierre -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Re: efficient next/prev page generation

SELECT COUNT(*) FROM table (only on initial page). Then pass that count from page to page. Then only one query will be necessary for subsequent page requests. The count will not always be accurate if records are added during the users visit. But it's a quicker solution. David Chamberlin

Re: [PHP-DB] dump data, and save as a file

Use Content-Type: application/octet-stream Gary Every [EMAIL PROTECTED] wrote: Header(Content-type: text/plain); Header(Content-Disposition: attachment; filename=topsellers_dvd.csv); Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 Pay It Forward mailto:[EMAIL