php-general Digest 12 Dec 2011 11:49:49 -0000 Issue 7607

2011-12-12 Thread php-general-digest-help
php-general Digest 12 Dec 2011 11:49:49 - Issue 7607 Topics (messages 315971 through 315980): Virus warning 315971 by: Ashley Sheridan 315972 by: Jason Pruim 315973 by: Daniel Brown 315974 by: HallMarc Websites 315975 by: Daniel Brown 315976

[PHP] Syntax problem PDO and bindvalue

2011-12-12 Thread Stephen
So I am getting this SQL error: Error selecting photographs: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''4'' at line 2 My code is: function

Re: [PHP] Syntax problem PDO and bindvalue

2011-12-12 Thread FeIn
I don't think you're suppose to end your queries with a semicolon. Try: $sql = SELECT * FROM photographs WHERE photo_filename LIKE '%2%' LIMIT 0, :q; On Mon, Dec 12, 2011 at 1:49 PM, Stephen stephe...@rogers.com wrote: So I am getting this SQL error: Error selecting

Re: [PHP] Syntax problem PDO and bindvalue

2011-12-12 Thread Fatih P.
On Mon, Dec 12, 2011 at 4:22 PM, FeIn aci...@gmail.com wrote: I don't think you're suppose to end your queries with a semicolon. Try: you can end your queries with semicolon in prepared statements. How can I see the prepared SQL statement before it is executed? try- var_dump ($statement);

[PHP] PHP 5.3.6 Dates

2011-12-12 Thread Floyd Resler
If this was already discussed I apologize for the duplicate question. For some reason dates of -00-00 get converted to 11/30/-0001 with the date function. Is this be design or a bug? Thanks! Floyd -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP] Re: PHP 5.3.6 Dates

2011-12-12 Thread Ian
On 12/12/2011 16:56, Floyd Resler wrote: If this was already discussed I apologize for the duplicate question. For some reason dates of -00-00 get converted to 11/30/-0001 with the date function. Is this be design or a bug? Thanks! Floyd Hi, In the past I have noticed that

Re: [PHP] PHP 5.3.6 Dates

2011-12-12 Thread Matijn Woudt
On Mon, Dec 12, 2011 at 5:56 PM, Floyd Resler fres...@adex-intl.com wrote: If this was already discussed I apologize for the duplicate question.  For some reason dates of -00-00 get converted to 11/30/-0001 with the date function.  Is this be design or a bug? Thanks! Floyd It might

[PHP] RE: php-general Digest 9 Dec 2011 20:09:28 -0000 Issue 7604

2011-12-12 Thread David Savage
I thought I posted this in the php.net web site under the ksort user notes, but I don't know if it would be approved to be placed in the web site. Would ksort($sortarr,SORT_STRING) on a 1 dimensional array with a key comprised of a person's name, -, and time stamp I..E. (key: david

Re: [PHP] RE: php-general Digest 9 Dec 2011 20:09:28 -0000 Issue 7604

2011-12-12 Thread Daniel P. Brown
On Mon, Dec 12, 2011 at 16:06, David Savage dsav...@cytelcom.com wrote: I thought I posted this in the php.net web site under the ksort user notes, but I don't know if it would be approved to be placed in the web site. Would ksort($sortarr,SORT_STRING) on a 1 dimensional array with a key

Re: [PHP] RE: php-general Digest 9 Dec 2011 20:09:28 -0000 Issue 7604

2011-12-12 Thread David Harkness
On Mon, Dec 12, 2011 at 1:06 PM, David Savage dsav...@cytelcom.com wrote: Would ksort($sortarr,SORT_STRING) on a 1 dimensional array with a key comprised of a person's name, -, and time stamp I..E. (key: david savage-2011-12-12 14:43:00) actually delete duplicate keys from the array, if