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
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
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
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);
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:
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
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
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
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
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
10 matches
Mail list logo