Re: [PHP-DB] Trigering PHP Code

2004-12-29 Thread Jeffrey Moss
Or, you could use XmlHttpRequest, which is what google suggest uses. http://www.google.com/webhp?complete=1 You can use this to dynamically populate a section of the page. I wouldn't delve into it unless you have some xml/javascript experience also though. Try this page for more info: http://www.

Re: [PHP-DB] how many databases should I create

2004-10-18 Thread Jeffrey Moss
Matter of preference really. Do you put all your files in one directory? I do for the most part, but when it comes to security you can divy out access to different databases rather than each table and it makes things simpler, so I use different databases for different projects. Also, I think you

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-03 Thread Jeffrey Moss
> Doesn't do Firebird yet ;) - but it looks interesting. As long as it has > not made the mistake of using MySQL as the SQL standard. Many other > packages are simply MySQL wrappers with cobbled support for a couple of > other engines. I was curious about Firebird as I've heard it mentioned a lot

Re: [PHP-DB] help with mySQL- Fatal error: Call to undefined function mysql_connect()...

2004-08-17 Thread Jeffrey Moss
(http://www.macromedia.com/devnet/mx/dreamweaver/articles/php_iis.html) -Jeff - Original Message - From: "Jeffrey Moss" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 17, 2004 12:08 PM Subject: Re: [PHP-DB] help with mySQL- Fatal error: Call to undef

Re: [PHP-DB] help with mySQL- Fatal error: Call to undefined function mysql_connect()...

2004-08-17 Thread Jeffrey Moss
Gotta recompile php with the --with-mysql option (or something like that). Try running configure --help You can see what options you compiled with by grepping for CONFIGURE in your Makefile. Here's what I got: [EMAIL PROTECTED] php-5.0.0b4 # grep CONFIGURE Makefile CONFIGURE_COMMAND = './configu

Re: [PHP-DB] Checkbox Array Question - Iteration

2004-08-17 Thread Jeffrey Moss
Well, you should come up with a definitions table. Create an array out of the definitions table (I'd recommend keeping everything in one array, for recursive efficiency). Then go over THIS array, and check for the existence of variables in the form array. That way you can output all the checkboxes

Re: [PHP-DB] FULLTEXT and LIKE

2004-07-22 Thread Jeffrey Moss
Well, like will do a full table scan if it starts with a wildcard, so you dont want to do it that way. I'd do full text search. http://dev.mysql.com/doc/mysql/en/MySQL_indexes.html -Jeff - Original Message - From: "Monty" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July

Re: [PHP-DB] Read a PDF file via PHP

2004-06-25 Thread Jeffrey Moss
Steve, You must turn the file to postscript before you can read anything out of it, and even then, a lot of the time words are broken up into different "show" statements. use pdf2ps (part of GNU GhostScript) to convert to PS and then search for patterns like this: (text) show that is the most bas

Re: [PHP-DB] mysql went away

2004-05-13 Thread Jeffrey Moss
I would start by seeing if the files are there after you create/load the table. It should by default create a file for each table you create. Sounds to me like a problem reading the disk. If you don't find any answers on your own, post your system specs to the MySQL lists. You could also try verbo

Re: [PHP-DB] search engines

2004-04-29 Thread Jeffrey Moss
Read up on MySQL full text search. http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html -Jeff - Original Message - From: "redhat" <[EMAIL PROTECTED]> To: "phplist" <[EMAIL PROTECTED]> Sent: Thursday, April 29, 2004 10:12 AM Subject: [PHP-DB] search engines > Anyone out there know of

Re: [PHP-DB] pdf editor

2004-04-07 Thread Jeffrey Moss
I think someone else asked about a problem where they had text running off the side of the page, heres everything I've ever learned about PS/PDF. GNU ghostscript is all you really need for editing pdf's. Usually the text appears as plain text once you convert the PDF to a PS with pdf2ps, and you c

Re: [PHP-DB] password input type

2004-04-05 Thread Jeffrey Moss
It is possible to md5 encrypt a password before you send it off to the server using javascript onSubmit function. Check this code out: http://pajhome.org.uk/crypt/md5/ -Jeff Moss - Original Message - From: "matthew perry" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 05

[PHP-DB] sybase support in PHP5

2004-03-01 Thread Jeffrey Moss
Is Sybase support in PHP5 working? I get: /bin/sh /usr/portage/tmp/php-5.0.0b3/libtool --silent --preserve-dup-deps --mode=compile gcc -Iext/sybase/ -I/usr/portage/tmp/php-5.0.0b3/ext/sybase/ -DPHP_ATOM_INC -I/usr/portage/tmp/php-5.0.0b3/include -I/usr/portage/tmp/php-5.0.0b3/main -I/usr/port

Re: Re[2]: [PHP-DB] Optimising LIMITs

2004-03-01 Thread Jeffrey Moss
> JM> Primary keys aren't any faster than normal keys. They're simply for > JM> identification. (correct me if I'm wrong, that is my understanding) > JM> If you don't already have an index on created, I'd do that. > > I do - here's a question though, what is the best way to have an > index? To comb