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:

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] 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

[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

[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