how to use criteria()

[marvoh]

i'm still in my baby steps in symfony so not so familiar with the criteria object.

anyone care to help me convet the below sql?

select license, count(license), browser, ip, created_on from stats group by license order by count(license) desc

[Phoelis]

hmm try this :

Code: Select all

$c = new Criteria();
$c->addGroupByColumn(StatsPeer::LICENSE);
$c->addAsColumn('mycount', ' COUNT( '.StatsPeer::LICENSE.' )');

$myResult= StatsPeer::doSelect($c);


[marvoh]

thanks, had figured that out after a few searches on the internet. now i have an almost same dilema..

i have the following code which works fine on my localhost..
$connection = Propel::getConnection();
$query = "SELECT COUNT(*) AS count FROM stats WHERE license LIKE '".$param1."' AND MONTH(created_on) = '".$param2."'";
$statement = $connection->prepareStatement(sprintf($query, StatsPeer::TABLE_NAME));
$resultset = $statement->executeQuery();
$resultset->next();
return $resultset->getInt('count');

and evaluates to the following sql: SELECT COUNT(*) AS count FROM stats WHERE license LIKE 'LC1234' AND MONTH(created_on) = '6'

however, on the webserver, the query is a little different thus making it not run, here's the sql: SELECT COUNT(*) AS count FROM stats WHERE license LIKE 'LC1234' AND MONTH('stats.CREATED_ON') = '6'

where are these quotes ('stats.CREATED_ON') coming from..

[marvoh]

im trying to use propel to solve the above issue:
here's my sql:
SELECT COUNT(*) AS count FROM %s WHERE browser LIKE '".$param1."' AND MONTH(created_on) = '$param2'

then here's my code using criteria object
$c = new Criteria();
$c->addAsColumn('hits', 'MONTH(created_on)');
$c->add(StatsPeer::LICENSE_ID, $param1, CRITERIA::LIKE );
$c->add('hits', $param2, CRITERIA::EQUAL );
return StatsPeer::doCount($c);

this evaluates to something totally different. hope it wont take ages to get help like it usually does here otherwise i will be time barred

[halfer]

hope it wont take ages to get help like it usually does here

Problem is, I read that phrase and am put off helping you straight away. We do have the problem on the fora that the ratio of requests to respondents is not good, and also the core developers are pushing the mailing list groups in favour of this forum system. But nevertheless, I do recommend that you should be careful how you ask for assistance!

[ktoso]

Might be usefull in learning to build propper propel queries: http://propel.jondh.me.uk/