Posted by Captain Paralytic on 04/13/07 10:10

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.

[Back to original message]