Re: [PHP-DB] Loading large volumes of data

I feel a bit stupid now. Indexing the table works super fast by comparison. No idea what made me think the overhead on updating the index was going to outweigh the benefits. Anyway, thanks for the advice. - Original Message - From: "graeme" <[EMAIL PROTECTED]> To: "

[PHP-DB] Loading large volumes of data

help, comments, etc, appreciated as always. Thanks Evan Morris [EMAIL PROTECTED] Tel: +27 11 797 3840 Fax: +27 11 803 0211 Cell: +27 82 926 3630 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Weird problem posting to database

Setup: Apache, PHP, Firebird backend Problem: PHP will not allow text boxes to POST more than about 1k. Page just hangs. Already checked: php.ini, max_post_size is 8M. Nothing referring to POST limitations in httpd.conf Any thoughts? Thanks Evan Morris [EMAIL PROTECTED] +27 11 792 2777 (t

[PHP-DB] Insane CPU usage on Firebird v 1.0

ughts, insights, guru-like solutions, etc, appreciated. Thanks Evan Morris [EMAIL PROTECTED] +27 11 792 2777 (t) +27 11 792 2711 (f) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Optimizing query for public search engine -- SORT OF SOLVED

till seems like a clunky solution, but it has helped somewhat. - Original Message ----- From: "Evan Morris" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 26, 2003 12:01 PM Subject: [PHP-DB] Optimizing query for public search engine > Hi all > &g

[PHP-DB] Optimizing query for public search engine

o you resolve this issue? Am I missing something obvious? Since almost every search results listing I have ever seen contains this functionality, I assume the answer must be fairly simple and well-known. Anyone care to pass it on? Thanks Evan Morris [EMAIL PROTECTED] -- PHP Database Mailing

[PHP-DB] Apostrophe problem on Firebird

do* you solve this relatively simple problem? I want users to pass me data that may have apostrophes in it, and look for that data in a Firebird table. Evan Morris [EMAIL PROTECTED] +27 11 792 2777 (t) +27 11 792 2711 (f) - Is /usr/bin/perl related to /osama/bin/ladin? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] SQL Join problem (Firebird)

Hi all Say you have two tables, TABLE1 and TABLE2. Each table contains (amongst others) a field called SOMEVALUE Now, in TABLE1 SOMEVALUE contains "string1", but in TABLE2 SOMEVALUE contains "string2". Now you join these tables (on SOMEOTHERVALUE) and you loop through the results set: while ($r

[PHP-DB] Configuring PHP with Firebird

uld point me to documentation about them. Thanks Evan Morris [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] How do I make PHP aware of Interbase/Firebird?

. Thanks Evan Morris [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Interbase queries

? Thanks Evan Morris [EMAIL PROTECTED] Tel: +27 11 792 2777 Fax: +27 11 792 2711 Cell: +27 82 926 3630 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] hmmm

SAY WHAT? WHO ARE YOU TALKING TO? HAVE YOU GONE INSANE? IS YOUR MOTHER A GERBIL? DO YOU KNOW HOW STUPID YOU SOUND WHEN YOU SEND THESE UTTERLY BIZARRE, VERBALLY ABUSIVE NOTES FROM THE VOID TO AN ENTIRE MAILING LIST OF PEOPLE WHO HAVE NO IDEA WHAT YOU'RE TALKING ABOUT? AND USING CAPS ALL THE TIME IND

Re: [PHP-DB] More help with mysql -- solved (bizarre)

If I remove the '|| die' part from the mysql_query() statement, it works fine. This is bizarre, but there it is. ie, if I have: $result = mysql_query("SELECT * FROM SOME_TABLE"); it works. If I have: $result = mysql_query("SELECT * FROM SOME_TABLE") || die ("Unable to execute SQL query"); it

Re: [PHP-DB] More help with mysql

Since I'm new to PHP, this concept is new to me. What does the @ do and where do you put it? - Original Message - From: "Corne' Cornelius" <[EMAIL PROTECTED]> To: "Evan Morris" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, Febru

Re: [PHP-DB] More help with mysql

- Original Message - From: "Max 'AMiGo' Gashkov" <[EMAIL PROTECTED]> To: "Evan Morris" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, February 18, 2003 10:13 AM Subject: Re: [PHP-DB] More help with mysql > Possible error in S

[PHP-DB] More help with mysql

ant to do the simplest thing: get data out of a table and step through the results, displaying them one by one. Why is this hard? Evan Morris [EMAIL PROTECTED] Tel: +27 11 792 2777 Fax: +27 11 792 2711 Cell: +27 82 926 3630 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

m tempted to stop trying to learn PHP and build my entire web site using perl cgi instead. Thanks Evan Morris [EMAIL PROTECTED] Tel: +27 11 792 2777 Fax: +27 11 792 2711 Cell: +27 82 926 3630 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

tself. Hmm. I have put entries in the host table and the user table, using both hostname and ip address, but no luck. I keep getting the same error. What am I doing wrong? Any and all help appreciated. Thanks Evan Morris [EMAIL PROTECTED] +27 11 792 2777 (tel) +27 11 792 2711 (fax) -- PH