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 upd
On 12/12/2011 01:49 PM, Stephen wrote:
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 '
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 wrote:
> So I am getting this SQL error:
>
> Error selecting photographs: SQLSTATE[42000
On Mon, Dec 12, 2011 at 4:22 PM, FeIn 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: http://www.php.net
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 t
On Mon, Dec 12, 2011 at 5:56 PM, 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
>
It might be related to ti
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 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
> comprised of
>
On Mon, Dec 12, 2011 at 1:06 PM, David Savage 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 there were
10 matches
Mail list logo
