sorry, maybe not clear :
SELECT id,title,url, 'review' = $filter AS ...
On Sep 3, 9:26 pm, francky06l <[EMAIL PROTECTED]> wrote:
> On Sep 3, 6:38 pm, Charlie van de Kerkhof <[EMAIL PROTECTED]>
> wrote:
> SELECT id,title,url, 'review' = $review AS ...
>
> > Thnx Franck06l, but then it the SQL thinks it is a field in the
> > database which it is not.
> > I want to have the '$filter' as a field VALUE in every item in the
> > result array, so I can use it in my template.
>
> > I also tried:
> > $sQuery = "SELECT id,title,url,CONCAT('$filter') AS
> > filter,modified ".
> > "FROM $filter AS $filter ".
> > "WHERE status=1 AND $field IN ($ids) ".
> > "ORDER BY modified DESC";
>
> > but no luck.
>
> > On Sep 3, 6:31 pm, francky06l <[EMAIL PROTECTED]> wrote:
>
> > > Maybe removing the quote around '$filter' (in the SELECT fields) will
> > > avoid this.
>
> > > On Sep 3, 6:17 pm, Charlie van de Kerkhof <[EMAIL PROTECTED]>
> > > wrote:
>
> > > > Hi,
>
> > > > In my model I do this:
> > > > $filter = 'reviews';
> > > > $field = 'artist_id';
> > > > $ids = '23,46';
> > > > $sQuery = "SELECT id,title,url,'$filter',modified ".
> > > > "FROM $filter AS
> > > > $filter ".
> > > > "WHERE status=1 AND
> > > > $field IN ($ids) ".
> > > > "ORDER BY modified
> > > > DESC";
> > > > $res = $this->query($sQuery);
> > > > pr($res);
>
> > > > And the output of the pr() function is this:
> > > > Array
> > > > (
> > > > [0] => Array
> > > > (
> > > > [reviews] => Array
> > > > (
> > > > [id] => 1
> > > > [title] => Title 1e review
> > > > [url]
> > > > =>http://charlie.vdkerkhof.com/2007/02/24/bijna/
> > > > [modified] => 2007-08-23 16:48:34
> > > > )
>
> > > > [0] => Array
> > > > (
> > > > [reviews] => reviews
> > > > )
>
> > > > )
>
> > > > [1] => Array
> > > > (
> > > > [reviews] => Array
> > > > (
> > > > [id] => 3
> > > > [title] => Review 2
> > > > [url]
> > > > =>http://charlie.vdkerkhof.com/2007/02/24/bijna/
> > > > [modified] => 2007-08-23 16:48:34
> > > > )
>
> > > > [0] => Array
> > > > (
> > > > [reviews] => reviews
> > > > )
>
> > > > )
>
> > > > );
>
> > > > Why does my field '$filter' is pout in a different array then the rest
> > > > of the query?
> > > > anyone?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
