PHP SQL count

[r937]

this gives me an error

sorry, my Microsoft® CrystalBall© is down at the moment, you're going to have to tell me what the error was

any anyhow, you should be doing it this way for the sake of performance:

SELECT canada
     , COUNT(*) AS cnt
  FROM phpbb_buysell
 WHERE canada IN ('canada','usa','international')
GROUP
    BY canada

and if those are the only 3 values for the canada column, then you can drop the WHERE clause

yes, it gives you three rows, but reformatting them into one line is a job for the front end application language, not SQL

[iansteeze]

sorry, my Microsoft® CrystalBall© is down at the moment, you're going to have to tell me what the error was

any anyhow, you should be doing it this way for the sake of performance:

SELECT canada
     , COUNT(*) AS cnt
  FROM phpbb_buysell
 WHERE canada IN ('canada','usa','international')
GROUP
    BY canada

and if those are the only 3 values for the canada column, then you can drop the WHERE clause

yes, it gives you three rows, but reformatting them into one line is a job for the front end application language, not SQL

this is the error

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 'int' at line 16 [1064]

SQL

select * from ( select count(*) as canada_cnt from phpbb_buysell where canada ="canada" ) as canada cross join ( select count(*) as usa_cnt from phpbb_buysell where canada ="usa" )as usa cross join ( select count(*) as int_cnt from phpbb_buysell where canada ="international" )as int

BACKTRACE

[iansteeze]

Aaah it must have been because i was using "int"

[r937]

INT is a reserved word

change the last line to ... ) AS intq