[PHP-DB] DB Compaction Algorithm

2001-08-08 Thread Ben Bleything
Hello all... I'm going to propose an algorithm to compact a MySQL database containing information that I'll talk about shortly. I'm curious what you all think about it. Nevermind the various reasons why I should/should not do this, as I have weighed them in my head and decided that it's

[PHP-DB] cleaning up auto_increment fields

2001-08-05 Thread Ben Bleything
Hello all! Is it worth my time (both real and processor) to make my application find gaps in the auto_increment sequence (in MySQL) and fill them when I add new data? I'm concerned about overloading the capacities of my datatypes (although they are very liberal). I think it wouldn't be that

RE: [PHP-DB] Date Format

2001-07-19 Thread Ben Bleything
?php $date = 2001-07-19; // as if it just came from the db $date_array = explode('-',$date); $date = $date_array[1] . - . $date_array[2] . - . $date_array[0]; ? That should do it = Good luck! Ben -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: [PHP-DB] Question about strlen .. I think

2001-07-16 Thread Ben Bleything
You could split the string on the slashes with explode('/',$string) and then manipulate the array elements you get back. Good luck, Ben -Original Message- From: Dennis Kaandorp [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 15, 2001 9:21 AM To: [EMAIL PROTECTED] Subject: [PHP-DB]

RE: [PHP-DB] Hello

2001-07-12 Thread Ben Bleything
Check out http://www.phpbuilder.com/columns/florian19991014.php3. It deals with MySQL, but the concepts should be the same... it sounds like there are some steps about handling the binary data in a binary-safe fashion that are getting left out. Good luck, Ben -Original Message- From: a

RE: [PHP-DB] Warning: Page has Expired

2001-07-11 Thread Ben Bleything
Keith, I believe this happens because most browsers feel that it is important to regenerate any page that was generated with form input when you go 'Back' to it. Therefore, there's not much you can do about it... I suppose you could make links from the expiring page open in new windows, so

RE: [PHP-DB] Dynamic SQL + result resource error

2001-07-08 Thread Ben Bleything
Sure he is. Right here: $queryResult = mysql_query($sql); what exact error is occurring? -Original Message- From: Matthew Loff [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 08, 2001 5:00 PM To: 'Mark Gordon'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Dynamic SQL + result resource error

RE: [PHP-DB] Dynamic SQL + result resource error

2001-07-08 Thread Ben Bleything
Guess I'm just a big dumbass then, aren't I =P Oops. I suppose that would cause it to fail then, wouldn't it? = Ben -Original Message- From: Matthew Loff [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 08, 2001 5:10 PM To: 'Ben Bleything'; 'Mark Gordon'; [EMAIL PROTECTED] Subject: RE

RE: [PHP-DB] Control Structure Error

2001-07-08 Thread Ben Bleything
It works for me... except that you need a semi-colon after 'return $returned_string' and it sticks the word OR at the end of the whole string, which you may not want. Does that help, or did I miss the point? Ben -Original Message- From: Brad Lipovsky [mailto:[EMAIL PROTECTED]] Sent: