[RESOLVED] sql command .. ned help

Maribol

i have this command:

select sum(vizite) AS vizite30 from zi where site_id='1' LIMIT 30

..why doesn't limit my results?:mad:

rajeevbharti

hi friend there is a error in your code because LIMIT takes two parameter like this

SELECT * FROM your_table LIMIT 0, 10

Maribol

the problem is not that 🙂 .. you can limit with one or two numbers if u want.. it's the same thing

halojoy

Maybe:

$sql = "SELECT * FROM zi WHERE site_id=1 LIMIT 30";

Maribol

halojoy;10940041 wrote:
Maybe:
$sql = "SELECT * FROM zi WHERE site_id=1 LIMIT 30";

oh gush... i don't want to select results from db..in know how to do that.. i want to calculate them but i can't

halojoy

Calculate ..
Why you have LIMIT when you count visitors?????

If site_id is number, integer we use site_id=1
If is text we use 'text'

Maybe

$sql = "SELECT SUM(vizite) AS vizite30 FROM zi WHERE site_id=1";

johanafm

Your query always returns one row, so asking why it doesn't limit it to 30... makes little sense.

Well, if it was a count() I would agree with halojoy, now there might be a reason for executing a query like this, depending on what's in sum.
But anyway, to answer the question I believe you wanted answered

SELECT sum(vizite) FROM (SELECT visite FROM table LIMIT 30) AS t

Maribol

johanafm;10940047 wrote:
select sum(vizite) AS vizite30 from zi where site_id='1' LIMIT 30 will ALWAYS return 1 row, containing one field. Limit 30, or Limit 1 will not change this.

actually that is was my first type of select but the result was not limited

..anyway .. i made it to work.. i forgot i have to make two selections 🙂

@: i want to limit the results by 7 days, 30 day