Posted by Schraalhans Keukenmeester on 04/13/07 09:27

strawberry wrote:
> On Apr 13, 9:08 am, Schraalhans Keukenmeester <bitbuc...@invalid.spam>
> wrote:
>> strawberry wrote:
>>> On Apr 13, 1:51 am, "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 ";
>>>> }
>> You're reposing the question? Or ?
>>
>
>
> No. I just wanted to get the thread into comp.lang.php too
>
The hardcoded version has single quotes around key and value, your $_GET
parsed version hasn't in this example. Could that be the cause? Does the
query run with results if NO conditions are set?

Sh.

[Back to original message]