Posted by strawberry on 04/13/07 10:52

On Apr 13, 11:10 am, "Captain Paralytic" <paul_laut...@yahoo.com>
wrote:
> On 13 Apr, 01:51, "strawberry" <zac.ca...@gmail.com> wrote:
>
>
>
> > I'm trying to extend a class (written by others) and was wondering if
> > there's a standard a way of passing a $_GET request to a class. Here's
> > what I have (see below). If I hardcode $where, something like
>
> > $where = " WHERE `firstname` = 'John' "
>
> > and then pass it as an argument into the scope of a 'select' function
> > then it works fine, but otherwise the query just appears to hang.
>
> > I'm deliberately not including the class or class extender at this
> > stage, but I'll add them to this thread later if required.
>
> > foreach ($_GET as $condition_key => $condition_value) {
> > $condition[] =" $condition_key = '$condition_value' ";
> > }
> > if(is_null($condition)){
> > $where = " WHERE 1 ";
> > }else{
> > $conditionString = implode('AND', $condition);
> > $where = " WHERE $conditionString ";
> > }
>
> echo the final query and pop it into phpmyadmin. One thing I notice is
> that you are not puting backtics round the field name ($condition_key)
> in your loop.

You read my mind :-)

[Back to original message]