Re: using COUNT with CGI



On Apr 27, 8:49 pm, mmccaws2 <mmcc...@xxxxxxxxxxx> wrote:

Subject: using COUNT with CGI

You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right
syntax to use

You also have an error in your ability you correctly partition
problems. This problem is not related to Perl nor to CGI.

You have an error in your SQL syntax. The best advice I can offer is
that you should check the manual that corresponds to your MySQL server
version for the right syntax to use.

Hint: what do you think COUNT() in SQL does? Compare this with the
description of what it actually does in any book on SQL.

.



Relevant Pages

  • Re: Php MySQL query wont work..syntax error..help!
    ... corresponds to your MySQL server version for the right syntax to use ... SQL statements arround the calling function. ... whether multiple statements can be processed at once ...
    (comp.lang.php)
  • Re: Pulling data based on date time returns error
    ... check the manual that corresponds to your MySQL server version for the ... right syntax to use near '"Select Result from DataListing where ... I would guess that you have an error in your SQL syntax; ...
    (comp.lang.perl.misc)
  • Re: PDO/MYSQL Problem
    ... syntax; check the manual that corresponds to your MySQL server version ... You shouldn't use addslashes(). ...
    (comp.lang.php)
  • Re: MySQL has gone away
    ... though I don't know how to interprete these ... the manual that corresponds to your MySQL server version for the right ... syntax to use near '‘SET NAMES utf8′' at line 1 ...
    (Fedora)
  • Re: batch update
    ... from thr local DB I do a select query and while the select query run ... if I use a print instead of the sql update query everything work fine ... the manual that corresponds to your MySQL server version for the right ...
    (perl.dbi.users)